Thread

Hi everyone,

I’m trying to upgrade EE 1.6.9 to EE 2.1.0. but I’m getting repeating errors like this:

Error Number: 1050

Table 'exp_channel_member_groups' already exists

ALTER TABLE `exp_weblog_member_groups` RENAME TO `exp_channel_member_groups`

I go into PHPMyAdmin and drop the offending table, but then I get exactly the same error for another table, and on this goes until I get to the exp_sites table, when I get this error:

A Database Error Occurred

Error Number: 1054

Unknown column 'site_weblog_preferences' in 'exp_sites'

ALTER TABLE `exp_sites` CHANGE `site_weblog_preferences` `site_channel_preferences` TEXT NOT NULL

How do I resolve this?

Do you have a pre-update backup? What version information do you have in config.php?

Do you have a pre-update backup?

Oh yes.

What version information do you have in config.php?

Here’s the config.php file that’s currently on my server—some information has been redacted:

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

$config['manual_templates_move'] = "y";
$config['app_version'] = "169";
$config['license_number'] = "";
$config['debug'] = "1";
$config['install_lock'] = "1";
$config['cp_url'] = "http://www.mysite.com/weblog/ee_system_folder_name/index.php";
$config['doc_url'] = "http://expressionengine.com/docs/";
$config['cookie_prefix'] = "";
$config['is_system_on'] = "n";
$config['allow_extensions'] = "n";
$config['multiple_sites_enabled'] = "n";
$config['ud_next_step'] = "weblog_terminology_changes";
$config['trackbacks_to_comments'] = "n";
$config['archive_trackbacks'] = "n";
?>

Hi mwdesign,

1. Can you go ahead restore your database from the backup, and ensure there are no exp_channel_xxx named tables in there before running the upgrade again?
2. Which browser are you performing the update with?

1. Can you go ahead restore your database from the backup, and ensure there are no exp_channel_xxx named tables in there before running the upgrade again?

Okay, I dropped all the exp_channel tables, ran the updater, and got this message:

A Database Error Occurred
Error Number: 1054
Unknown column 'site_weblog_preferences' in 'exp_sites'

ALTER TABLE `exp_sites` CHANGE `site_weblog_preferences` `site_channel_preferences` TEXT NOT NULL

2. Which browser are you performing the update with?

Firefox 3.6.12, Mac OSX 10.6.5.

After I dropped the tables, I again ran the Installer, and I got this message:

ExpressionEngine Installation and Update Wizard

We have detected that you are currently running ExpressionEngine version 2.0.2
If you are ready to update ExpressionEngine to version 2.1.0 click the link below:
Click here to update ExpressionEngine to Version 2.1.0

I clicked update, agreed to the Terms of Use, and got this message:

A Database Error Occurred
Error Number: 1054
Unknown column 'can_access_files' in 'exp_member_groups'

ALTER TABLE `exp_member_groups` ADD `can_access_fieldtypes` char(1) NOT NULL DEFAULT 'n' AFTER `can_access_files`

Don’t drop any tables, or in fact manipulate the db directly, please just restore the db to where it was before. Upload a fresh set of files and run the upgrade again. Stop at the first error and tell us about it, please.

Don’t drop any tables, or in fact manipulate the db directly

Er, okay—I dropped the tables per Brandon’s direction:

ensure there are no exp_channel_xxx named tables in there before running the upgrade again

Please just restore the db to where it was before.

Okay, done.

Upload a fresh set of files and run the upgrade again. Stop at the first error and tell us about it, please.

Okay, I’ve uploaded a fresh set of files and followed the instructions here.

First message:

ExpressionEngine Installation and Update Wizard
We have detected that you are currently running ExpressionEngine version 1.6.9
If you are ready to update ExpressionEngine to version 2.1.0 click the link below:
Click here to update ExpressionEngine to Version 2.1.0

Then I go to the License Agreement: (agree)
Trackback Conversion and Archiving Options (no/no)

Here’s the first error—it’s the same error I got when I started the upgrade:

An Error Was Encountered
There was an error moving your existing template files to an archive folder. Please manually move any folders in the form system/expressionengine/templates/<site_short_name>/ to a backup location and then Resume the Update.

Aside from index.html and .htaccess, I have no files in the system/expressionengine/templates/<site_short_name>/ directory.

Please advise on how to proceed. Thanks!

Hi mwdesign,

Can you please check that the system/expressionengine/templates folder has the correct permissions - you are uploading a fresh set of files and you need to make sure that all the permissions are correct - and then run through this process again.

Cheers

Greg

Can you please check that the system/expressionengine/templates folder has the correct permissions - you are uploading a fresh set of files and you need to make sure that all the permissions are correct - and then run through this process again.

Hi Greg,

The system/expressionengine/templates folder is set to 777.

Here’s the next error:

{"error":"

Error Number: 1050
\n\n

Table 'exp_accessories' already exists
\n\n

CREATE TABLE `exp_accessories` (\n `accessory_id` int(10) unsigned NOT NULL auto_increment,\n `class` varchar(75) NOT NULL default '',\n `member_groups` varchar(50) NOT NULL default 'all',\n `controllers` text NULL,\n `accessory_version` VARCHAR(12) NOT NULL,\n PRIMARY KEY `accessory_id` (`accessory_id`)\n )
"}

If I go back (browser Back button), I get this error:

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`) )

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`) )

I am getting similar errors, but with the ALTER command telling me I have duplicate tables in the DB.

I remove the first one, gives me another similar error for another table, remove that and the first one comes back, then just loops from there.

Pondering commenting out the commands that are adding the duplicate tables, but I wanted to make sure that these were not needing to be updated for version 2.

Here is the actual error that I am receiving.

{"error":"
Error Number: 1060

\n\n
Duplicate column name 'last_author_id'

\n\n
ALTER TABLE `exp_templates` ADD `last_author_id` INT(10) UNSIGNED NOT NULL AFTER `edit_date`

\n\n
Filename: updates/ud_165.php

\n\n
Line Number: 55

"}

Hi, mwdesign, can you check PHP Info for your max execution time and let us know that that value is?

You may need to have your host increase that value to get through the update.

Thanks!

can you check PHP Info for your max execution time and let us know that that value is? You may need to have your host increase that value to get through the update.

Where do I find this information? I’m using phpMyAdmin.

See: EEWiki:// Create a PHPInfo File

Once you create that file and visit it with your browser, you’ll be able to find the value for max execution time.

Does that help?