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.

Update to 2.1.2 Session.php error

December 16, 2010 7:56am

Subscribe [5]
  • #1 / Dec 16, 2010 7:56am

    Jamie

    33 posts

    Hi -

    I’ve updated to 2.1.2

    After getting a white screen at CP login (front end is fine) I ran a debug and was presented with the following error:

    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` = '0fa2981959b79d540edb6591d013e939e2c7e1a3' AND `password` = '22a84209b1a1343b209aa1af0e64342bd494e739' AND m.group_id = g.group_id
    
    Filename: libraries/Session.php
    
    Line Number: 494

    As a temporary fix, I’ve removed the show_sidebar call from line 472 in Session.php

    From This….
    
    {            
             $select .= ', m.cp_theme, m.quick_links, m.quick_tabs, m.template_size, show_sidebar';
    }
    
    To This…. 
    
    {            
             $select .= ', m.cp_theme, m.quick_links, m.quick_tabs, m.template_size';
    }

    So, I can now login fine - but obviously the sidebar will not remember the previous state - not such a big deal really, just wanted to post this in case someone was having a similar issue.

    J

  • #2 / Dec 16, 2010 9:37am

    Rob Sanchez

    335 posts

    Did you run the installer/updater? It’s supposed to add that column show_sidebar to your member DB table.

  • #3 / Dec 16, 2010 9:54am

    Jamie

    33 posts

    I was just updating from a the previous build…. I’m still supposed to run the installer?

    Edit:... timmeh! need more caffeine.

  • #4 / Dec 16, 2010 9:59am

    Rob Sanchez

    335 posts

  • #5 / Dec 16, 2010 10:01am

    Jamie

    33 posts

    yeah - seems actually referring to the docs is helpful. Add me to the ‘fail’ list.

    :down:

  • #6 / Dec 16, 2010 4:32pm

    Ingmar

    29245 posts

    So, you’re up and running? Just making sure.

  • #7 / May 10, 2011 3:25am

    stinhambo

    1268 posts

    I had a similar problem but the installer didn’t add the column to the table. Had to manually do that.

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

    John Henry Donovan

    12339 posts

    Steve,

    Can I confirm all is ok now that you have manually added it?

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

    stinhambo

    1268 posts

    Certainly have! Sorry, forgot to update the original post.

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

    John Henry Donovan

    12339 posts

    Nice one 😊 Feel free as always to start a new thread if you have any more questions

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

ExpressionEngine News!

#eecms, #events, #releases