I am upgrading a site from EE 1.7.1 to EE 2.3.1 and get the following error:

A Database Error Occurred

Error Number: 1060

Duplicate column name ‘field_content_type’

ALTER TABLE `exp_weblog_fields` ADD COLUMN `field_content_type` VARCHAR(20) NOT NULL default ‘any’

Filename: updates/ud_200.php

Line Number: 1697

« Back

I have reviewed the other similar posting as well as the FAQ. I had engine hosting restore the database and still get the error. Please advise.

Thanks.

Hi Forrest,

I believe this support request is referring to an update you’re trying on a site where we’re working with the owner on an issue in EE 1.x, correct? In an effort to make sure we’re actually fixing the issues at hand, let’s take them one at a time. Could you roll back this site to its previously working state in EE 1 and make sure the site is fully functional? Then we’ll work with the site owner to fix the EE 1 issues, and try the update again once those are resolved.

In rolling back the database to EE 1, please make sure Engine Hosting completely clears the database before restoring the backup so that we don’t have any artifacts of the failed upgrade still in the database.

Thanks!

Hi Kevin,

I am one step ahead of you. We got the database restored and successfully upgraded to 1.7.1. We are testing it now to make sure everything is working correctly and nothing is missing. Once the coast is clear I’ll try the upgrade to 2.3.1. So please close this and I’ll open a new support request if needed.

Thanks.

Forrest

Thanks so much, Forrest. Indeed, open up a new thread if you require some additional assistance!