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.
Have you modifying your include/config.inc.php file in accord with your new database connection info?
Upgrades and fresh installs will have slightly different databases. Enable debug mode to see what the fatal error actually is.
Quote from: Frantz 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?
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.
Quote from: Nibbler 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.
I get this:
While executing query "SELECT extension, mime, content, player FROM cpg_filetypes;" on 0
mySQL error: Unknown column 'player' in 'field list'
Running update.php should fix that.
Thank you *very* much. That took care of it.