Das UndergrounD,

if you don't have vBSEO installed, turn off "vBSEO URLs" option.

havard20009,

you should check the *html source*, not the on page content for exact message.

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

Do you have vBulletin Blog installed? If yes, are you running the latest version?

please update for 3.8.1

I tested mod_rewrite and it works. The generator generates the sitemap in the .../data folder. The problem is that I get a 404 error when trying to access it. Google is saying the same thing. I have the .htaccess file in the forum root. I gave this link to Google:

http://www.mywebsite.com/forum/sitemap_index.xml.gz

Any suggestions?

Uninstall this version to switch to version 3.8 :D
Good job

Seems to be working fine. Thanks! :up:

I have been using the Sitemap Generator for months, I just upgrade to 2.5 and I have a couple of questions

Questions:

Show Sitemap Downloads Log -- Should I erase or keep them? Is there any option no to save the log?

Show SE Bots Activity Log-- How do I erase the log? if it is possible to erase, should I erase or keep them? Is there any option no to save the log?

Show Reports List -- Should I erase or keep the list? Is there any option no to save the list?

Last question: I upgraded to 2.5 but still shows 2.2 at the bottom, am I doing something wrong?

I'd recommend to setup "Prune log" setting in vbseo_sitemap_config.php file to automatically erase old logs:
Make sure that you uploaded all new files to vbseo_sitemap/ folder and imported xml product file in vB admincp.

I just upgraded from the previous version and now when I run the script it stalls here

forumdisplay] forum_id: 15, total threads: 382, pages: 13 [6,631.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 20, total threads: 172, pages: 6 [6,637.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 43, total threads: 225, pages: 8 [6,641.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 45, total threads: 70, pages: 3 [6,644.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 46, total threads: 134, pages: 5 [6,646.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 44, total threads: 25, pages: 1 [6,648.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 47, total threads: 71, pages: 3 [6,649.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 18, total threads: 108, pages: 4 [6,650.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 11, total threads: 299, pages: 10 [6,651.9Kb mem used] [0s (+0s)]
[SECTION START] showthread [6,655.2Kb mem used] [0s (+0s)]

How can I kick start it to finish the job?