Results 1 to 3 of 3

Invalid SQL error on initiating sitemap

This is a discussion on Invalid SQL error on initiating sitemap within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; When i goto generate the sitemap with 1.7 i get this error. However, with the old setup no issues. Running ...

  1. #1
    Senior Member Array
    Real Name
    Rick
    Join Date
    Feb 2006
    Location
    Canada
    Posts
    169
    Liked
    0 times

    Exclamation Invalid SQL error on initiating sitemap

    When i goto generate the sitemap with 1.7 i get this error. However, with the old setup no issues.
    Running vb 3.5.4
    with
    vBSEO 3.0.0 RC3

    Please advise.

    Database error in vBulletin 3.5.4:

    Invalid SQL:

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

    MySQL Error : Table 'xxxxx_xxxxxvb.linkback' doesn't exist Error Number : 1146
    Date : Thursday, January 11th 2007 @ 08:19:35 PM
    Script : http://www.xxxx.com/online/vbseo_sit...eo_sitemap.php
    Referrer : http://www.xxxx.com/online/vbseo_sitemap/index.php
    IP Address : 74.97.00.00
    Username : Unregistered
    Classname : vb_database

  2. #2
    Senior Member Array
    Real Name
    Keith Cohen
    Join Date
    Jul 2005
    Location
    Raleigh, NC USA
    Posts
    6,147
    Liked
    16 times
    Please upgrade to vBSEO 3.0.0 RC6.

  3. #3
    Senior Member Array
    Real Name
    Rick
    Join Date
    Feb 2006
    Location
    Canada
    Posts
    169
    Liked
    0 times
    Quote Originally Posted by Keith Cohen View Post
    Please upgrade to vBSEO 3.0.0 RC6.
    Thank you, this did resolve the site mapping issue however another VBSEO bug has popped up.

    You may read about it here and comment if you have a suggestion as well
    vbSEO BUG

Similar Threads

  1. Memory Problem:
    By TraumTeam in forum Troubleshooting
    Replies: 1
    Last Post: 04-06-2006, 08:24 AM
  2. Replies: 0
    Last Post: 12-17-2005, 01:11 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
  •