Web host stuffed up my site

[Russ_]

 My web host had server trouble or something and shifted my site, along with others, to a new one I believe. My website's html pages all moved okay, but my gallery went haywire.
I had about 14,500 photos in about 100 albums in about 5 categories. I now have only one album and category showing! Grrrr. They seem unable to restore the gallery. Their latest comment: "This is not an issue with the database since we have dumped the latest one.
I really can't figure out on why Coppermine isn't showing the folders - the files are there and the database is the latest."


I'm a novice at this kind of thing, but I poked around my site's Control Panel and found how to get to the phpMyAdmin and look at a few things in the database, way too scared to try anything without advice though.


All my photos still reside in their original location on my website (gallery/albums/xxxx), so I don't have to upload them again at least.


When I click on my "database name>cpg15x_albums", I can still see all the albums in there (see attachment), similarly the categories are all still there, and the photos are there in the "cpg15x_pictures". So it's like I just have to click something to get everything back to normal.


Any ideas to try?

[Jeff Bailey]

You can try the everything option in the admin tools:
http://documentation.coppermine-gallery.net/en/admin-tools.htm#admin_tools_options_rebuild

[Russ_]

Nope, though I leave the selection as "All Albums" it still just prcesses the one album that is showing.

I now notice that in the "tables" list on the left, under "albums" it only shows the one album that appears on the website (see attachment). If I can get the albums into there i guess I'm away laughing..

[Jeff Bailey]

in your include/config.inc.php check your prefix.
looks like you want it to be:

Code Select Expand

$CONFIG['TABLE_PREFIX'] =                'cpg15x_';

[Russ_]

Already like that i believe - see attachment

[Russ_]

aauuggh please delete that

[Jeff Bailey]

i just did. probably should change your password also now.

[Russ_]

cheers! 

I should read it first!! 

anyway I think it showed the prefix is correct?

[Jeff Bailey]

It did, the question is why is your database duplicated and why does one have a prefix and the other doesn't.

Did you have 2 galleries installed with the same database?

[Russ_]

No, only one. Must be something to do with the shift they did?

[Russ_]

Just checked - when I go to "Databases", it only shows the one: coppermine_a

[Jeff Bailey]

Yes but you have two sets of each table ... one with a prefix and one without. In the first image you show the 'cpg15x_ablums' table and in the second image you show the 'albums' table. There should only be one set.

try backing up your database then delete all the tables that don't have a prefix, or the group of tables that don't have the correct albums.

[Jeff Bailey]

have you ran update.php? that would show the tables and possibly fix any errors.

[Russ_]

have you ran update.php? that would show the tables and possibly fix any errors.

Just did that, everything said "Already Done", and nothing changed!
Still trying to figure out how to back it up before changing it for your previous suggestion.

[Jeff Bailey]

What table names did the update.php show?
http://documentation.coppermine-gallery.net/en/export.htm#backup_database_tools_phpmyadmin

[Russ_]

Got it!!

I deleted all those tables without cgp15x_ in front. The gallery spat the dummy and gave me a clue that it couldn't find the table prefix. So I went back to config.inc.php, and that line saying table prefix had no prefix, so I copied and pasted you line above in your 2nd reply into the config file and saved. Now the gallery works!! Wahoo!! So although it was right the first time, the gallery just wasn't reading it right or something, it needed to "reboot" that file.

[Russ_]

Thank you, thank you, thank you, thank you, thank you, thank you!

[Jeff Bailey]

No problem. Strange that the image you uploaded had the prefix though.

Please mark the thread as solved.
http://forum.coppermine-gallery.net/index.php/topic,55415.msg270631.html#msg270631