Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: weird sql error :-(  (Read 3725 times)

0 Members and 1 Guest are viewing this topic.

godyn

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
weird sql error :-(
« 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: weird sql error :-(
« Reply #1 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.
Logged

godyn

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Re: weird sql error :-(
« Reply #2 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??? :-(
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: weird sql error :-(
« Reply #3 on: August 07, 2008, 09:50:36 am »

Logged

godyn

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Re: weird sql error :-(
« Reply #4 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?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: weird sql error :-(
« Reply #5 on: August 07, 2008, 10:04:53 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: weird sql error :-(
« Reply #6 on: August 07, 2008, 05:54:52 pm »

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.
Logged

godyn

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Re: weird sql error :-(
« Reply #7 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?)
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: weird sql error :-(
« Reply #8 on: August 11, 2008, 07:50:07 am »

Maybe donwloading the latest CPG and than upgrade all (so that the DB will also be updated?)
Give it a try. 8)
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 21 queries.