Database Error

[izan]

Hi,
This is a follow-up from our previous emails. I'm posting here as this is a new problem. Yesterday I upgraded my gallery from 5.13 to 7.02 to fix the Gallery compatibility issue with VB 3.5.0.
The Forum, Classifieds and Gallery are all showing up ok (no more white pages) but I now have a mailbox full of the following error.

Thank you for your help

---------------------------------------

( All show as
MySQL Error : Duplicate entry '9cbe925f50115b3ae982988ac95897e5' for key 1 (though the key between the quotes differ)
and Error Number : 1062 )


Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass)
VALUES
('9cbe925f50115b3ae982988ac95897e5', 0, '66.249.65.208', 'b7a7a78a0f0ab05079e72c6a96628b62', 1275926004, '/AMCgallery/showphoto.php?photo=471&si=wheelie', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (compatible; Googlebot/2.1; +Verifying Googlebot - Webmaster Tools Help)', 0);

MySQL Error : Duplicate entry '9cbe925f50115b3ae982988ac95897e5' for key 1
Error Number : 1062
Date : Monday, June 7th 2010 @ 11:53:25 AM
Script : 71 Javelin - AMC Photo Gallery
Referrer :
IP Address : 66.249.65.208
Username : Unregistered
Classname : vb_database

[Chuck S]

I do not see how that would be coming from our program honestly

Content visible to verified customers only.

We issue a delete query to delete any sessions and the following queries are only done on a login so the userid should not be 0 yours is somehow maybe a hack conflict.

[izan]

It can't be a hack conflict as I've never done any hacks to either the Forum, Classifieds or Gallery.

I do get this error when logging out: "An error occurred while attempting to log you out. Click here to log out."

[Chuck S]

well you cant get that error from logging out at least it would not be coming from our program as we do not do an insert into the sessions table on a logout.

Your referring to the login or logout in actually vb right because the functions I am referring to are our login logout page.

what is the url of the logout page your using?

[izan]

Yes, the database error doesn't seem to be related to login/logout, it is being generated by page views?

Here's the URLs from the logout error pages. These are from the forum and gallery. Oddly enough I don't get a logout error at all if I logout from the Classifieds. So the forum was updated to VB 3.5, the gallery was updated to 7.01 and they both give an error on logout but the classifieds was not updated and logout through classifieds is fine.

Meanwhile the database errors continue to come in.

Forum logout URL that shows logout error - //http://www.amx-perience.com/AmericanMotorsForum/login.php?do=logout&u=1

URL after clicking on 'Click here to logout' from Forum - //http://www.amx-perience.com/AmericanMotorsForum/login.php?do=logout&logouthash=5ae1661fe6c92126d2bc031780295f9c]

Gallery logout URL that shows logout error - //http://www.amx-perience.com/AmericanMotorsForum/login.php?do=logout&u=1


URL after clicking on 'Click here to logout' from Gallery - //http://www.amx-perience.com/AmericanMotorsForum/login.php?do=logout&logouthash=5ae1661fe6c92126d2bc031780295f9c


the latest DB error:

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass)
VALUES
('ebb8b895573ff579597e65fe6d70ff85', 0, '207.46.195.235', '36caa61d167c231a341a613d9ed02eb0', 1275942406, '/AMCgallery/misc.php?action=reportpost&photo=6&report=80', 0, 0, 0, 0, 0, 0, 0, 'msnbot/2.0b (+Bing Webmaster Center)', 0);

MySQL Error : Duplicate entry 'ebb8b895573ff579597e65fe6d70ff85' for key 1
Error Number : 1062
Date : Monday, June 7th 2010 @ 04:26:46 PM
Script : Message - AMC Photo Gallery
Referrer :
IP Address : 207.46.195.235
Username : Unregistered
Classname : vb_database

[Chuck S]

These are all forum login urls so none of the kinda reference an error thats probally not calling anything from the gallery/

Have you tried updating your gallery to 3.85 which is there latest. Your years behind.