Results 1 to 5 of 5

Database Error and Google

This is a discussion on Database Error and Google within the Troubleshooting forums, part of the vBSEO SEO Plugin category; I've received almost 900 database errors since 1:24am this morning. The error reads as follows: Database error in vBulletin 3.8.2: ...

  1. #1
    Member
    Real Name
    Richard
    Join Date
    Oct 2005
    Posts
    69
    Liked
    0 times

    Database Error and Google

    I've received almost 900 database errors since 1:24am this morning.

    The error reads as follows:

    Database error in vBulletin 3.8.2:
    Invalid SQL:
    REPLACE INTO guest
    (guestid, hostip, useragent, lastactive, spider, script, rdata)
    VALUES
    ('b3ad78f73e0c2b14f5849e6154ee3e86', '66.249.72.241', 'Mozilla/5.0 (compatible; Googlebot/2.1; +Verifying Googlebot - Webmasters/Site owners Help)', 1247895847, '', 'showthread', 'a:8:{s:8:\"vbseourl\";s:40:\"general-info/2046-eating-deer-feces.html\";s:1:\"t\";s:4:\"2046\";s:8:\"threadid \";i:2046;s:1:\"s\";s:0:\"\";s:6:\"postid\";i:0;s: 7:\"forumid\";s:2:\"15\";s:6:\"pollid\";i:0;s:1:\" a\";s:0:\"\";}');
    MySQL Error : Duplicate entry 'b3ad78f73e0c2b14f5849e6154ee3e86' for key 1
    Error Number : 1062
    Request Date : Saturday, July 18th 2009 @ 01:44:07 AM
    Error Date : Saturday, July 18th 2009 @ 01:44:07 AM
    Script : http://www.mydomain.com/forums/general-info/
    33647-tempermant-issues.html
    Referrer :
    IP Address : 66.249.72.241
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :


    ALL the database errors appear to reference google for whatever reason.

    Would anyone have any suggestions?

  2. #2
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    Hello,

    from the db error message it seems to be related to this mod: Track Guest Visits - vBulletin.org Forum (vBSEO doesn't run this sql query).
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  3. #3
    Member
    Real Name
    Richard
    Join Date
    Oct 2005
    Posts
    69
    Liked
    0 times
    I managed to turn off the track guest plugin but I'm not getting this error message

    Database error in vBulletin 3.8.2:

    Invalid SQL:

    REPLACE INTO guest
    (guestid, hostip, useragent, lastactive, spider, script, rdata)
    VALUES
    ('2c607011fd60258ad3e76cdd4e7bb6ff', '72.30.78.249', 'Mozilla/5.0 (compatible; Yahoo! Slurp/3.0; Yahoo!'s Web Crawler)', 1247951849, '', 'showthread', 'a:8:{s:8:\"vbseourl\";s:27:\"vets-corner/6201-parvo.html\";s:1:\"t\";s:4:\"6201\";s:8:\"threadid \";i:6201;s:1:\"s\";s:0:\"\";s:6:\"postid\";i:0;s: 7:\"forumid\";s:2:\"12\";s:6:\"pollid\";i:0;s:1:\" a\";s:0:\"\";}');

    MySQL Error : Table './rottweil_forums/guest' is marked as crashed and should be repaired
    Error Number : 145
    Request Date : Saturday, July 18th 2009 @ 05:17:29 PM
    Error Date : Saturday, July 18th 2009 @ 05:17:29 PM
    Script : http://www.mydomain.com/forums/vets-...201-parvo.html
    Referrer :
    IP Address : 72.30.78.249
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
    I've tried to repair the table via phpMyAdmin with no luck. I appericate your assistance.

  4. #4
    Senior Member
    Real Name
    Michael Biddle
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    7,097
    Liked
    4 times
    Taking a shot in the woods, have you tried to repair it through the admincp?
    The Forum Hosting - Forum Hosting from the Forum Experts

  5. #5
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    You need to track the running query on your forum and remove it.
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

Similar Threads

  1. Database Error
    By zigzap in forum Troubleshooting
    Replies: 2
    Last Post: 03-13-2009, 05:51 PM
  2. Need Help With This Database Error Please
    By gwerzal in forum General Discussion
    Replies: 1
    Last Post: 03-10-2009, 10:45 PM
  3. Getting a database error
    By gc1 in forum Troubleshooting
    Replies: 2
    Last Post: 12-16-2008, 10:03 AM
  4. 3.2.0 RC5 Database error
    By MissKalunji in forum Troubleshooting
    Replies: 9
    Last Post: 05-03-2008, 10:52 AM
  5. Database error
    By webgroup in forum Troubleshooting
    Replies: 1
    Last Post: 05-08-2007, 06:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •