Hi everyone,
Ran into a bit of a strange issue while upgrading EE 2.1.1 to 2.1.3 (build 20101220) today.
The updater mentioned the update failed, with the following error:
Error Number: 1060
Duplicate column name ‘show_sidebar’
ALTER TABLE exp_members ADD show_sidebar char(1) NOT NULL default ‘y’ AFTER quick_tabs
Filename: updates/ud_212.php
Line Number: 53
So, I restored everything, verified that the show_sidebar column didn’t exist in the exp_members table and ran the update again.
Strange thing, same error showed. So, it looks like the show_sidebar column was being added twice somehow. I commented the
ALTER TABLE exp_members ADD show_sidebar char(1) NOT NULL default ‘y’ AFTER quick_tabs
line in the ud_212.php file, restored everything once again and ran the updater successfully this time. Then, I added the column manually and everything is fine now.
Posting this for anyone else having the same issue!