[Solved]: Problem restoring database

[zyuray]

I moved to a new server and this is what I did step by step:

On the old server, in SSH:
mysqldump gallery > gallery.sql

I transferred gallery.sql to my new server
I uploaded all Coppermine files to the new server.
I transferred all album folders to the new server into the same locations.

On the new server, in SSH:
mysqladmin create gallery

I ran the install.php script, connecting to 'gallery'
Coppermine is up and running, but blank

On the new server in SSH:
mysqladmin drop gallery
mysqladmin create gallery
mysql gallery < gallery.sql

Now this appears when I visit the site:

Fatal error :
There was an error while processing a database query

Did I do something incorrectly?

[Nibbler]

Check the table name prefix in config.inc.php, then enable debug mode directly in the database (config table, debug mode -> 1) and see what the failed query was.

[zyuray]

I enabled debug mode, and it told me that the "cpg_filetypes" table was missing, which was true - it was not in the database after the restore.

I copied the entire cpg_filetypes table from a fresh Coppermine installation, and now I get this:

Notice: Undefined index: allowed_doc_types in /home/rbase/public_html/include/media.functions.inc.php on line 38

Notice: Undefined index: allowed_doc_types in /home/rbase/public_html/include/media.functions.inc.php on line 38

Notice: Undefined index: allowed_doc_types in /home/rbase/public_html/include/media.functions.inc.php on line 38

Notice: Undefined index: allowed_doc_types in /home/rbase/public_html/include/media.functions.inc.php on line 38

Notice: Undefined index: user_group_list in /home/rbase/public_html/include/init.inc.php on line 273
Fatal error :
There was an error while processing a database query

[Nibbler]

Run the update.php.

[zyuray]

Thanks.

Looks like I was restoring a 1.2.1 db onto a 1.3.0 installation.

Oopsie

[zyuray]

Ok, so I restored everything with 1.2.1 and it worked fine. Then I followed the upgrade 1.3.0 directions. After running update.php, the following occurs:

While executing query "SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = ''  ORDER BY pos" on 0

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

[Nibbler]

Adding the thumb column should be done by update.php, make sure the user you are running coppermine under has permission to do ALTERS on your database.

[zyuray]

The user does have alter privileges.
This is all the update.php file reports doing:

ALTER TABLE cpg_comments add msg_raw_ip tinytext Already Done
ALTER TABLE cpg_comments add msg_hdr_ip tinytext Already Done
ALTER TABLE cpg_pictures add pic_raw_ip tinytext Already Done
ALTER TABLE cpg_pictures add pic_hdr_ip tinytext Already Done
INSERT INTO cpg_config VALUES ('thumb_use', 'any') Already Done
INSERT INTO cpg_config VALUES ('show_private', '0') Already Done
INSERT INTO cpg_config VALUES ('first_level', '1') Already Done
INSERT INTO cpg_config VALUES ('display_film_strip', '1') Already Done
INSERT INTO cpg_config VALUES ('max_film_strip_items', '5') Already Done
INSERT INTO cpg_config VALUES ('comment_email_notification', '0') Already Done
CREATE TABLE cpg_banned ( ban_id int(11) NOT NULL auto_increment, user_id int(11) DEFAULT NULL, ip_addr tinytext DEFAULT NULL, expiry datetime DEFAULT NULL, PRIMARY KEY (ban_id) ) TYPE=MyISAM Already Done
Upgrade completed
Coppermine is now upgraded and ready to roll.


Let's continue !

[Nibbler]

You are using the 1.2 version of update.sql - all your files have to be the 1.3 version.

[Casper]

Can you check the database to see if it has been created.  'already done' is given when the action is not required, but also when the action fails.

[zyuray]

Re-verified my steps. All works now. Thanks guys