PDA

View Full Version : Database Error


izan
June 7th, 2010, 02:17 PM
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 (http://www.google.com/bot.html))', 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 (http://www.amx-perience.com/AMCgallery/showphoto.php?photo=471&si=wheelie)
Referrer :
IP Address : 66.249.65.208
Username : Unregistered
Classname : vb_database

Chuck S
June 7th, 2010, 03:02 PM
I do not see how that would be coming from our program honestly


ppmysql_query("DELETE FROM {$Globals['dprefix']}session WHERE userid='{$User['userid']}'", $db_link);
ppmysql_query("INSERT INTO {$Globals['dprefix']}session (sessionhash, userid, host, idhash, lastactivity, useragent)
VALUES ('$session_id',{$User['userid']},'$ipaddr','$idhash','$sesstime','$browser')", $db_link);



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
June 7th, 2010, 03:48 PM
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
June 7th, 2010, 04:04 PM
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
June 7th, 2010, 04:33 PM
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 (http://search.msn.com/msnbot.htm))', 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 (http://www.amx-perience.com/AMCgallery/misc.php?action=reportpost&photo=6&report=80)
Referrer :
IP Address : 207.46.195.235
Username : Unregistered
Classname : vb_database

Chuck S
June 7th, 2010, 04:57 PM
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.