und schon wieder ein kleines problem.... hab mir vor kurzem die friends/ignorlist besorgt und seitdem gibt es ein problem mit dem usergästebuch... user können sich zwar in das gästebuch eintragen, aber wenn user sich ihr eigenes gästebuch einsehen wollen spuckt er mit diese fehlermeldung raus....
Error sql_query():
qry: select tid, sid, subject from _comments where name='' order by tid DESC limit 0, 10
descr: Table 'usr_web511_2._comments' doesn't exist ( mysql 1146 )
details:
file: /home/www/web511/html/community4you/includes/mx_userfunctions_options.php # line: 678, cmd: sql_query(),
file: /home/www/web511/html/community4you/includes/mx_userfunctions.php # line: 30, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op...),
file: /home/www/web511/html/community4you/modules/Your_Account/navbar.php # line: 22, cmd: require_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph...),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 54, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 138, cmd: intro(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 210, cmd: viewguestbook(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules.php # line: 106, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar...., /home/www/web511/html/community4you/modules/UserGuest/index.php),
Error sql_num_rows():
descr: mysql_num_rows(): supplied argument is not a valid MySQL result resource
details:
file: /home/www/web511/html/community4you/includes/mx_userfunctions_options.php # line: 679, cmd: sql_num_rows(),
file: /home/www/web511/html/community4you/includes/mx_userfunctions.php # line: 30, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op...),
file: /home/www/web511/html/community4you/modules/Your_Account/navbar.php # line: 22, cmd: require_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph...),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 54, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 138, cmd: intro(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 210, cmd: viewguestbook(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules.php # line: 106, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar...., /home/www/web511/html/community4you/modules/UserGuest/index.php),
Error sql_query():
qry: select sid, title from _stories where informant='' AND `time` <= now() order by time DESC limit 0, 10
descr: Table 'usr_web511_2._stories' doesn't exist ( mysql 1146 )
details:
file: /home/www/web511/html/community4you/includes/mx_userfunctions_options.php # line: 681, cmd: sql_query(),
file: /home/www/web511/html/community4you/includes/mx_userfunctions.php # line: 30, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op...),
file: /home/www/web511/html/community4you/modules/Your_Account/navbar.php # line: 22, cmd: require_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph...),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 54, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 138, cmd: intro(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 210, cmd: viewguestbook(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules.php # line: 106, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar...., /home/www/web511/html/community4you/modules/UserGuest/index.php),
Error sql_num_rows():
descr: mysql_num_rows(): supplied argument is not a valid MySQL result resource
details:
file: /home/www/web511/html/community4you/includes/mx_userfunctions_options.php # line: 682, cmd: sql_num_rows(),
file: /home/www/web511/html/community4you/includes/mx_userfunctions.php # line: 30, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op...),
file: /home/www/web511/html/community4you/modules/Your_Account/navbar.php # line: 22, cmd: require_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph...),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 54, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 138, cmd: intro(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules/UserGuest/index.php # line: 210, cmd: viewguestbook(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar....),
file: /home/www/web511/html/community4you/modules.php # line: 106, cmd: include_once(/home/www/web511/html/community4you/includes/mx_userfunctions_op..., /home/www/web511/html/community4you/includes/mx_userfunctions.ph..., /home/www/web511/html/community4you/modules/Your_Account/navbar...., /home/www/web511/html/community4you/modules/UserGuest/index.php),
Ich vermute mal das es daran liegt das das gästebuch nach DB-Tabelle ohne den zusatz MX sucht..... aber wo kann ich das einstellen, hab die zeile im script nicht gefunden.... hoffe mir kann hier jemand helfen...
Das die view_option_2 function oder??
Wenn ja guck mal ob am Anfang der function was von
global $user_prefix, $prefix;
steht
meinst du die....
Function viewguestbook($touser){
global $prefix, $user_prefix, $bgcolor1, $bgcolor2;
$cookie = mxGetUserSession();
$qry = "SELECT gb.wer, gb.gid, gb.date, gb.text, gb.dummy, u.user_avatar, u.uname
FROM ".$prefix."_userguest AS gb LEFT JOIN ".$user_prefix."_users AS u ON gb.wer = u.uname
WHERE (((gb.touser)='$touser'))
ORDER BY gb.date DESC limit 0,1000";
$result = sql_query($qry);
include('header.php');
file: /home/www/web511/html/community4you/includes/mx_userfunctions_options.php # line: 678, cmd: sql_query(),
Ne der fehler müsste in einer function names view_option2 oder so ähnlich passieren
na dann wohl die...
// Listings
$result1 = sql_query("select tid, sid, subject from ".$prefix."_comments where name='".mxAddSlashesForSQL($uinfo['uname'])."' order by tid DESC limit 0,10");
$view1 = sql_num_rows($result1);
$result2 = sql_query("select sid, title from ${prefix}_stories where informant='".mxAddSlashesForSQL($uinfo['uname'])."' AND `time` <= now() order by time DESC limit 0,10");
$view2 = sql_num_rows($result2);
reicht es da aus wenn ich einfach das mx vorsetze.... aber irgendwie sehen die zeilen total unterschiedlich aus... einmal ist prefix in klammern und einmal nicht.. ist das richtig....
schau mal in der function bei global da müsste $prefix fehlen
in welcher zeile bzw. in welcher function denn hab es mal versucht einzufügen aber es ist nichts passiert, immer noch die gleiche fehlermeldung... bin ratlos... ::)
Zitat von: hannover-jung am 06 November 2004, 11:35:39
na dann wohl die...
// Listings
$result1 = sql_query("select tid, sid, subject from ".$prefix."_comments where name='".mxAddSlashesForSQL($uinfo['uname'])."' order by tid DESC limit 0,10");
$view1 = sql_num_rows($result1);
$result2 = sql_query("select sid, title from ${prefix}_stories where informant='".mxAddSlashesForSQL($uinfo['uname'])."' AND `time` <= now() order by time DESC limit 0,10");
$view2 = sql_num_rows($result2);
reicht es da aus wenn ich einfach das mx vorsetze.... aber irgendwie sehen die zeilen total unterschiedlich aus... einmal ist prefix in klammern und einmal nicht.. ist das richtig....
In der Funktion wo das steht müsste bei global (direkt darunter) $prefix fehlen
also ich glaub ich hab den fehler gefunden..... hab mir mal das orginal angeguckt.... da fehlten ja eine ganze reihe an zeilen.... ich habe diese aber niemals rausgelöscht..... also hab die jetzt wieder eingefügt.... und das fotoalbum läuft jetzt auch wieder.... dat hatte auch aufeinmal ne macke.... aber jetzt kommt folgende fehlermeldung....
Parse error: parse error in /home/www/web511/html/community4you/includes/mx_userfunctions_options.php on line 765
die zeile 765 ist aber praktisch die letzte zeile, da steht garnichts mehr drin,
Dann guckdste nochmal genau da fehlt bestimmt ein } irgendwo
oki doki..... ist passiert.... aber irgendwie ist da der wurm drin... jetzt habe ich oben im header ein kleines rotes F stehen...... stört zwar net weiter... aber währ schön wenn das auch noch wechgeht... :)