Suche

[hannover-jung]

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...

[NeMeSiSX2LC]

Das die view_option_2 function oder??

Wenn ja guck mal ob am Anfang der function was von

global $user_prefix, $prefix;

steht

[hannover-jung]

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');

[NeMeSiSX2LC]

 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

[hannover-jung]

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....

[NeMeSiSX2LC]

schau mal in der function bei global da müsste $prefix fehlen

[hannover-jung]

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... 

[NeMeSiSX2LC]

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

[hannover-jung]

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,

[NeMeSiSX2LC]

Dann guckdste nochmal genau da fehlt bestimmt ein } irgendwo

[hannover-jung]

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...