vBulletin Search Engine Optimization
This is a discussion on vBulletin Database Error within the Bug Reporting forums, part of the vBSEO SEO Plugin category; Getting all kinds of db errors. Everything seems to be working though. I imagine most of them are from spiders ...
| |||||||
Enhancing 80 million pages. | Register | FAQ | Members List | Social Groups | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
| |||
| |||
| 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); ------------------------------------------------------------- |
|
#2
| ||||
| ||||
|
Hello Aaron , can you reproduce the error when visit the page referred in db error notification email?
__________________ Oleg Ignatiuk / Crawlability Inc. Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#3
| |||
| |||
|
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 |
|
#4
| |||
| |||
|
I should also state that when i turn vbseo off the errors stop
|
|
#5
| ||||
| ||||
|
Can you reproduce the issue somehow? (the URL where this error happens should be included in email)
__________________ Oleg Ignatiuk / Crawlability Inc. Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#6
| |||
| |||
|
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 ------------------------------------------------------------------------------------ |
|
#7
| |||
| |||
|
Well, the emails almost look like that. on the Script line in the email it shows the URL not the topic of the thread |
|
#8
| ||||
| ||||
|
Does it happen consistently? (i.e., a few emails total or same emails every hour?)
__________________ Oleg Ignatiuk / Crawlability Inc. Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#9
| |||
| |||
|
Yes it happens consistently. Probably somewhere around 3-8 emails a minute.
|
|
#10
| ||||
| ||||
|
Could you please open a support ticket with ftp/admincp access for troubleshooting?
__________________ Oleg Ignatiuk / Crawlability Inc. Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#11
| ||||
| ||||
|
Thank you for reporting!/* NOTE: This issue has been resolved. The fix will be distributed with the next vBSEO build. */
__________________ Oleg Ignatiuk / Crawlability Inc. Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#12
| ||||
| ||||
|
*Moved to Bug Reporting Forums*
__________________ Juan Muriente / Crawlability Inc. Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| database error | UnderEstimated | Troubleshooting | 9 | 12-01-2006 06:46 AM |
| vBulletin Database Error! | glenster | Troubleshooting | 3 | 11-08-2006 11:56 PM |