adv_gallery_categories table not found

[aacircle]

Just upgraded to Photopost 5.6 and moved to a new server. Just got an email stating:

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 : animeonline.net/cron.php?&rand=724600
Referrer : animeonline.net/gallery/
IP Address : 69.241.199.178
Username : Unregistered
Classname : vb_database

Do I need to create this table since it doesn't exist? I know this table doesn't exist on our other site's installation either.

Thank you.

[Zachariah]

Originally Posted by aacircle

Just upgraded to Photopost 5.6 and moved to a new server. Just got an email stating:

Do I need to create this table since it doesn't exist? I know this table doesn't exist on our other site's installation either.

Thank you.

The error you posted is related to vBGallery but you state that you "upgraded to Photopost 5.6"

[aacircle]

Yes, did upgrade to Photopost 5.6. But I thought vBGallery is to mean the same thing nowadays.

[ludachris]

I just upgraded to vbgallery 2.1 and had just upgraded vb to 3.6.4 and am receiving this same error.

[ludachris]

Originally Posted by ludachris

I just upgraded to vbgallery 2.1 and had just upgraded vb to 3.6.4 and am receiving this same error.

Disregard my post, I figured it out. Somehow I uploaded all the files from the Forums directory but not the Gallery directory. I didn't get much sleep last night

[aacircle]

Well I've just got the exact same error on our our forums over at aacircle.

Do I need to create this table vb3_adv_gallery_categories to fix the problem? These error messages come about twice a week, so it's very rare considering the volume on our boards.

[aacircle]

Ok, found out the reason why it is only occurring twice a week. Because everytime the vbSEO sitemap scheduled task kicks in, that's when the trouble occurs.

So is this a required table or not?

[Zachariah]

adv_gallery_categories

This was the name of a table in-use by the gallery.
- In vBGallery 1.1+, 2.0+ the table was renamed to ppgal_categories

Is there a script that may be running that calls for the old table names ?

[aacircle]

Hmm... the trouble only occurs when the vbSEO sitemap task runs. I will ask over there, even though they did tell me to ask u guys...