phpBB.de

Code: Alles auswählen

phpBB : Critical Error

Error updating last visit time

DEBUG MODE

UPDATE phpbb_users SET user_session_time = 1062101192, user_session_page = -13, user_lastvisit = 1062099938, user_lastlogon = 1062101192, user_totallogon=user_totallogon+1 WHERE user_id = 2

Line : 165
File : /home/www/web50142/html/phpBB22/includes/sessions.php

Code: Alles auswählen

//   if ( $user_id != ANONYMOUS ) 
//   {// ( $userdata['user_session_time'] > $expiry_time && $auto_create ) ? $userdata['user_lastvisit'] : ( 
      $last_visit = ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time; 

      $sql = "UPDATE " . USERS_TABLE . " 
         SET user_session_time = $current_time, user_session_page = $page_id, user_lastvisit = $last_visit, user_lastlogon = " . time() .  ", user_totallogon=user_totallogon+1 
         WHERE user_id = $user_id"; 
      if ( !$db->sql_query($sql) ) 
      { 
         message_die(CRITICAL_ERROR, 'Error updating last visit time', '', __LINE__, __FILE__, $sql); 
      } 

      $userdata['user_lastvisit'] = $last_visit; 

      $sessiondata['autologinid'] = ( $enable_autologin && $sessionmethod == SESSION_METHOD_COOKIE ) ? $auto_login_key : ''; 
      $sessiondata['userid'] = $user_id; 
//   } 

Code: Alles auswählen

phpBB : Critical Error

Error clearing sessions table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'some users might need to replace the 1062165361 with UNIX_TIMESTAMP() 1062' at line 2

DELETE FROM phpbb_sessions some users might need to replace the 1062165361 with UNIX_TIMESTAMP() 1062165361 - session_time >=172800 AND session_id <> 'f414066eef5376055ac5c006db8216a3'

Line : 294
File : /home/www/web50142/html/phpBB22/includes/sessions.php

Code: Alles auswählen

 some users might need to replace the 1062165361 with UNIX_TIMESTAMP()

Code: Alles auswählen

# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "DELETE FROM " . SESSIONS_TABLE . " 
WHERE session_time < $expiry_time 

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
session_time < $expiry_time
# 
#-----[ IN-LINE REPLACE WITH ]------------------------------------------ 
# 
some users might need to replace the ".time()." with UNIX_TIMESTAMP()
".time()." - session_time >=172800

Code: Alles auswählen

".time()." - session_time >=172800