sitemap not working since upgrade to vb 3.8

I now get this database error:
page:

Code:

[SECTION START] showthread [11,661.8Kb mem used] [828,242s (+828,242s)]
[create sitemap file] filename: sitemap_24.xml.gz, number of urls: 30000 [11,685.6Kb mem used] [828,245s (+3s)]
[create sitemap file] filename: sitemap_25.xml.gz, number of urls: 30000 [11,687.1Kb mem used] [828,279s (+34s)]
[create sitemap file] filename: sitemap_26.xml.gz, number of urls: 30000 [11,693.7Kb mem used] [828,314s (+35s)]
[create sitemap file] filename: sitemap_27.xml.gz, number of urls: 30000 [11,694.0Kb mem used] [828,349s (+35s)]
[create sitemap file] filename: sitemap_28.xml.gz, number of urls: 30000 [11,694.7Kb mem used] [828,385s (+36s)]
[SECTION START] member [12,074.6Kb mem used] [828,417s (+32s)]
[create sitemap file] filename: sitemap_29.xml.gz, number of urls: 30000 [11,676.1Kb mem used] [828,422s (+5s)]
[create sitemap file] filename: sitemap_30.xml.gz, number of urls: 30000 [11,676.7Kb mem used] [828,455s (+33s)]
[create sitemap file] filename: sitemap_31.xml.gz, number of urls: 30000 [11,677.3Kb mem used] [828,489s (+34s)]
[create sitemap file] filename: sitemap_32.xml.gz, number of urls: 30000 [11,677.9Kb mem used] [828,522s (+33s)]
[create sitemap file] filename: sitemap_33.xml.gz, number of urls: 30000 [11,678.5Kb mem used] [828,556s (+33s)]
[create sitemap file] filename: sitemap_34.xml.gz, number of urls: 30000 [11,679.3Kb mem used] [828,589s (+33s)]
[create sitemap file] filename: sitemap_35.xml.gz, number of urls: 30000 [11,679.9Kb mem used] [828,622s (+33s)]
[create sitemap file] filename: sitemap_36.xml.gz, number of urls: 30000 [11,680.5Kb mem used] [828,656s (+33s)]
[SECTION START] polls [11,805.6Kb mem used] [828,686s (+31s)]
[SECTION START] blogs [12,114.3Kb mem used] [828,688s (+1s)]
[SECTION START] albums [12,344.2Kb mem used] [828,688s (+0s)]
[SECTION START] groups [11,811.8Kb mem used] [828,688s (+0s)]
   	 	 	 	 	 	    	 	Database error   	The Gamerz Needs - For All Your Gaming Needs! database has encountered a problem.

source:

Code:

Database error in vBulletin 3.8.0:

Invalid SQL:


         		SELECT count(*)as cnt,max(dateline) as lastupdate

         		FROM vb3_groupmessage

         		WHERE groupid='2';

MySQL Error   : Unknown column 'groupid' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, January 24th 2009 @ 04:04:15 PM
Error Date    : Saturday, January 24th 2009 @ 04:11:42 PM
Script        : http://www.gamerzneeds.net/forums/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://www.gamerzneeds.net/forums/vbseo_sitemap/index.php
IP Address    : **
Username      : Unregistered
Classname     : vB_Database

MySQL Version :

Please check this: Error during "Run Sitemap Generator"

The following patch should fix that:

Code:

--- vbseo_sitemap_functions.php.orig    2009-02-06 14:57:36.000000000 +0000
+++ vbseo_sitemap_functions.php 2009-02-06 14:59:58.000000000 +0000
@@ -569,6 +569,7 @@
                $tcount = $db->query_first("
                        SELECT count(*)as cnt,max(dateline) as lastupdate
-                       FROM " . TABLE_PREFIX . "groupmessage
-                       WHERE groupid='$rrow[groupid]'
+                       FROM " . TABLE_PREFIX . "discussion d, " . TABLE_PREFIX . "groupmessage g
+                       WHERE d.groupid='$rrow[groupid]'
+                               AND g.discussionid = d.discussionid
                ");
                $pcount = ceil($tcount['cnt']/$vboptions['vm_perpage']);
@@ -1365,3 +1366,3 @@
         return $hm[2];
        }