vBulletin Database Error

Getting all kinds of db errors. Everything seems to be working though. I imagine most of them are from spiders

Here are examples of the two errors I seem to be getting.

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


Database error in vBulletin 3.6.4:

Invalid SQL:

UPDATE session
SET lastactivity = 1166128419, location = '', inforum = 8, inthread = 15423, incalendar = 0, badlocation = 0
WHERE sessionhash = '';


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

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('', 0, '', '', 1166128418, '', 0, 0, 0, 10, 4278, 0, 0, '', 0, 0);


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

Hello Aaron ,

can you reproduce the error when visit the page referred in db error notification email?

No error appears on the forum itself. The user is unaware of the problem as far as I can tell. If there were error pages coming up they would let me know.

vBulletin just sends me the email with the error and the url it occured on.

Probably something to do with the rewrites. I'm using the standard .htaccess file that came with vBSEO

I should also state that when i turn vbseo off the errors stop

Can you reproduce the issue somehow? (the URL where this error happens should be included in email)

Here are some examples with the URLs. If you click on the URL the page comes up with the rewritten URL. Like I said no error will be shown to the user, but it will shoot off another email to me.

------------------------------------------------------------------------------------
Database error in vBulletin 3.6.4:

Invalid SQL:

UPDATE session
SET lastactivity = 1166138658, location = '', inthread = 20359, incalendar = 0, badlocation = 0
WHERE sessionhash = '';

MySQL Error :
Error Number :
Date : Thursday, December 14th 2006 @ 03:24:18 PM
Script : YAY Kinman! - Ernie Ball Forums
Referrer :
IP Address : 74.6.73.151
Username : Unregistered
Classname : vB_Database
------------------------------------------------------------------------------------
Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('', 0, '', '', 1166138641, '', 0, 0, 0, 10, 2961, 0, 0, '', 0, 0);

MySQL Error :
Error Number :
Date : Thursday, December 14th 2006 @ 03:24:01 PM
Script : 5 free cd's to the first... - Ernie Ball Forums
Referrer :
IP Address : 72.30.216.20
Username : Unregistered
Classname : vB_Database
------------------------------------------------------------------------------------

Well, the emails almost look like that.
on the Script line in the email it shows the URL not the topic of the thread

Does it happen consistently? (i.e., a few emails total or same emails every hour?)

Yes it happens consistently. Probably somewhere around 3-8 emails a minute.

Could you please open a support ticket with ftp/admincp access for troubleshooting?

Thank you for reporting!/* NOTE: This issue has been resolved. The fix will be distributed with the next vBSEO build. */

*Moved to Bug Reporting Forums*