Thread

After trying to update EE to the latest version I’m nolonger able to access the EE control panel. The error I’m getting seems to be member-centric. The site runs fine but no matter what I try I can’t access the control panel. I even rolled back the database from a backup and uploaded the EE 2.1.2 files, but still getting this 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` = ‘d1d7eded4386abdbbae2cced37ccc8cabc741fa7’ AND `password` = ‘ef2a76e2f85186fb3a9c605e656e27d143e706a1’ AND m.group_id = g.group_id

Filename: expressionengine/libraries/Session.php

Line Number: 494

Any suggestions?

Rolled back to 2.1.1 and things work fine again. Not sure what’s going on with 2.1.3

You did run the actual update as well, I suppose? Were the changes to the db made as expected?

I tried to run the update (2.1.3) but it didn’t seem to work. The update jumped to the part where it tells you to remove the “installer”. There was no notification of the database being updated.

Darcy,

Can you confirm you followed all steps in your version update please. Double check permissions, theme updates etc.

What permissions specifically does your config file have?