Thread

I was upgrading a site from 1.4.2 Core to the full version of 1.6.9 (the latest build).

When I ran update.php, I received the following error message updating from 1.4.2 to 1.5:

Notice: Undefined index: prv_msg_send_limit in /.../updates/ud_150.php on line 116

Notice: Undefined index: prv_msg_storage_limit in /.../updates/ud_150.php on line 117
Error: The following error was encountered
MySQL ERROR:

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`) )

Also, if I try to access the control panel I get:

MySQL ERROR:

Error Number: 1146

Description: Table ‘mcpc.exp_sites’ doesn’t exist

Query: SELECT es.* FROM exp_sites AS es WHERE es.site_id = ‘1’

Help?!?

Hi, Doug. It sounds like you got part way through an upgrade earlier. You can elect to look at the db changes in the update file and find out where the last db change went through.. or you can edit the updates file to remove what has already been updated.