Thread

Ok I tried to upgrade on my own but it seems I cant do it :( I am using v2.1.0 Build: 20100712

I have multiple sites installed and this may be part of the issue.

This is what I did…

1st time I downloaded the new version.
Uploaded it to the server, as the tutorial suggested and swapped out the appropriate files on the server
  * system/expressionengine/config/config.php
  * system/expressionengine/config/database.php
  * system/expressionengine/language/ (if you are using a language pack or previously modified the English language files)
  * system/expressionengine/third_party/
  * system/expressionengine/templates/
  * themes/third_party/ (if it exists, and any additional third-party theme files you had previously)

Didn’t work.

Then I deleted the whole thing and tried copying the old (working) system folder and uploading to it the files that didn’t have anything to do with MSM.

Didn’t work.

I deleted everything again. And used the new updated system version and just added the MSM files to it. Uploaded the whole thing the last thing I got was this message…

A Database Error Occurred

Error Number: 1050

Table ‘exp_comment_subscriptions’ already exists

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

Filename: updates/ud_211.php

Line Number: 101

« Back

When I switch to the old system it worked again. So I am missing something?

Any thoughts?
V

Hi, V.

When you were doing your fiddling, did you empty out the database entirely and start over with an empty database?

No not at all I want to keep all content and simply update the EE.

Before you started upgrading, did you remove that particular table? It doesn’t exist in EE2.1.0.

No I never mess with the database. o_O

Are you back on 2.1.0 now? When you check your database, does it have a ‘exp_comment_subscriptions’ table?

Yes back to 2.1. I don’t know how to check the database. I never mess w it. I let we deal with all that. I just put in database name n password. That’s all.

Please go to the Control Panel > Tools > Data > SQL Manager > Manage Database Tables. Please let us know if there is, in fact, one by the name of exp_comment_subscriptions.

Yes its there   exp_comment_subscriptions   Browse   0   1.0 KB

BUT when I click browse

The query you submitted did not produce any results…

your thoughts?

It’s possibly / probably corrupted. It shouldn’t be there, at any rate. Do you have an earlier backup? Otherwise I’d suggest to use a tool such as phpMyAdmin to delete this table before attempting to upgrade again.