SOS - HELP ! Critical Error!

This mod will register when the user last logged in, allong with the info about how meny users have visited the board

Moderator: Moderators

Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

SOS - HELP ! Critical Error!

Postby macmaris on Fri 28. Jan, 2005 18:15

I have installed the Las visit Mod and get the following error:

phpBB : Critical Error
Error updating sessions table
DEBUG MODE
UPDATE phpbb_users SET user_session_time = 1106928456, user_session_page = 0 , user_totalpages = user_totalpages+1, user_totaltime = user_totaltime+(1106928456-1106928338) WHERE user_id = 2
Line : 293
File : /usr/local/psa/apache/vhosts/shavemate.de/httpdocs/adultcheck_ok/Board/includes/sessions.php

I had run the last_visit_db_update.php first and after that done the changes in the files.
Where ist my mistake?
macmaris
Poster
Poster
 
Posts: 1
Joined: Fri 28. Jan, 2005 15:54

Postby th3zone on Fri 04. Feb, 2005 14:37

i have the similar problem like u too...i run the last_visit_db_update.php again...but didnt help at all either.
th3zone
Poster
Poster
 
Posts: 8
Joined: Fri 04. Feb, 2005 10:03

Postby th3zone on Fri 04. Feb, 2005 15:22

ok i have fix mine...it was my silly mistake


#
#-----[ FIND ]------------------------------------------------
#
WHERE session_time < $expiry_time

#
#-----[ IN-LINE FIND ]----------------------------------------
#
session_time < $expiry_time

#
#-----[ IN-LINE REPLACE WITH ]--------------------------------
#
UNIX_TIMESTAMP() - session_time >=172800




i deleted the "WHERE" and replace directly with --> "UNIX_TIMESTAMP() - session_time >=172800" ..


now i have added "WHERE unix_timestamp()- session_time >=172800" it have fixed the problem phpbb critical error.


u may make the same mistake as i do...good luck
th3zone
Poster
Poster
 
Posts: 8
Joined: Fri 04. Feb, 2005 10:03


Return to Last visit [2.0.10/EM]

Who is online

Users browsing this forum: No registered users and 1 guest

cron