Database error while generating sitemap

Hello,

I'm following instructions mentioned here: [How To] Replace Showpost Links with Permalinks - Max Out Search Engine Crawling Efficiency

During the last step, I deleted the .gz files an and ran the sitemap generator. The sitemap generator ran for a while and then I was presented with a 'database error'.

I see couple of files generated in the /data folder -

sitemap_1.xml.gz
.
.
.
sitemap_4.xml.gz
sitemap_index.xml.gz
urllist.txt.gz


I clicked 'back' button in my browser and then ran the generator again. I then got three more files sitemap_4.xml.gz - sitemap_7.xml.gz.

Questions: -
Shall I try running the sitemap generator once again?
What's going wrong?
Is it necessary to delete the .gz files before running the sitemap generator?

Please post us details of the database error so we can asist you. You can view page source to copy database error details.

The generator ran fine. Looks like things are working well.

I've one more question. I noticed the error because I was manually running the generator. If the database goes away while the generator autoruns everyday, will I get notified about it through email?

In order to receive database errors you need to define your e-mail adress within vBulletin config.php

Hi,

I can't generate myself the sitemap Database error :

-----

Database error in vBulletin 3.8.4:

Invalid SQL:

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

MySQL Error : Champ 'groupid' inconnu dans where clause
Error Number : 1054
Request Date : Saturday, October 17th 2009 @ 10:49:36 PM
Error Date : Saturday, October 17th 2009 @ 10:49:38 PM
Script : http://www.mysite.com/forum/vbseo_si...eo_sitemap.php
Referrer : vBSEO Google / Yahoo Sitemap for vBulletin
IP Address : 84.99.xxx.xxx
Username : Non inscrit
Classname : vB_Database
MySQL Version :


*********
[SECTION START] member [11,185.5Kb mem used] [161,403s (+161,403s)]
[SECTION START] polls [6,945.1Kb mem used] [161,405s (+3s)]
[SECTION START] blogs [6,999.6Kb mem used] [161,405s (+0s)]
[SECTION START] albums [7,001.8Kb mem used] [161,405s (+0s)]
[SECTION START] groups [7,005.3Kb mem used] [161,405s (+0s)]
**********

Any solution please ?
Thanks

Please try to upgrade the latest version of the sitemap (2.5).

Thanks for reply. I will update as soon as possible.

I've installed A module MGC Chatbox Evo
MGC Chatbox Evo - Page 381 - vBulletin.org Forum

I try to install it but now I got errors :

Warning: include([path]/includes/mgc_cb_evo/plugins.php) [function.include]: failed to open stream: No such file or directory in [path]/includes/init.php(304) : eval()'d code on line 1

Warning: include() [function.include]: Failed opening '[path]/includes/mgc_cb_evo/plugins.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in [path]/includes/init.php(304) : eval()'d code on line 1

Warning: include([path]/includes/mgc_cb_evo/plugins.php) [function.include]: failed to open stream: No such file or directory in [path]/includes/functions.php(1377) : eval()'d code on line 1

Warning: include() [function.include]: Failed opening '[path]/includes/mgc_cb_evo/plugins.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in [path]/includes/functions.php(1377) : eval()'d code on line 1

Can't delete IT at all !!
Damm Module !!

Any idea, How can I pleeassee delete it ? Wich file should I do something.. I have not access to my admin area anymore.
I know, its not VBseo problem but... If you avec an idea... I'm for advices.

Thanks a lot.

Disable all the hooks through the config.php file here: Disable the plugin/hook system globally - vBulletin Community Forum

That should allow you to login to your AdminCP to remove that modification.

I do another solution but, With your help, I keep my ZEN Attitude.

Thank you Michael. Your team are very good. Really, I did not say that for your help tonight but in general, Vbseo team are realy professional.

See you,

Glad you got it sorted.

Also glad that you enjoy our team here!