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.

MAJOR upgrade issue: Duplicate column name 'can_search'

September 25, 2012 1:21am

Subscribe [1]

#1 / Sep 25, 2012 1:21am
cityzen
83 posts
I’m getting SQL errors on upgrade from 2.1.3 to current version. Errors are all along the lines of:
```
A Database Error Occurred
Error Number: 1060

Duplicate column name 'can_search'

ALTER TABLE exp_member_groups ADD COLUMN can_search char(1) NOT NULL default 'n'

Filename: updates/ud_009.php

Line Number: 112
```
Obviously the site is down and I didn’t really plan a whole night of trying to sort out issues like this… need to get this resolved ASAP.
#2 / Sep 25, 2012 1:34am

cityzen
83 posts

Apparently after the first pass, the updater changed my config file and that was causing subsequent issues. I suppose this is “resolved” but you all might want to take a look at this since it has popped up on the forums several times.
#3 / Sep 25, 2012 5:06pm

Kevin Smith
4784 posts

Hi cityzen,

Thanks for letting us know you were able to resolve it! Is there anything else I can help with?