Results 1 to 3 of 3

Invalid SQL Error

This is a discussion on Invalid SQL Error within the Bug Reporting forums, part of the vBSEO SEO Plugin category; Just installed Vbseo exactly as readme instructed, everything is working, however I received 4 emails stating that I had a ...

  1. #1
    Junior Member
    Real Name
    osss
    Join Date
    May 2008
    Posts
    4
    Liked
    0 times

    Exclamation Invalid SQL Error

    Just installed Vbseo exactly as readme instructed, everything is working, however I received 4 emails stating that I had a SQL error.

    Database error in vBulletin 3.7.0:

    Invalid SQL:

    SELECT t_threadid,count(*) as cnt
    FROM linkback
    GROUP BY t_threadid;

    MySQL Error : Table 'forumsarchive.linkback' doesn't exist
    Error Number : 1146
    Request Date : Wednesday, May 28th 2008 @ 01:29:03 PM
    Error Date : Wednesday, May 28th 2008 @ 01:29:04 PM
    Script : http://osss.com/forums/vbseo_sitemap/vbseo_sitemap.php
    Referrer : vBSEO Google / Yahoo Sitemap for vBulletin

    Also I dont know if this is related, but when I attempt to run the Run Sitemap Generator, it gives me the following error after I click Are you sure, Yes:


    [homepage] [1s (+1s)]
    [SECTION START] forumdisplay [1s (+0s)]
    [forumdisplay] forum_id: 1, total threads: 0, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 3, total threads: 6, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 22, total threads: 10, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 26, total threads: 23, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 46, total threads: 32, pages: 2 [1s (+0s)]
    [forumdisplay] forum_id: 28, total threads: 26, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 47, total threads: 3, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 6, total threads: 168, pages: 6 [1s (+0s)]
    [forumdisplay] forum_id: 40, total threads: 42, pages: 2 [1s (+0s)]
    [forumdisplay] forum_id: 31, total threads: 0, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 32, total threads: 0, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 33, total threads: 0, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 34, total threads: 0, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 4, total threads: 0, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 13, total threads: 436, pages: 15 [1s (+0s)]
    [forumdisplay] forum_id: 23, total threads: 17, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 14, total threads: 16, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 50, total threads: 10, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 43, total threads: 60, pages: 2 [1s (+0s)]
    [forumdisplay] forum_id: 44, total threads: 29, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 45, total threads: 27, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 29, total threads: 7, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 36, total threads: 9, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 8, total threads: 18, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 9, total threads: 16, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 42, total threads: 0, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 41, total threads: 4, pages: 1 [1s (+0s)]
    [forumdisplay] forum_id: 18, total threads: 67, pages: 3 [1s (+0s)]
    [SECTION START] showthread [1s (+0s)]
    Database error The OneStopSubmitShop.com database has encountered a problem.

  2. #2
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    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
    Junior Member
    Real Name
    osss
    Join Date
    May 2008
    Posts
    4
    Liked
    0 times
    thanks, it worked!
    Last edited by osss; 05-29-2008 at 04:58 PM.

Similar Threads

  1. Invalid SQL
    By jmurrayhead in forum Bug Reporting
    Replies: 2
    Last Post: 05-22-2008, 01:47 PM
  2. Invalid SQL:usergroup SET MySQL Error
    By setubal in forum Troubleshooting
    Replies: 2
    Last Post: 12-12-2007, 08:37 AM
  3. Invalid SQL error on initiating sitemap
    By NICEGUY77 in forum Troubleshooting
    Replies: 2
    Last Post: 01-12-2007, 09:44 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
  •