Database error

Client Joined: Dec 04, 2004 Posts: 757

Hi all, I have got this database error when trying to read topics in the forums Confused

phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO nuke_bbsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('e4a1f441949ac3a7628b87c4e6a72568', 2, 1207675747, 1207675747, '59f19deb', 0, 1, 0)

Line : 184
File : sessions.php

any idea`s
I have tried a sessions table repair but with no joy Question

thanks
mrix

Posted: Tue Apr 08, 2008 11:39 am

I thought it was nuke_session but the problem was in bbsession which I repaired and all is fine now Very Happy

cheers all
mrix

registered · Posted: Wed Apr 09, 2008 5:26 am

Ok. Thanks for letting us know.

Posted: Thu Apr 10, 2008 8:17 pm

mrix,

I have the same problem tonight. What did you do to fix it?

Dawg

Posted: Thu Apr 10, 2008 8:29 pm

Here is my error....

Code:

   phpBB : Critical Error 





Error doing DB query userdata row fetch : session_pagestar





DEBUG MODE





SQL Error : 1016 Can't open file: 'nuke_bbsessions.MYI' (errno: 145)

No recent changes...was working fine 10 mins before. I have been having a problem with Too many connections on MYSQL server.

If anyone knows anything about this please let me know.

Dawg

registered · Posted: Thu Apr 10, 2008 8:40 pm

Go into phpMyAdmin, find the table, and do a "repair" on it.

Posted: Thu Apr 10, 2008 8:46 pm

IT reported OK....Still same error.

Thank You for helping!

Dawg

Posted: Thu Apr 10, 2008 9:09 pm

LOL...I was looking at the wrong table. It is BB_sessions...DUMBY!

THANK YOU THANK YOU AND THANK YOU!

Dawg