Thread

This question may be related to a resolved thread.

I am having a similar problem to the above thread - upgrading a Freelancer license from 2.1.0 to 2.2.1 on a local working copy of a site and have tried emptying the database first but I am still coming across the same error.

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

I’ve hit the back button, deleted this table from the database and tried again and I get:

A Database Error Occurred
Error Number: 1054

Unknown column 'notify' in 'where clause'

SELECT COUNT(*) AS `numrows` FROM (`exp_comments`) WHERE `notify` = 'y'

Filename: updates/ud_211.php

Line Number: 119

Any ideas? The resolved thread above didn’t really explain what fixed the problem in the end.

Sorry, you can close this thread. I solved this issue by rolling back and disabling all add-ons (Freeform and PT Dive Bar field types). Came across a different error (212 upgrade) but was able to fix it thanks to the info provided in this thread.

Glad you got it figured out, 43north! Thanks for updating us on the situation.

If anything else comes up, please don’t hesitate to let us know!