forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: godyn on August 07, 2008, 09:15:41 am

Title: weird sql error :-(
Post by: godyn on August 07, 2008, 09:15:41 am

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]

While executing query "SELECT * FROM cpg11d_config" on 0

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

Title: Re: weird sql error :-(
Post by: Joachim Müller on August 07, 2008, 09:26:59 am

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.

Title: Re: weird sql error :-(
Post by: godyn on August 07, 2008, 09:48:13 am

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??? :-(

Title: Re: weird sql error :-(
Post by: Αndré on August 07, 2008, 09:50:36 am

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

Title: Re: weird sql error :-(
Post by: godyn on August 07, 2008, 09:59:17 am

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

Title: Re: weird sql error :-(
Post by: Αndré on August 07, 2008, 10:04:53 am

Quote from: Joachim Müller on August 07, 2008, 09:26:59 am

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.

Title: Re: weird sql error :-(
Post by: Joachim Müller on August 07, 2008, 05:54:52 pm

Quote from: godyn on August 07, 2008, 09:48:13 am

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.

Title: Re: weird sql error :-(
Post by: godyn on August 10, 2008, 09:18:09 pm

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?)

Title: Re: weird sql error :-(
Post by: Αndré on August 11, 2008, 07:50:07 am

Quote from: godyn on August 10, 2008, 09:18:09 pm

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

Give it a try. 8)