11 replies [Last post]
rck
Offline
Enthusiast
Last seen: 12 years 42 weeks ago
Joined: 2004-09-26
Posts: 75
Points: 0

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?

roytheboy
roytheboy's picture
Offline
Guru
North Wales, UK
Last seen: 6 years 20 weeks ago
North Wales, UK
Timezone: GMT+1
Joined: 2004-09-18
Posts: 2233
Points: 41

Session table

Ditto Tony.

Life's a b*tch and then you die!

Hugo
Hugo's picture
Offline
Moderator
London
Last seen: 4 years 48 weeks ago
London
Joined: 2004-06-06
Posts: 15668
Points: 2806

Session table

Double ditto; on every page request; hitting back and re-submit clears it :?:

Before you make your first post it is vital that you READ THE POSTING GUIDELINES!
----------------------------------------------------------------
Please post ALL your code - both CSS & HTML - in [code] tags
Please validate and ensure you have included a full Doctype before posting.
Why validate? Read Me

Tony
Tony's picture
Offline
Moderator
Brisbane
Last seen: 3 days 10 hours ago
Brisbane
Timezone: GMT+10
Joined: 2003-03-12
Posts: 5342
Points: 2963

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.

Tony
Tony's picture
Offline
Moderator
Brisbane
Last seen: 3 days 10 hours ago
Brisbane
Timezone: GMT+10
Joined: 2003-03-12
Posts: 5342
Points: 2963

Session table

The Session table crashed MySQL again Sad
I had to drop the table and recreate it.

Sorry for any inconvenience.

rck
Offline
Enthusiast
Last seen: 12 years 42 weeks ago
Joined: 2004-09-26
Posts: 75
Points: 0

Session table

Tony wrote:
The Session table crashed MySQL again Sad
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

Tony
Tony's picture
Offline
Moderator
Brisbane
Last seen: 3 days 10 hours ago
Brisbane
Timezone: GMT+10
Joined: 2003-03-12
Posts: 5342
Points: 2963

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.

rck
Offline
Enthusiast
Last seen: 12 years 42 weeks ago
Joined: 2004-09-26
Posts: 75
Points: 0

Session table

Tony wrote:
Now I will have to work on ensuring it wont happen again.

Well, the devil never sleeps... :twisted:

Tony
Tony's picture
Offline
Moderator
Brisbane
Last seen: 3 days 10 hours ago
Brisbane
Timezone: GMT+10
Joined: 2003-03-12
Posts: 5342
Points: 2963

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.

dJomp
dJomp's picture
Offline
Enthusiast
Last seen: 3 years 45 weeks ago
Joined: 2003-03-23
Posts: 422
Points: 0

Session table

Had you made any changes to them anyway, or may other phpBB users experience something similar? Shock

You know you're a geek when you try to shoo a fly away from the monitor with your cursor.

Tony
Tony's picture
Offline
Moderator
Brisbane
Last seen: 3 days 10 hours ago
Brisbane
Timezone: GMT+10
Joined: 2003-03-12
Posts: 5342
Points: 2963

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

dJomp
dJomp's picture
Offline
Enthusiast
Last seen: 3 years 45 weeks ago
Joined: 2003-03-23
Posts: 422
Points: 0

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!

You know you're a geek when you try to shoo a fly away from the monitor with your cursor.