Sitemap generation broken on VB3.8.0?

As per title, scheduled task did not run at 2am - Tried running manually and got this error

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT count(*)as cnt,max(dateline) as lastupdate
FROM vb1_groupmessage
WHERE groupid='1';

MySQL Error : Unknown column 'groupid' in 'where clause'
Error Number : 1054
Request Date : Friday, January 9th 2009 @ 03:25:03 AM
Error Date : Friday, January 9th 2009 @ 03:25:07 AM
Script : Sedo - Buy and Sell Domain Names and Websites
Referrer : Sedo - Buy and Sell Domain Names and Websites
IP Address : xx.xx.xx.xx
Username : username
Classname : vB_Database
MySQL Version : 5.xxx.xxx-community-nt

Any ideas?

Never mind, this post fixed it.

Links not working after site transfer

Maybe worth making a note if anyone else has the same issues.

The link he provided fixes it, so no need to disable it.