Thread

OK, let me report this as clear as possible.
On running the updater I get the following 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

The updater also reports that I’m running “We have detected that you are currently running ExpressionEngine version Public Beta pb01” while it’s a 2.1.1 install.
Other odd events is that the config.php file reverts to another file after the update stops because of the error.
The config file now reads:

<?php if ( ! defined('BASEPATH')) exit('Invalid file request');

$config['multi_login_sites'] = "http://gpsnaarwerk.be/index.php|http://ww.gpsnaarwerk.be/index.php|http://www.gpsnaarwerk.be/index.php|http://abvvov.gpsnaarwerk.be/index.php|http://acvge.gpsnaarwerk.be/index.php";
$config['app_version'] = "0";
?>

This issue http://ellislab.com/forums/viewthread/213301/ seems related (and links to a few other related issues so I’m guessing this has been a common accurence when upgrading from 2.1.1)

Any suggestions?

OK, it looks like I had a stray $conf[’‘] in my config.php.
That solves the abovementioned error and it’s also properly reporting a 211 install.

Still no go unfortunately, currently it hangs on:

A Database Error Occurred

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

« Back

Any suggestions?

Seems like most of the errors centered around the 2.1 to 2.2 update, a few errors with duplicate columns even though I didn’t spot any keeping an eye on the DB.
I ran the update a few times, deleting the offending columns and retrying, that did the trick.
Once past 2.2 it continued on to 2.5.
Also checked all offending columns are present and accounted for (and only 1).
Still have a number of add-ons to update, fingers crossed no more issues 😊

Admins, feel free to close this thread.

Hey Eriwin!

I’m glad to see you were able to power through the update. All apologies for the inconvenience of it.

If you come across anything else, just let us know.

Cheers,