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 '' AND session_time > 1078025283' at line 4

SELECT u.*, s.* FROM newsite_sessions s, newsite_users u WHERE s.session_id = '1c8810262093fec89b2b1ad60322c85f' AND u.user_id = s.session_user_id' AND session_time > 1078025283

Line : 239
File : /www/htdocs/v086851/board/includes/sessions.php

Code: Alles auswählen

// End add - Last visit MOD
		//
		// 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);

		//
		// Did the session exist in the DB?
		//
		if ( isset($userdata['user_id']) )
		{

Code: Alles auswählen

AND session_time > $expiry_time"

Code: Alles auswählen

$userdata['user_lastvisit'] = $last_visit, user_lastlogon = " . time() .  ", user_totallogon=user_totallogon+1;

Code: Alles auswählen

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);