Sitemap fails to run

Hello,

We moved our sites to a dedicated server recently, and now our Sitemaps do not generate. I've tried re-installing the plugin without success. A database error is generated.

See below:

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT catid,title FROM adv_gallery_categories ORDER BY `displayorder`;

MySQL Error : Table 'anime10_forums.adv_gallery_categories' doesn't exist
Error Number : 1146
Date : Monday, November 27th 2006 @ 02:00:20 AM
Script : mydomain/cron.php?&rand=724600
Referrer : mydomain/gallery/
IP Address : 69.241.199.178
Username : Unregistered
Classname : vb_database

Any suggestions would be appreciated. This error ONLY occurs when the sitemap tries to generate.

That error appears to be related to PhotoPost vBGallery.

Hmmm.... i thought that too. Thanks Keith.

Ok, the above problem only occurs when the sitemap generator runs. I asked over at photopost, but their response was that the table is an old table and no longer used, hence why I don't have it in my database.

How do I stop the sitemap generator looking at this non-existent table?

Are you using an add-on module for sitemap to include your vBGallery URLs? If so, you need to update it to work the vBGallery's new table structure.

Am using vbseo_sm_vbagallery.php as an Addon Generator Module. So this would be the problem then?

Yes, you would need to update that module to work with the new version of vBGallery.

Thanks Keith. You guys are great! I love your fast service.