DELETE FROM phpbb_sessions WHERE
Verfasst: 18.11.2002 15:47
Hallo zusamen,
wie ist dieser Fehler zu beheben?
wie ist dieser Fehler zu beheben?
hier die session.phpDEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'UNIX_TIMESTAMP() - session_time >=172800 AND session_id <> 'eb733e9ac5fe' at line 2
DELETE FROM phpbb_sessions WHERE session_time UNIX_TIMESTAMP() - session_time >=172800 AND session_id <> 'eb733e9ac5fee79601dfb7f536a64506'
Line : 291
File : /home/animeh/public_html/xxxx/oooo/forum/includes/sessions.php
Danke im voraus für die Hilfe//
// Delete expired sessions
//
$expiry_time = $current_time - $board_config['session_length'];
$sql = "DELETE FROM " . SESSIONS_TABLE . "
WHERE session_time UNIX_TIMESTAMP() - session_time >=172800
AND session_id <> '$session_id'";
if ( !$db->sql_query($sql) )
{
message_die(CRITICAL_ERROR, 'Error clearing sessions table', '', __LINE__, __FILE__, $sql);
}
setcookie($cookiename . '_data', serialize($sessiondata), $current_time + 31536000, $cookiepath, $cookiedomain, $cookiesecure);
setcookie($cookiename . '_sid', $session_id, 0, $cookiepath, $cookiedomain, $cookiesecure);
}
return $userdata;
}
}
}
//
// If we reach here then no (valid) session exists. So we'll create a new one,
// using the cookie user_id if available to pull basic user prefs.
//
$user_id = ( isset($sessiondata['userid']) ) ? intval($sessiondata['userid']) : ANONYMOUS;