Results 1 to 5 of 5

Why do we get this SQL error?

This is a discussion on Why do we get this SQL error? within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; After upgrading to vbseo 3.2, we get this error mailed to our admin mail addy with the following message: Database ...

  1. #1
    Junior Member
    Real Name
    Big Island
    Join Date
    Mar 2007
    Posts
    25
    Liked
    0 times

    Why do we get this SQL error?

    After upgrading to vbseo 3.2, we get this error mailed to our admin mail addy with the following message:

    Database error in vBulletin 3.7.2:

    Invalid SQL:
    INSERT INTO vb303_vbseo_serviceupdate
    (s_threadid, s_updated)
    VALUES

    ('9011', 0);

    MySQL Error : Table 'vbulletin.vb303_vbseo_serviceupdate' doesn't exist
    Error Number : 1146

    Request Date : Wednesday, July 23rd 2008 @ 11:51:32 PM
    Error Date : Wednesday, July 23rd 2008 @ 11:51:32 PM

    Any ideas?

  2. #2
    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 import vBSEO 3.2 product file with overwrite option set to yes
    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

  3. #3
    Senior Member
    Real Name
    Keith Cohen
    Join Date
    Jul 2005
    Location
    Raleigh, NC USA
    Posts
    6,147
    Liked
    12 times
    Did you install the updated vBSEO XML Product when you upgraded?

    Does that table exist on your mySQL server? Table prefix issue maybe?

  4. #4
    Junior Member
    Real Name
    Big Island
    Join Date
    Mar 2007
    Posts
    25
    Liked
    0 times
    Quote Originally Posted by Keith Cohen View Post
    Did you install the updated vBSEO XML Product when you upgraded?

    Does that table exist on your mySQL server? Table prefix issue maybe?
    Did install the XML product when upgrading, but the table indeed does not exist. What does it do?

  5. #5
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    Try to uninstall and then reinstall product file.
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


Similar Threads

  1. [Error] xhtml coding error on my part - please help
    By jbartle in forum Template Modifications
    Replies: 3
    Last Post: 01-24-2008, 11:50 PM
  2. Internal Server error - Log error posted here
    By candg in forum Troubleshooting
    Replies: 2
    Last Post: 08-06-2007, 06:46 AM
  3. vBSEO error in error log
    By Mert Gökçeimam in forum Troubleshooting
    Replies: 5
    Last Post: 02-26-2007, 11:41 AM

Posting Permissions

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