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.

Unknown column 'show_sidebar' in 'field list'

May 10, 2011 2:49am

Subscribe [3]
  • #1 / May 10, 2011 2:49am

    stinhambo

    1268 posts

    I just updated a site from 2.1.0 to 2.1.3 and I get the following error when accessing the CP ~

    A Database Error Occurred
    Error Number: 1054
    
    Unknown column 'show_sidebar' in 'field list'
    
    SELECT `m`.`username`, `m`.`screen_name`, `m`.`member_id`, `m`.`email`, `m`.`url`, `m`.`location`, `m`.`join_date`, `m`.`last_visit`, `m`.`last_activity`, `m`.`total_entries`, `m`.`total_comments`, `m`.`total_forum_posts`, `m`.`total_forum_topics`, `m`.`last_forum_post_date`, `m`.`language`, `m`.`timezone`, `m`.`daylight_savings`, `m`.`time_format`, `m`.`profile_theme`, `m`.`forum_theme`, `m`.`private_messages`, `m`.`accept_messages`, `m`.`last_view_bulletins`, `m`.`last_bulletin_date`, `m`.`display_signatures`, `m`.`display_avatars`, `m`.`parse_smileys`, `m`.`last_email_date`, `m`.`notify_by_default`, `m`.`ignore_list`, `m`.`crypt_key`, `m`.`cp_theme`, `m`.`quick_links`, `m`.`quick_tabs`, `m`.`template_size`, `show_sidebar`, `g`.* FROM (`exp_members` m, `exp_member_groups` g) WHERE `g`.`site_id` = '1' AND `unique_id` = 'b87131384f54f8eac25556a922d905887280cf45' AND `password` = 'c4ed74f31f75a4af4c89d29830ef2f97b1e578dd' AND m.group_id = g.group_id
    
    Filename: libraries/Session.php
    
    Line Number: 494

    Any ideas?

  • #2 / May 10, 2011 4:49am

    John Henry Donovan

    12339 posts

    Steve,

    It should have been added when the installer was run. I see you manually added it here. Are you happy for me to close this one out?

  • #3 / May 10, 2011 4:51am

    stinhambo

    1268 posts

    Go ahead.

  • #4 / May 10, 2011 4:53am

    John Henry Donovan

    12339 posts

    Closing

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

ExpressionEngine News!

#eecms, #events, #releases