VBseo sitemap v2.2 problem.

[rogue1239]

Im currently getting a database error when creating a sitemap using VBseo sitemap v2.2 on VBulletin 3.8.0 the error is:

Database error in vBulletin 3.8.0:

Invalid SQL:

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 : Friday, January 23rd 2009 @ 11:27:15 AM
Error Date : Friday, January 23rd 2009 @ 11:27:21 AM
Script : Log in - RogueX Gaming - vBulletin Admin Control Panel
Referrer : Log in - RogueX Gaming - vBulletin Admin Control Panel

Any help with this would be great as iv heard so much good stuff about VBseo sitemap, I also have there VBseo 3.2.0 plugin installed for search engine optimization so was wondering if that may have something to do with it.

 

[rogue1239]

Messed around with the settings and it works now. =]

 

[alexander_extreme]

you have to
find this in vbseo_sitemap_functions.php file:

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

replace with

             $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]'
             ");

=)