Two versions of cpg1.4.10, but two significantly different databases

[amb]

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.

[François Keller]

Have you modifying your include/config.inc.php file in accord with  your new database connection info?

[Nibbler]

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

[amb]

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 Expand

While executing query "SELECT extension, mime, content, player FROM cpg_filetypes;" on 0

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

[Nibbler]

Running update.php should fix that.

[amb]

Thank you *very* much. That took care of it.