Thread

Upgrading from 1.6.9 to 2.1… all seemed to go fine until..

A Database Error Occurred
Error Number: 1091

Can't DROP 'page_id'; check that column/key exists

ALTER TABLE `ee_wiki_category_articles` DROP KEY `page_id`

Any idea where to start digging?

ArneG,

Can you confirm the build of 2.1 you’re upgrading to? Also, what is $conf[‘app_version’] in your EE 1.6.9 config.php file?

I am getting a similar error:

A Database Error Occurred

Error Number: 1091

Can’t DROP ‘page_id’; check that column/key exists

ALTER TABLE `exp_wiki_category_articles` DROP KEY `page_id`

I am dead in the water. I cannot access the control panel to confirm the build number, but it is version 2.1.0 and I downloaded it two days ago.

The current config.php: $config[‘app_version’] = “202pb01”;

The one I backed up prior to starting the update: $conf[‘app_version’] = “167”;

==========
UPDATE: Nevermind. After finding some other similar posts, I deleted the Wiki directory from modules. The update completed.

Thanks.

Glad to see it worked for you. Marking this one as “Resolved”, please fell free to start a new one at any time.