mysql error: Duplicate entry

[JamesX4334]

When trying to log out or log in i get this message
Database error in vBulletin 3.0.7:

PHP Code:

Invalid SQL:
               INSERT INTO session
                       (sessionhash, userid, host, idhash, lastactivity, styleid, useragent)
               VALUES
                       ('e3b621592a4b6a651798d8233c955350', 0, '81.152.165.200', '73f217f5e10d566906167b7557618da7', 1121425831, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)')

mysql error: Duplicate entry 'e3b621592a4b6a651798d8233c955350' for key 1

mysql error number: 1062

Date: Friday 15th of July 2005 06:10:31 AM
Script: http://aaaaaa.com/login.php?do=logout&u=5
Referer: http://aaaaaa.com/index.php?
Username: Unregistered
IP Address: 81.152.165.200 


Ive tried to fix but i could not

Can someone help

[sabret00the]

what hacks did you install before this happened?

[JamesX4334]

arcade,cash,medals and some other stuff but they did not effect SQL

[sabret00the]

as far as i know all of them do actually modify the database, i have a feeling that something modified your session tables or where the sessions are handled in the files badly.

[JamesX4334]

yes i was wondering that,
Ill take out some of the tables like the arcade and re-install and see what happens.
I cannot re-install da forums thougth ive made/installed way to many mods for it so this need to be fixed

--------------
I think its the arcade causing the trouble but how do i recover the session table ?

[Marco van Herwaarden]

You could easily delete all rows from the session table.

Funny the sessionhash should not get duplicates, but Floris had the same problem posted at vb.com using vB3.5.

Not sure if he ever found out what was causing it. Try searching vb.com for a thread started by floris.