Results 1 to 6 of 6

Database Error While Generating Sitemap - 3.8 Upgrade

This is a discussion on Database Error While Generating Sitemap - 3.8 Upgrade within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; I've just upgraded to 3.8 Gold and I re-generated my stemap and it started to enerate and then I got ...

  1. #1
    Senior Member
    Real Name
    LinkHunter
    Join Date
    Dec 2007
    Posts
    131
    Liked
    0 times

    Database Error While Generating Sitemap - 3.8 Upgrade

    I've just upgraded to 3.8 Gold and I re-generated my stemap and it started to enerate and then I got this error aft it stopped:

    SELECT count(*)as cnt,max(dateline) as lastupdate
    FROM groupmessage
    WHERE groupid='1';
    MySQL Error : Unknown column 'groupid' in 'where clause'
    Error Number : 1054
    Request Date : Sunday, January 18th 2009 @ 10:25:39 PM
    Error Date : Sunday, January 18th 2009 @ 10:25:56 PM
    Script : http://www.mywebsit.com/vbseo_sitemap/vbseo_sitemap.php
    Referrer : http://www.mywebsite.com/vbseo_sitemap/index.php
    IP Address :
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

    Will I have to change something in the main vbSEO settings as well, or do anything to adhere it to 3.8?

  2. #2
    vBSEO Staff Ace Shattock's Avatar
    Real Name
    Ace Shattock
    Join Date
    Jul 2005
    Location
    Auckland, New Zealand, New Zealand
    Posts
    3,999
    Liked
    11 times
    Hello,

    Please try the fix detailed in this thread: Links not working after site transfer

  3. #3
    Senior Member
    Real Name
    LinkHunter
    Join Date
    Dec 2007
    Posts
    131
    Liked
    0 times
    [quote=Ace Shattock;189518]Hello,

    Please try the fix detailed in this thread: http://www.vbseo.com/f77/links-not-w...693[/quote]

    Okay, thanks for that!

    After I do that do I just run the sitemap gerator again? Should I delete all of the data first?

    Thanks a lot for the help!

  4. #4
    vBSEO Staff Ace Shattock's Avatar
    Real Name
    Ace Shattock
    Join Date
    Jul 2005
    Location
    Auckland, New Zealand, New Zealand
    Posts
    3,999
    Liked
    11 times
    Once you have applied the fix, generate it again.

    It should replace the files, as it would normally.

  5. #5
    Senior Member
    Real Name
    LinkHunter
    Join Date
    Dec 2007
    Posts
    131
    Liked
    0 times
    Quote Originally Posted by Ace Shattock View Post
    Once you have applied the fix, generate it again.

    It should replace the files, as it would normally.
    Thanks for the help!

    It ran perfect after I applied the code fix.

  6. #6
    vBSEO Staff Ace Shattock's Avatar
    Real Name
    Ace Shattock
    Join Date
    Jul 2005
    Location
    Auckland, New Zealand, New Zealand
    Posts
    3,999
    Liked
    11 times
    That's great news, glad to hear it!

Similar Threads

  1. Error when generating sitemap
    By Farouk in forum Troubleshooting
    Replies: 1
    Last Post: 09-19-2008, 05:20 PM
  2. Database error when running sitemap generator
    By Kaos in forum Troubleshooting
    Replies: 6
    Last Post: 08-22-2008, 06:13 PM
  3. Database Error when creating a Sitemap
    By LAJAURIA in forum Troubleshooting
    Replies: 2
    Last Post: 06-15-2008, 04:27 PM
  4. Replies: 4
    Last Post: 05-18-2008, 01:27 PM
  5. vB Database Error After Upgrade
    By Warden-B- in forum Troubleshooting
    Replies: 2
    Last Post: 05-08-2008, 07:07 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
  •