Thread

Hello,

I’m currently running expressionengine via engine hosting. I’ve been attempting to upgrade from the first version of 2 to 2.1.3 and have been experiencing issues.

Everything runs smooth, and after running the install wizard via the system folder I receive the following error message:

{"error":"

Error Number: 1050
\n\n

Table 'exp_comment_subscriptions' already exists
\n\n

CREATE TABLE `exp_comment_subscriptions` (\n\t`subscription_id` int(10) UNSIGNED AUTO_INCREMENT,\n\t`entry_id` int(10) UNSIGNED,\n\t`member_id` int(10) DEFAULT '0',\n\t`email` varchar(50),\n\t`subscription_date` varchar(10),\n\t`notification_sent` char(1) DEFAULT 'n',\n\t`hash` varchar(15),\n\tPRIMARY KEY `subscription_id` (`subscription_id`),\n\tKEY `entry_id` (`entry_id`),\n\tKEY `member_id` (`member_id`)\n) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
\n\n

Filename: updates/ud_211.php
\n\n

Line Number: 101
"}

Any ideas how to alleviate this and finally get our site upgraded to the most recent version? For reference, the only extension we currently have installed are WYGWAM and SiteMap. I haven’t uninstalled WYGWAM before the install because I’m concerned it will purge the blog entries which have been completed using the extension.

Would appreciate any help or suggestions to solve this!

I disabled the Comment module and on the next attempt to update I no longer received the comment database error, but now receive the following error:

A Database Error Occurred

Error Number: 1060

Duplicate column name ‘show_sidebar’

ALTER TABLE exp_members ADD show_sidebar char(1) NOT NULL default ‘y’ AFTER quick_tabs

Filename: updates/ud_212.php

Line Number: 53

So frustrating!

Ok, solved the two issues above and finally was able to update using the tips in this thread:

http://ellislab.com/forums/viewthread/178011/

Now a new issue, I receive a language error when attempting to access the control panel or the site itself after the upgrade

An Error Was Encountered

Unable to load the requested language file: language/english/core_lang.php

Ok, think I solved all my issues myself with some searching. Not sure the language solution is proper, but I just copied the expression engine 2.1.3 language files into the language directory and was able to access my site as well as the dashboard.

Not sure, but the upgrade instructions informs users to replace the new language folder with a copy from their backup. If the new install is looking for specific files only available in the new language folder, maybe the upgrade post should make reference to this.

This post can be closed.

Thanks for letting us know. Please post again in case there’s anything else.