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.

cannot edit content from cp: database error 1054

October 05, 2011 7:43pm

Subscribe [2]
  • #1 / Oct 05, 2011 7:43pm

    rjc

    30 posts

    Hi,

    When I try to edit content from a new channel after a migration I get this error:

    A Database Error Occurred

    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 (0) GROUP BY entry_id

    Filename: controllers/cp/content_edit.php

    Line Number: 712

    I deleted all old channels and form fields and status and categories. then created new one and a content item, then I could not edit the newly created content, the edit button returns the above error….

    Thanks!
    Ron

     

  • #2 / Oct 06, 2011 11:48am

    rjc

    30 posts

    I performed update and had some errors so I rolled back, but still having the 1054 datatbase error…

    OK, looking at the error I decided to un-install the comments module, this fixed the error into the entries—which I can now edit.

    I re-installed the comments module and I can once again access entries via the edit link in the CP.

     

  • #3 / Oct 06, 2011 3:39pm

    Sue Crocker

    26054 posts

    Hi, Ron. Glad things are working again for you. If anything else comes up, please do let us know in a new thread..

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

ExpressionEngine News!

#eecms, #events, #releases