Hi:
I’m currently running EE 1.4.1, and just tried to upgrade to the latest version, 1.6.2. However, I ran into the dreaded:
Error Number: 1050
Description: Table ‘exp_member_search’ already exists
Query: CREATE TABLE `exp_member_search` ( `search_id` varchar(32) NOT NULL, `search_date` int(10) unsigned NOT NULL, `keywords` varchar(200) NOT NULL, `fields` varchar(200) NOT NULL, `member_id` int(10) unsigned NOT NULL, `ip_address` varchar(16) NOT NULL, `total_results` int(8) unsigned NOT NULL, `query` text NOT NULL, PRIMARY KEY (`search_id`), KEY `member_id` (`member_id`) )
error twice, first when the update script attempted to go to EE 1.5. At this point, I searched the EE forums for a solution, which suggested I do a compare of the config file using config-check.php located here and manually updating the file to match- that got me through until once again I encountered the same error when trying to go up from EE 1.5 to EE 1.6. As I didn’t want to risk seriously corrupting the database, I’ve just downgraded back to EE 1.4.1 until I have a better understanding of how to fix the problem at its core.
By searching the forums, the Error 1050 problem when updating seems to be a pretty common one. I see the general explanation for the cause is that config.php isn’t chmod 666, but I’m certain mine is. Is there anything else I can do to ensure the update script runs properly the next time I attempt an upgrade? Assuming the file is chmod correctly, is there anything else on a server that may be contributing to EE crapping out and returning this specific error when running the update script?
Thanks,
