weird sql error :-(

[godyn]

Since my CPG is moved to an other server I get this strange error.
Can s.b. please help me out, since this is a large gallery with many visitors :-(

Code Select Expand

While executing query "SELECT * FROM cpg11d_config" on 0

mySQL error: Table 'gsf_cop1.cpg11d_config' doesn't exist

[Joachim Müller]

Not so weird, but pretty self-explanatory imo: the error message complains about a missing table. Therefor, make sure that you have successfully backuped and restored that database table when moving servers.

[godyn]

Thanks for the quick reply ! :-)
Yes, that's what I thought also.
But my hoster (who moved the site from an other server) said I had to ask in the forum.
Seems that he's trying to get away with it?

I think he won't have a good backup.
Is there a way to save my gallery??? :-(

[Αndré]

If your old CPG still exists: http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#moveGallery

[godyn]

no it doesn't :-/
isn't there a way to fix it?
Or maybe from an old backup restore that table?

[Αndré]

make sure that you have successfully backuped and restored that database table

Open your database via phpmyadmin/mysqldumper/.. and check, if the missing table exists or not. If not, you maybe can restore it from an old backup.

[Joachim Müller]

Thanks for the quick reply ! :-)
Yes, that's what I thought also.
But my hoster (who moved the site from an other server) said I had to ask in the forum.
Seems that he's trying to get away with it?

I think he won't have a good backup.
Is there a way to save my gallery??? :-(

It's your task to back up frequently and to dump/restore the database, not the webhoster's task unless your webhosting contract clearly says the opposite.

[godyn]

thx , it seems that the hoster did a good transfer, but somehow there was a bug that split up the DB in 2 pieces (I have 1 DB in cpanel, but 2 in phpmyadmin)
I tryed installing a very old backup from cpg, but that gives a fatal error. (and repairing doesn't work)
Do you guys have an idea how to upgrade this old DB to the new CPG?
Maybe donwloading the latest CPG and than upgrade all (so that the DB will also be updated?)

[Αndré]

Maybe donwloading the latest CPG and than upgrade all (so that the DB will also be updated?)

Give it a try.