Error during "Run Sitemap Generator"

When I try to run the sitemap generator I get this error:

[homepage] [5,710.6Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay [5,710.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 132, total threads: 0, pages: 1 [5,711.0Kb mem used] [0s (+0s)]
[SECTION START] showthread [5,722.5Kb mem used] [0s (+0s)]
[archive homepage] [5,722.7Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay archived [5,722.7Kb mem used] [0s (+0s)]
[SECTION START] member [5,722.8Kb mem used] [0s (+0s)]
[SECTION START] groups [5,822.1Kb mem used] [1s (+1s)]
Database error
The Click4Trick database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the click4trick.com home page, then try to open another page.
Click the Back button to try another link.
The click4trick.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

What can I do?

Hi,

You'll need to 'View Source' on that page to be able to tell us what the specific error is, then we can tell you how to fix it.

*edit* If I had to guess, I would say you might need to apply the patch in my signature - vBSEO 3.2.0 Users - Patch Required for vBulletin 3.8 Update

I've added the patch. vBseo works just fine, the problem is from the Sitemap Generator.
The Error in the Source Code is:

Code:

<!--
Database error in vBulletin 3.8.0:
 
Invalid SQL:
 
         		SELECT count(*)as cnt,max(dateline) as lastupdate
         		FROM c4tn_groupmessage
         		WHERE groupid='1';
 
MySQL Error   : Unknown column 'groupid' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, January 24th 2009 @ 07:43:35 AM
Error Date    : Saturday, January 24th 2009 @ 07:43:36 AM
Script        : http://click4trick.com/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://click4trick.com/vbseo_sitemap/index.php
IP Address    : 86.123.139.222
Username      : Unregistered
Classname     : vB_Database
MySQL Version : 
-->

I have the EXACTLY the same problem... VBSEO Sitemap Generator no longer sends out emails since I upgraded to VB 3.8.0 a few days ago. I only just realized today so I went to the scheduled tasks and ran it getting the same error as chessh posted above!

- I've installed VB 3.8.0
- I've added the VBSEO patch

What's going on?

Yes. What should we do to solve the problem?

Hello,

Please try to modify vbseo_sitemap_functions.php file:
FIND:

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage
                 WHERE groupid='$rrow[groupid]'
             "); 


REPLACE WITH:

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage AS groupmessage
                 LEFT JOIN " . TABLE_PREFIX . "discussion AS discussion ON (groupmessage.discussionid = discussion.discussionid)
                 WHERE discussion.groupid='$rrow[groupid]'
             "); 


Ok thanks Oleg I've made those changes and then went to Run Sitemap Generator..

It appears to have worked without a problem.

I will wait and see if the next scheduled task works and hope I get those emails again.

BTW: What was the error due to?

It's related to group discussions database changes in vBulletin.

It worked for me too. Thank you Oleg!

okay mine is working now too. I guess there should be an announcement or an update to fix this for the people that are not aware of this thread or aware that there sitemap is failing.

Thanks Oleg, that worked for me.

I have the following error please suggest me a fix
[homepage] [4,941.2Kb mem used] [0s (+0s)]<br/>
[SECTION START] forumdisplay [4,941.3Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 1, total threads: 0, pages: 1 [4,941.3Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 2, total threads: 2, pages: 1 [4,941.4Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 3, total threads: 1, pages: 1 [4,941.5Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 4, total threads: 1, pages: 1 [4,941.6Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 5, total threads: 2, pages: 1 [4,941.6Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 6, total threads: 10, pages: 1 [4,941.7Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 16, total threads: 2, pages: 1 [4,941.9Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 19, total threads: 9, pages: 1 [4,942.0Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 17, total threads: 29, pages: 2 [4,942.2Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 18, total threads: 0, pages: 1 [4,942.6Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 8, total threads: 2, pages: 1 [4,942.9Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 9, total threads: 4, pages: 1 [4,943.1Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 10, total threads: 2, pages: 1 [4,943.2Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 20, total threads: 24, pages: 2 [4,943.4Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 21, total threads: 321, pages: 17 [4,943.7Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 23, total threads: 55, pages: 3 [4,947.0Kb mem used] [0s (+0s)]<br/>
[SECTION START] showthread [4,947.6Kb mem used] [0s (+0s)]<br/>
[archive homepage] [5,536.6Kb mem used] [0s (+0s)]<br/>
[SECTION START] forumdisplay archived [4,949.9Kb mem used] [0s (+0s)]<br/>
[SECTION START] member [4,949.9Kb mem used] [0s (+0s)]<br/>
[SECTION START] polls [5,152.7Kb mem used] [1s (+0s)]<br/>
[SECTION START] blogs [5,153.1Kb mem used] [1s (+0s)]<br/>
[SECTION START] albums [5,153.9Kb mem used] [1s (+0s)]<br/>
[SECTION START] groups [5,153.9Kb mem used] [1s (+0s)]<br/>
[SECTION START] tags [5,153.9Kb mem used] [1s (+0s)]<br/>
[SECTION START] blog tags [5,154.7Kb mem used] [1s (+0s)]<br/>
[addon module] vbseo_sm_calendar.php [5,154.7Kb mem used] [1s (+0s)]<br/>
[addon module] vbseo_sm_downloads.php [5,154.8Kb mem used] [1s (+0s)]<br/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<!--
Database error in vBulletin 3.8.3:

Invalid SQL:
SELECT id,name FROM dl_cats ORDER BY `id`;

MySQL Error : Table 'samguyvb.dl_cats' doesn't exist
Error Number : 1146
Request Date : Saturday, June 27th 2009 @ 06:04:38 PM
Error Date : Saturday, June 27th 2009 @ 06:04:39 PM
Script : http://www.paktvlive.com/forum/vbseo...eo_sitemap.php
Referrer : vBSEO Google / Yahoo Sitemap for vBulletin
IP Address : 75.152.173.188
Username : Unregistered
Classname : vB_Database
MySQL Version :
-->

Hello,

you should remove vbseo_sm_downloads.php from "Add-ons list" in vBSEO Sitemap Generator options.

Thanks for the quick reply i have taken off vbseo_sm_downloads.php and vbseo_sm_downloads2.php by going in to vbulletin options in my forum's admincp then choosing vbseo google yahoo sitemap generator and edit settings i have only these files now in the "Add-Ons List"
vbseo_sm_calendar.php
vbseo_sm_vba.php
vbseo_sm_vba_links.php
but i still get some errors
[homepage] [4,943.0Kb mem used] [0s (+0s)]<br/>
[SECTION START] forumdisplay [4,943.0Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 1, total threads: 0, pages: 1 [4,943.0Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 2, total threads: 2, pages: 1 [4,943.1Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 3, total threads: 1, pages: 1 [4,943.2Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 4, total threads: 1, pages: 1 [4,943.3Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 5, total threads: 2, pages: 1 [4,943.4Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 6, total threads: 10, pages: 1 [4,943.5Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 16, total threads: 2, pages: 1 [4,943.6Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 19, total threads: 9, pages: 1 [4,943.7Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 17, total threads: 29, pages: 2 [4,943.9Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 18, total threads: 0, pages: 1 [4,944.3Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 8, total threads: 2, pages: 1 [4,944.6Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 9, total threads: 4, pages: 1 [4,944.8Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 10, total threads: 2, pages: 1 [4,944.9Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 20, total threads: 24, pages: 2 [4,945.1Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 21, total threads: 321, pages: 17 [4,945.4Kb mem used] [0s (+0s)]<br/>
[forumdisplay] forum_id: 23, total threads: 55, pages: 3 [4,948.7Kb mem used] [0s (+0s)]<br/>
[SECTION START] showthread [4,949.3Kb mem used] [0s (+0s)]<br/>
[archive homepage] [5,538.5Kb mem used] [0s (+0s)]<br/>
[SECTION START] forumdisplay archived [4,951.6Kb mem used] [0s (+0s)]<br/>
[SECTION START] member [4,951.6Kb mem used] [0s (+0s)]<br/>
[SECTION START] polls [5,153.8Kb mem used] [1s (+0s)]<br/>
[SECTION START] blogs [5,154.2Kb mem used] [1s (+0s)]<br/>
[SECTION START] albums [5,155.1Kb mem used] [1s (+0s)]<br/>
[SECTION START] groups [5,155.1Kb mem used] [1s (+0s)]<br/>
[SECTION START] tags [5,155.1Kb mem used] [1s (+0s)]<br/>
[SECTION START] blog tags [5,155.9Kb mem used] [1s (+0s)]<br/>
[addon module] vbseo_sm_calendar.php [5,155.9Kb mem used] [1s (+0s)]<br/>
[addon module] vbseo_sm_vba.php [5,156.0Kb mem used] [1s (+0s)]<br/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!--
Database error in vBulletin 3.8.3:

Invalid SQL:
SELECT * FROM adv_setting;

MySQL Error : Table 'samguyvb.adv_setting' doesn't exist
Error Number : 1146
Request Date : Saturday, June 27th 2009 @ 07:31:50 PM
Error Date : Saturday, June 27th 2009 @ 07:31:50 PM
Script : http://www.mysitename.com/forum/vbse...eo_sitemap.php
Referrer : http://www.mysitename.com/forum/vbseo_sitemap/
IP Address : 75.152.173.188
Username : Unregistered
Classname : vB_Database
MySQL Version :
-->

Do you have vBadvaned CMPS or vBa Links add-on installed? If not, you should remove all entries from add-ons list option (they are only required if you have those 3rd party mods installed).