Fri, 2004-11-12 17:17
Just got that error:
phpBB : Critical Error Error clearing sessions table DEBUG MODE SQL Error : 1034 Incorrect key file for table: 'phpbb_sessions'. Try to repair it DELETE FROM phpbb_sessions WHERE session_time < 1100276123 AND session_id <> 'bddb4c74af3696b7f487a2de3b956631' Line : 322 File : /home/csscr/public_html/css-forum/includes/sessions.php
Couldn't access css creator forum some minutes ago, maybe those two events are connected to each other?
Fri, 2004-11-12 17:36
#1
Session table
Ditto Tony.
Fri, 2004-11-12 19:21
#2
Session table
Double ditto; on every page request; hitting back and re-submit clears it :?:
Fri, 2004-11-12 21:25
#3
Session table
Thanks guys,
Seems like there was an incorrect index in the session table so I have deleted the contents of the table and we should be back to normal now.
Tue, 2004-11-16 03:31
#4
Session table
The Session table crashed MySQL again 
I had to drop the table and recreate it.
Sorry for any inconvenience.
Tue, 2004-11-16 11:55
#5
Session table
Tony wrote:
The Session table crashed MySQL again
I had to drop the table and recreate it.
Did you try to repair it? MySQL Administrator has an option for repair. You can call it on the commandline as well, the syntax is outlined on http://dev.mysql.com/doc/mysql/en/Repair.html
Tue, 2004-11-16 20:31
#6
Session table
Hi rck,
No I didn't try recovery, I couldn't remember the query as thankfully I haven't had to use it before.
It was easy for me delete and recreate the table without causing any real problems.
Now I will have to work on ensuring it wont happen again.
Tue, 2004-11-16 23:31
#7
Session table
Tony wrote:
Now I will have to work on ensuring it wont happen again.
Well, the devil never sleeps... :twisted:
Tue, 2004-11-16 23:55
#8
Session table
Hi rck,
I've made some changes to the session handling functions of phpbb, now I just have to sit back and see if it crashes again. :roll:
Thanks for your help.
Wed, 2004-11-17 10:36
#9
Session table
Had you made any changes to them anyway, or may other phpBB users experience something similar? 
Wed, 2004-11-17 23:19
#10
Session table
Hi dJomp,
I have made changes to many things but not specifically the session table.
Session problems seem to be fairly wide spread. http://www.phpbb.com/kb/article.php?article_id=42
Thu, 2004-11-18 10:37
#11
Session table
Thanks for the info, interesting. I don't think I ever have more than about 10 people on my forum at once so that shouldn't be an issue for now!