SEO

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.

__________________
** English Teacher and Student Site **
Teach English in Japan, Korea, Taiwan or China

Teaching Community at Teacher Forums
New ESL Directory!

[SIGPIC][/SIGPIC] Anime Forums! Anime Online

That error appears to be related to PhotoPost vBGallery.

__________________
Keith Cohen / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum

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.

__________________
Keith Cohen / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum

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.

__________________
Keith Cohen / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum

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