phpBB Critical Error

[Tree 0]

I just got this error when trying to access this forum. I restarted FireFox and I could access the forums. A more detailed email was sent to Sonic's email.

 

phpBB : Critical Error

 

Error creating new session

 

DEBUG MODE

 

SQL Error : 1062 Duplicate entry '777' for key 2

 

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('e996f91c4890f8c2ae3c0c255e8f62c1', 777, 1129580105, 1129580105, '1863f957', 2, 1, 0)

 

Line : 172

File : sessions.php

[Banshee 28]

The problem is now sorted .

[Tree 0]

Just saw the post on Revora.

[mastermind 0]

I also posted some related info, which should hopefully help if people have problems with missing *.myi files.

[Saracen 16]

I checked the tables and everything seemed ok, so I decided to repair (before actually seeing this I might add) and thus here we are, seems to have worked

[Sonic 295]

Ok just to recap, so I don't feel so confused :wink:

 

The CNCNZ database for the forums has been optimized and corrected for this error?

[Banshee 28]

Only repaired, because they were already optimized.

[mastermind 0]

I believe C&C King repaired, and I went ahead and optimized the tables that needed it.