vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Total Support Team Launches DeskPro New vBSEO Discount Level for Network Builders vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

vBulletin Database Error

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 ...

Go Back   vBulletin SEO Forums > vBSEO SEO Plugin > Bug Reporting

Enhancing 80 million pages.

Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read
  #1  
Old 12-14-2006, 04:42 PM
Junior Member
 
Real Name: Aaron Wilson
Join Date: Jun 2006
Posts: 25
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);


-------------------------------------------------------------
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 12-14-2006, 06:19 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,596
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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 12-14-2006, 07:25 PM
Junior Member
 
Real Name: Aaron Wilson
Join Date: Jun 2006
Posts: 25
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 12-14-2006, 07:52 PM
Junior Member
 
Real Name: Aaron Wilson
Join Date: Jun 2006
Posts: 25
I should also state that when i turn vbseo off the errors stop
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #5  
Old 12-14-2006, 08:42 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,596
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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 12-14-2006, 08:50 PM
Junior Member
 
Real Name: Aaron Wilson
Join Date: Jun 2006
Posts: 25
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
------------------------------------------------------------------------------------
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #7  
Old 12-14-2006, 08:53 PM
Junior Member
 
Real Name: Aaron Wilson
Join Date: Jun 2006
Posts: 25
Well, the emails almost look like that.
on the Script line in the email it shows the URL not the topic of the thread
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #8  
Old 12-14-2006, 08:55 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,596
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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #9  
Old 12-18-2006, 12:01 PM
Junior Member
 
Real Name: Aaron Wilson
Join Date: Jun 2006
Posts: 25
Yes it happens consistently. Probably somewhere around 3-8 emails a minute.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #10  
Old 12-18-2006, 01:04 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,596
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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #11  
Old 01-18-2007, 10:22 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,596
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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #12  
Old 01-19-2007, 08:44 AM
Juan Muriente's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Juan Carlos Muriente
Join Date: Jun 2005
Location: Puerto Rico
Posts: 12,721
*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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT -4. The time now is 10:07 PM.


Powered by vBulletin Version 3.8.0 Beta 4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.