IntegraMOD

phpBB : Critical Error

Error updating sessions table

DEBUG MODE

SQL Error : 1034 Incorrect key file for table 'phpbb_users'; try to repair it

UPDATE phpbb_users SET user_session_time = 1153982884, user_session_page = 0 WHERE user_id = 2

Line : 382
File : sessions.php

/////////////////////
i think the reason for all of this is because i was online when the server went down, after he got online, i get this massege everytime i log in or allmost every page i go., after a refrash it ok for the current page only
i tried to log with another user, its all ok
but my webmaster user is all a mess
please, what to do
thanks

Access your database using phpmyadmin. Select the sessions table, scroll down to the bottom and you'll see a drop-down menu. Select repair from the drop-down menu and it should fix the problem.

Thanks man, i think its ok now
but one little issue.
now no one can see the admin's avatar, except him....
do you have an idea why is that?
i tried to change my remote avatar but still,
no one can see his avatar in the forum posts

thanks again

Man, this is so scary!!!
it happened again, we where 3 users online
this time it all look ok, server was up and normal
all 3 users got this error message
i made the repair once more, it did fix this problem


what is going on!!
i cant afford this damage right now
please help!

I'm not entirely sure what the problem is... did you update your forum to the latest? It's possible that the sessions_keys table isn't there, if it isn't you can try the following in phpmyadmin...

Code: Select all

CREATE TABLE `phpbb_sessions_keys` (   `key_id` varchar(32) NOT NULL default '0',   `user_id` mediumint(8) NOT NULL default '0',   `last_ip` varchar(8) NOT NULL default '0',   `last_login` int(11) NOT NULL default '0',   PRIMARY KEY  (`key_id`,`user_id`),   KEY `last_login` (`last_login`)) TYPE=MyISAM;

I do have this table.
do you think it might be related to the host server?
its a free server, maybe its because the server is unstable or somthing like that?

in any case i am gonna get myself a real host at godaddy.com
i hope that this will solve my problem

thanks anyway, i love you guys

btw - i did all the updates