Thread

Upgrading 1.6.6 to 2.2.0, the ‘weblog_id’ column in exp_comments does not get renamed to ‘channel_id’. This generates this error directly after the Survey screen at the end of the 2.2.0 upgrade:

{"error":"
Error Number: 1072<\/p>\n\n

Key column 'channel_id' doesn't exist in table<\/p>\n\n

ALTER TABLE `exp_comments` ADD KEY (`channel_id`)<\/p>\n\n

Filename: /ee220a\/system\/expressionengine\/modules\/comment\/upd.comment.php<\/p>\n\n

Line Number: 256<\/p>"}

I checked a backup of a 1.6.6 to 2.1.3 upgrade, and that column was properly updated from weblog_id to channel_id.

As a test, just before clicking past the Survey screen, I manually updated the column name, and then continued the install. It completed successfully.

I have never used the comments module, so that may or may not be related to this issue.

I have also made sure to download the post-hotfixed 2.2.0 install files.

Since I can manually get around this issue, I don’t need assistance. Just wanted to let you know this is occurring, and for anyone else who may be searching on this error message. 😊

Ian,

Thanks for the report. There was a recent hotfix for the update error if the comment module wasn’t installed.
Sorry for the inconvenience and glad you had the know how to get up and running.

Can I confirm everything else is ok with your install?

As noted in the original post, I am aware that 2.2.0 had a hotfix to fix an issue related to the comments module, but I am 100% certain that I am working from the hotfixed files. I have downloaded the 2.2.0 files multiple times in a specific effort to be certain that I have the hotfixed files, but this error still occurs.

What can I look for in the files to make sure I’m using the hotfixed files?

See: EEWiki:// How can I tell if I’m using the hotfixed version of EE2.2

If the file specified in this wiki entry hasn’t been changed, then you aren’t using the hotfixed files.

Also see: http://ellislab.com/forums/viewthread/192292/
Does that help?

I am indeed running the hotfixed files, but that error persists.

Here’s the correct link to that wiki page:

http://expressionengine.com/wiki/How_Can_I_tell_I’m_Using_the_hotfixed_version_of_EE2.2/

EDIT:

The forum does not allow proper linking to your wiki as the URL contains an apostrophe. I copied the content over into the wiki page you get when clicking the link…

Hi, Ian,

We’ll need to see if we can reproduce this locally going from EE 1 directly to EE 2.  I know that this was tested prior to release, but we’ll run through it again just in case it is a wider problem.

Thank you.