Hi,mwdesign. This is a bit drastic, but what I’d do is wipe the 1.6.x db, create a new one, do a fresh install to populate the exp_sites table, then import the other db, but not the exp_sites table, and see if that fixes things.
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
November 29, 2010 12:10pm
Subscribe [5]#16 / Dec 06, 2010 9:51am
Hi,mwdesign. This is a bit drastic, but what I’d do is wipe the 1.6.x db, create a new one, do a fresh install to populate the exp_sites table, then import the other db, but not the exp_sites table, and see if that fixes things.
#17 / Dec 06, 2010 10:33pm
This is a bit drastic, but what I’d do is wipe the 1.6.x db, create a new one, do a fresh install to populate the exp_sites table, then import the other db, but not the exp_sites table, and see if that fixes things.
Okay, I did that. I then exported the entire database—minus the exp_sites table—as one file, and tried to import it into the new database. Here’s the error I got when I tried to import the entire database:
Error
SQL query:
--
-- Dumping data for table `exp_accessories`
--
INSERT INTO `exp_accessories` ( `accessory_id` , `class` , `member_groups` , `controllers` , `accessory_version` )
VALUES ( 1, 'Expressionengine_info_acc', '1|5', 'tools_utilities|content_publish|addons_modules|addons_extensions|admin_content|content_edit|design|tools_communicate|admin_system|homepage|members|tools|content_files|myaccount|tools_data|addons_plugins|addons_fieldtypes|addons|tools_logs|addons_accessories|content', '1.0' ) ;
MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1
So I then exported each table as its own exp_ file and tried re-importing them one by one, but the duplicate tables reported errors:
Error
SQL query:
--
-- Dumping data for table `exp_actions`
--
INSERT INTO `exp_actions` ( `action_id` , `class` , `method` )
VALUES ( 1, 'Comment', 'insert_new_comment' ) , ( 2, 'Comment_mcp', 'delete_comment_notification' ) , ( 3, 'Mailinglist', 'insert_new_email' ) , ( 4, 'Mailinglist', 'authorize_email' ) , ( 5, 'Mailinglist', 'unsubscribe' ) , ( 6, 'Member', 'registration_form' ) , ( 7, 'Member', 'register_member' ) , ( 8, 'Member', 'activate_member' ) , ( 9, 'Member', 'member_login' ) , ( 10, 'Member', 'member_logout' ) , ( 11, 'Member', 'retrieve_password' ) , ( 12, 'Member', 'reset_password' ) , ( 13, 'Member', 'send_member_email' ) , ( 14, 'Member', 'update_un_pw' ) , ( 15, 'Member', 'member_search' ) , ( 16, 'Member', 'member_delete' ) , ( 23, 'Channel', 'smiley_pop' ) , ( 18, 'Channel', 'insert_new_entry' ) , ( 19, 'Search', 'do_search' ) , ( 20, 'Gallery', 'insert_new_comment' ) , ( 21, 'Gallery', 'delete_comment_notification' ) , ( 22, 'Jquery', 'output_javascript' ) , ( 24, 'Channel', 'filemanager_endpoint' ) ;
MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1
and the exp_comments file gave this error:
MySQL said: Documentation
#1054 - Unknown column 'channel_id' in 'field list'#18 / Dec 07, 2010 1:18am
Whew! Okay, I think I know what happened.
When I tried to upgrade, I must have overwritten/erased/damaged the database, which was then subsequently backed up, so the backups I downloaded were just backups of a screwed-up database. Per everyone’s advice, here’s what I wound up doing:
1. I created a new database, uploaded EE 1.6.9, and ran the Installer.
2. I downloaded a much earlier backup instead of one of the more recent versions.
3. I imported the earlier backup into the new database.
At the time of this writing, everything appears to be working. I’m now going to upgrade to EE v.2. Wish me luck.
Thank you, Ingmar, John, Sue, and Greg! I appreciate all your help.
#19 / Dec 07, 2010 10:15am
Make another backup before going to 2.x. We’re glad things are working again. Don’t hesitate to post again as needed.