[Lizard King]

Originally Posted by jazan

after upgrading vb to 3.8.0



i got this error , need help

Fatal error: Out of memory (allocated 45613056) (tried to allocate 10223616 bytes) ***/vb/vbseo_sitemap/vbseo_sitemap_functions.php on line 1295

Try disabling yahoo format text based sitemap generator , manually delete all your existing sitemaps and then re generate sitemap files. Or you can also increase your php memory_limit

Originally Posted by bollie

Wen i run sitemap



Database error in vBulletin 3.8.0:



Invalid SQL:



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

FROM groupmessage

WHERE groupid='3';



MySQL Error : Unknown column 'groupid' in 'where clause'

Error Number : 1054

Request Date : Wednesday, January 21st 2009 @ 05:03:59 PM

Error Date : Wednesday, January 21st 2009 @ 05:04:04 PM

Script : http://www.xxxxxxxxxx/vbseo_sitemap/vbseo_sitemap.php

Referrer : http://www.xxxxxxxxx/vbseo_sitemap/index.php

IP Address : xxxxxxxxxxx

Username : Niet geregistreerd

Classname : vB_Database

find this in vbseo_sitemap_functions.php file:

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