Thread

Hi,

I’m upgrading from 2.3.1 and I’m getting the below database error.

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

I have perused the forums for solutions and have tried:

• Setting permissions on config.php
• removing third_party folders in system and themes
• disabling extensions
• repairing the database through phpmyadmin
• The app version was displaying properly in the CP before upgrading.

I’m running MAMP php 5.3.6

I’m not sure what else to try. Thanks if anyone can help.

Hi Jeremy,

I’m sorry to see you have run into this error while trying to update!

The error is the result of the column named being already present in the database. This can happen when artifacts are left from previous update attempts. Although, that’s just one cause.

When it comes to troubleshooting failed updates, you will need a copy of the database before any update attempts were made. Capturing this backup is the first step outlined in the User Guide, so you should be in good shape there.

With that backup handy, follow the steps in the Wiki on Troubleshooting Upgrade Errors.

Once you have the database rolled back, have a look and see if ‘can_search’ already exists in the exp_member_groups table.

Cheers,

Thanks Dan,

I did do a backup of my DB before running the upgrade, but it seems to also have these artifacts. Perhaps an update was run unsuccessfully in the past.

Thanks.

Dan,

I was thinking about this again. Would not the fact that the installer is starting from the very first update file (ud_009.php) and not ud_240.php as it is supposed to be the cause of the problem?

There are some features in 2.4 that I would like the client to have. It would be great if I could update the software!

Thanks.

Ok, so I tried copying my config.php and database.php from a fresh install and using that instead. I thought there might be some customization throwing it off.

EE still thinks I’m upgrading from Public Beta pb01.

Note: I copied the config.php from a 2.4 install. Not sure where to get a 2.3.1 version.

Hi Jeremy,

Indeed, the installer should not attempt to run the process from “The Beginning”.

Before you run the update, what is set for $config[‘app_version’] in /system/expressionengine/config/config.php ?

It should be the version you are currently running ($config[‘app_version’] = ‘231’;. That is what the installer uses to base “the beginning” off of.

Also, double check that the copies of config.php and database.php that you moved have the correct settings, and that the permissions are set to 666

I look forward to your reply!

Cheers,

Ok, I could swear I checked the permissions. Working now.

Thanks!

Hey jeremydouglas,

No worries. It’s the little things right?

If you need anything else, please just let us know by opening a new thread.

Have a great weekend!

Cheers,