EllisLab text mark
Advanced Search
     
Upgrade from EE 1.7.1 to EE 2.3.1 - Error
Posted: 06 December 2011 01:08 PM   [ Ignore ]
Avatar
Joined: 2008-02-25
834 posts

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.

 Signature 

Rouviere Media — I Build Expression Engine Sites. sans-borders.

 
Posted: 07 December 2011 03:39 PM   [ Ignore ]   [ # 1 ]   [ Rating: 0 ]
Avatar
Joined: 2008-01-31
4773 posts

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!

 Signature 

Need some help? | Current Versions: EE 2.6.1 // MM 1.2.1

 
Posted: 07 December 2011 03:42 PM   [ Ignore ]   [ # 2 ]   [ Rating: 0 ]
Avatar
Joined: 2008-02-25
834 posts

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

 Signature 

Rouviere Media — I Build Expression Engine Sites. sans-borders.

 
Posted: 08 December 2011 04:47 PM   [ Ignore ]   [ # 3 ]   [ Rating: 0 ]
Avatar
Joined: 2008-01-31
4773 posts

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

 Signature 

Need some help? | Current Versions: EE 2.6.1 // MM 1.2.1