Author: help, Posted: Wed Jun 18, 2003 7:46 am Post subject: Guests get error message
I installed a couple of MODS for phpbb and now when a guest enters the forum an error appears
phpBB : Critical Error
Error doing DB query userdata row fetch
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
// 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?
Author: mikem, Location: Corn fields of IndianaPosted: Wed Jun 18, 2003 8:04 am Post subject: Re: Guests get error message
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.