We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

Cannot upgrade to 2.10

How Do I?

m007's avatar
m007
83 posts
9 years ago
m007's avatar m007

Hi, I try to upgrade EE from 2.4 to 2.10 but in the second screen I got this error: “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”

If anyone can help me will be appreciated. Thanks

       
Robin Sowell's avatar
Robin Sowell
13,159 posts
9 years ago
Robin Sowell's avatar Robin Sowell

Oddly enough, that update actually occurs in the very, very first update available- .09. Which is why it’s saying ‘that field already exists!’.

The updater is trying to run the wrong update.

That typically happens when there’s an ‘old style’ variable name in your config.php file.

Open up system/expressionengine/config/config.php and make sure all of your variables have the format

$config['variable_name'] = 'n';

Especially watch out for any like

$conf['variable_name'] = "";

Did that do the trick?

       
m007's avatar
m007
83 posts
9 years ago
m007's avatar m007

Thanks Robin, yes, in config file was a line with $conf[‘variable_name’] Now it’s OK It was a very old version installed

       
Robin Sowell's avatar
Robin Sowell
13,159 posts
9 years ago
Robin Sowell's avatar Robin Sowell

Ah- that would do it. Glad you got it figured out!

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.