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: Two versions of cpg1.4.10, but two significantly different databases  (Read 4260 times)

0 Members and 1 Guest are viewing this topic.

amb

  • Coppermine newbie
  • Offline Offline
  • Posts: 3

I have changed to a new webhost and I am currently migrating all my website contents. I have a cpg1.4.10 installation at both hosts and was hoping to just export/import the database and thus keep my gallery. Unfortunately this plan doesn't work as smoothly as I had hoped.

When I overwrite the fresh installation with my gallery's database, I get a "Fatal error". I compared the two database files and the tables seem to be quite different. I'm not quite sure why this would be, or what I am to do to migrate my gallery.

Any advice would be greatly appreciated.
« Last Edit: July 23, 2007, 12:02:23 am by Nibbler »
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9096
  • aka Frantz
    • Ma galerie
Re: Two versions of cpg1.4.10, but two significantly different databases
« Reply #1 on: July 22, 2007, 01:40:11 pm »

Have you modifying your include/config.inc.php file in accord with  your new database connection info?
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Nibbler

  • Guest
Re: Two versions of cpg1.4.10, but two significantly different databases
« Reply #2 on: July 22, 2007, 09:33:24 pm »

Upgrades and fresh installs will have slightly different databases. Enable debug mode to see what the fatal error actually is.
Logged

amb

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Two versions of cpg1.4.10, but two significantly different databases
« Reply #3 on: July 22, 2007, 11:22:53 pm »

Have you modifying your include/config.inc.php file in accord with  your new database connection info?
Nope. I copied the database from the old host, installed cpg1.4.10 fresh at the new host, and tried to overwrite the new database with the copy from the old host. I checked config.inc.php after you mentioned it and everything seems fine.

Upgrades and fresh installs will have slightly different databases. Enable debug mode to see what the fatal error actually is.

I get this:
Code: [Select]
While executing query "SELECT extension, mime, content, player FROM cpg_filetypes;" on 0

mySQL error: Unknown column 'player' in 'field list'
Logged

Nibbler

  • Guest
Re: Two versions of cpg1.4.10, but two significantly different databases
« Reply #4 on: July 22, 2007, 11:42:18 pm »

Running update.php should fix that.
Logged

amb

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Two versions of cpg1.4.10, but two significantly different databases
« Reply #5 on: July 22, 2007, 11:49:25 pm »

Thank you *very* much. That took care of it.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 21 queries.