[havard20009]

<!--
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT *
FROM blog
WHERE state = 'visible';

MySQL Error : Unknown column 'state' in 'where clause'
Error Number : 1054
Request Date : Thursday, February 19th 2009 @ 03:51:55 AM
Error Date : Thursday, February 19th 2009 @ 03:51:57 AM
Script : http://...com/forums/vbseo_sitemap/vbseo_sitemap.php
Referrer : http://.com.com/forums/vbseo_sitemap/
IP Address : 120.28.133.235
Username : not register
Classname : vB_Database
MySQL Version :
-->


also i used this code 4 resolve but i have problem with this

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