Just moved server

[ravenfire]

I have just moved and now I am getting error messages, can anyone help please:-


MySQL Error : Table 'vbulletin.adv_gallery_categories' doesn't exist

I get that when trying to look at whats new longer than the last 10 days or when trying to look at whats popular

and I get this in my admincp:-

MySQL Error : Table 'vbulletin.adv_gallery_images' doesn't exist

Also when I click to modify my settings in my gallery in my admincp my normal list of options isnt there.

Thanks

[Neal-UK]

Have you uploaded that table to the new DB and have you made sure it's using the same name?

That error is stating that the table does not exist, basically.

I've just moved my site to a new host and everything went okay.

[ravenfire]

When I look at my old hosting I cant see that exact table name there

[Neal-UK]

I think the table name would be something along the lines of: adv_gallery_categories and possibly it's trying to find vbulletin.adv_gallery_categories

Did you amend the default table prefix on the old install / server?

[ravenfire]

Ive just checked and its under ppgal_categories and ppgal_images - in which file should I change the path?

[ravenfire]

I dont remember changing it thats what it set itself up as

[Neal-UK]

Are your other tables for gallery using ppgal_ as their prefix?

[ravenfire]

yes they all are.

[Neal-UK]

ppgal_ is the default prefix. you may have to change them to vbulletin.adv_gallery_TABLE NAME.

I'm not too sure what else to say here, perhaps someone else or the PP team can assist further. May be best seeing what they say as I can't see a way to change the db prefix in the admin panel.

[Neal-UK]

I take it you did download your old DB and import into the new host DB? Strange why it's changed if all you did was swop servers, unless you did a new install on the new server by mistake. All I did was move the files to the new server and import the tables into the database one table at a time.

[ravenfire]

All I did was move the whole database across to the new server. I have had the gallery for quite some while but recently did a new install after I couldnt get it working properly on another server move.

[ravenfire]

looking at some of the files, for example the gallery/misc.php it does have ppgal as the prefix.