View Full Version : Just moved server
April 4th, 2007, 10:00 AM
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.
April 4th, 2007, 10:18 AM
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.
April 4th, 2007, 12:43 PM
When I look at my old hosting I cant see that exact table name there
April 4th, 2007, 12:45 PM
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?
April 4th, 2007, 12:46 PM
Ive just checked and its under ppgal_categories and ppgal_images - in which file should I change the path?
April 4th, 2007, 12:47 PM
I dont remember changing it thats what it set itself up as
April 4th, 2007, 12:49 PM
Are your other tables for gallery using ppgal_ as their prefix?
April 4th, 2007, 12:50 PM
yes they all are.
April 4th, 2007, 12:55 PM
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.
April 4th, 2007, 12:58 PM
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.
April 4th, 2007, 01:22 PM
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.
April 4th, 2007, 01:28 PM
looking at some of the files, for example the gallery/misc.php it does have ppgal as the prefix.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.