Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: weird sql error :-(  (Read 4122 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: 15764
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: 15764
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: 15764
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.017 seconds with 20 queries.