phpBB.de

Code: Alles auswählen

phpBB : Kritischer Fehler 

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '' at line 4

SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '' AND u.user_id = s.session_user_id AND session_time > 

Line : 238
File : /mnt/ls6/06/187/00000021/htdocs/forum2/phpBB2/includes/sessions.php 

Code: Alles auswählen

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

Code: Alles auswählen

  Indizes : 
Name Typ Kardinalität Aktion Feld 
PRIMARY  PRIMARY  38   Löschen  Ändern  user_id  
user_session_time  INDEX  keine   Löschen  Ändern  user_session_time  

Code: Alles auswählen

# 
#-----[ FIND ]------------------------------------------ 
# 
if ( !empty($session_id) )
{
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
$expiry_time = $current_time - $board_config['session_length'] ;