Thread

Attempting to upgrade from v1.6.4 to 1.7.0, following these instructions:

http://expressionengine.com/legacy_docs/installation/update.html

the upgrade.php script says it will (as a first step i assume?) upgrade from v1.6.4 to v1.6.5, but when it attempts to do so the following error is generated:

MySQL ERROR:

Error Number: 1060

Description: Duplicate column name 'last_author_id'

Query: ALTER TABLE `exp_templates` ADD `last_author_id` INT(10) UNSIGNED NOT NULL AFTER `edit_date`

Do I need to download v1.6.5 first? can’t find any download other than 1.7.0

Note that I had no prior failed attempts to upgrade the system.

You wouldn’t need to download another version than the latest.

I can only recommend that you try and optimise/repair your database tables under the sql manager page.

Admin ›  Utilities ›  SQL Manager ›  Manage Database Tables

I’ve run the repair and optimize on all database tables.

Same error:

Error: The following error was encountered
MySQL ERROR:

Error Number: 1060

Description: Duplicate column name 'last_author_id'

Query: ALTER TABLE `exp_templates` ADD `last_author_id` INT(10) UNSIGNED NOT NULL AFTER `edit_date`

What next?

It sounds like it’s trying to add in a column that already exists.

You could try commenting out line 35 of system/updates/ud_165.php which should look like the following.

// $Q[] = "ALTER TABLE `exp_templates` ADD `last_author_id` INT(10) UNSIGNED NOT NULL AFTER `edit_date`";

I commented out that line and the one after that, and it worked. No idea why there was already that column. Maybe this thread will help someone else. Thanks…

Thanks for the assist, ReverendAudrey!

fogcity, if you have failed upgrades you may also have issues with partial table creation and/or field changes. Glad things are working for you again. Don’t hesitate to post again as needed.