Guests get error message

Nuke Soldier Joined: Apr 24, 2003 Posts: 34

I installed a couple of MODS for phpbb and now when a guest enters the forum an error appears

Code:

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

SELECT u.*, s.* FROM nuke_bbsessions s, nuke_users u WHERE s.session_id = '' AND u.user_id = s.session_user_id AND session_time >
Line : 280
File : /home/arnolzh/public_html/includes/sessions.php

here's the session.php part referring to the error

Code:

//
   // session_id exists so go ahead and attempt to grab all
   // data in preparation
   //
   $sql = "SELECT u.*, s.*
      FROM " . SESSIONS_TABLE . " s, " . USERS_TABLE . " u
      WHERE s.session_id = '$session_id'
         AND u.user_id = s.session_user_id AND session_time > $expiry_time";
   if ( !($result = $db->sql_query($sql)) )
   {
      message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch', '', __LINE__, __FILE__, $sql);
   }

   $userdata = $db->sql_fetchrow($result);

could you help me pls? Sad

Posted: Wed Jun 18, 2003 8:04 am

You answered yourself here bud.

uninstall your MODS restore your original files.(obvious mis-installation of a mod is possible)
If the problem is gone then ATTEMPT to install your mods again, one ata time, checking after each to see if the error persists.

mikem