ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Database error after upgrade

August 12, 2010 6:43am

Subscribe [2]
  • #1 / Aug 12, 2010 6:43am

    Matt Powell

    42 posts

    Hello.

    I have just upgraded my system from EE1 to EE2, and now whenever I try to go to the Content > Edit tab I receive the error

    Error Number: 1054
    
    Unknown column 'channel_id' in 'field list'
    
    SELECT comment_id, entry_id, channel_id, COUNT(*) as count FROM (exp_comments) WHERE entry_id IN ('95', '93', '94') GROUP BY entry_id

    Where 93, 94 and 95 are the IDs of the published pages. I can only access the edit page when I have no entries published.

    Any help on this matter greatly appreciated. My EE version is v2.1.0 Build 20100805. I have disabled all addons and it’s not made any difference.

    Cheers
    Matt

  • #2 / Aug 12, 2010 7:29pm

    Brandon Jones

    5500 posts

    Greetings Matt, can you confirm that you followed this documentation:

    Updating from 1.x to 2.x – ExpressionEngine Documentation

    Also, which version of EE1 were you upgrading from, and did you encounter any errors during the upgrade?

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases