Thread

Hello!

We’ve been trying to update EE and unsuccessful. Getting various errors during the wizard. below are some examples:

{"error":"
Error Number: 1054<\/p>\n\n

Unknown column 'last_author_id' in 'exp_templates'<\/p>\n\n

ALTER TABLE `exp_templates` CHANGE `last_author_id` `last_author_id` INT(10) NOT NULL DEFAULT 0<\/p>\n\n

Filename: updates\/ud_200.php<\/p>\n\n

Line Number: 1382<\/p>"}

and then

A Database Error Occurred
Error Number: 1050

Table ‘exp_snippets’ already exists

CREATE TABLE `exp_snippets` ( `snippet_id` int(10) unsigned NOT NULL auto_increment, `site_id` int(4) NOT NULL, `snippet_name` varchar(75) NOT NULL, `snippet_contents` text NULL, PRIMARY KEY (`snippet_id`), KEY `site_id` (`site_id`) )

Filename: updates/ud_200.php

Line Number: 1382

Please help

Mod: Edited for security reasons

Hi artdriver,

Welcome to the forums 😊

Let’s work backwards. Your second error’s likely cause is because you may have hit your browser’s back button after getting the second error or is you restored your 1.6.8 database then you did not restore back into a completely empty database. Do either of those sound likely?

Can you roll back to EE1.6.8 please and when you restore your database make sure it is restored into a completely clean database.

Then can you verify if your exp_templates table has the last_author_id column?

This would have been added in EE1.6.5

Was this a fresh install of have you upgraded previous versions?

1.  When we initially try to update, we get this error:
{“error”:”
Error Number: 1054<\/p>\n\n
Unknown column ‘last_author_id’ in ‘exp_templates’<\/p>\n\n
ALTER TABLE `exp_templates` CHANGE `last_author_id` `last_author_id` INT(10) NOT NULL DEFAULT 0<\/p>\n\n
Filename: updates\/ud_200.php<\/p>\n\n
Line Number: 1382<\/p>”}
2.  We correct the error by adding to the table exp_templates the field last_author_id.
3.  We restore the database to the original condition and once again add the field mentioned in #2.
4.  Launch the update and in the middle of updating from 2.0.0 to 2.0.1 we get this error:
{"error":"
Error Number: 1091<\/p>\n\n
Can't DROP 'show_show_all_cluster'; check that column\/key exists<\/p>\n\n
ALTER TABLE `exp_channels` DROP COLUMN `show_show_all_cluster`<\/p>\n\n
Filename: updates\/ud_202.php<\/p>\n\n
Line Number: 165<\/p>"}

Hi artdriver,

Can you verify that in your original database, the exp_templates table has a last_author_id column?

yes, it does!

Hi, artdriver.

Do you still have your original EE 1.x database dump?

The error about the snippets already being in there is caused by a failed upgrade, and extra tables not being deleted before you install a second time.

In other words, clear out EVERY table in the database container, put back the 1.x db and try again.

Does that help?