Thread

ME SAD. need help-  Errors on install from 2.1.3

A Database Error Occurred
Error Number: 1061

Duplicate key name 'last_activity_idx'

CREATE INDEX last_activity_idx on exp_sessions(last_activity)

Filename: updates/ud_220.php

Line Number: 82

Hi, Ron. Which version did you upgrade? We’ve had a few other people with the same problem, but can’t replicate locally. Also, who are you hosted with? We appreciate your patience as we figure this out.

I’m getting this error too.
2.1.3 - > 2.2

I just experienced this same exact error. I was upgrading an EE installation from EE 2.1.3 Build 20101220 to EE 2.2. I am hosted by Media Temple’s Grid Service.

I get the error in Firefox, Safari, and Chrome.

The config file now shows that it is 2.1.5. Does that mean that it made it that far in the update process?

I thought by waiting nearly 3 days after the release of 2.2 I’d avoid this kind of thing.

What do I do now?

Same problem here. Update from 2.13 to 2.2. No solution found yet…:-(

IJsbeer,
Not sure if this will work for you but try this.

Revert back to your previous 2.1.3 install
change your version number in config.php from “213” to “212”
then follow the 2.2 upgrade steps.

This will perform the 2.1.3 upgrade first.
good luck

Hi Ron,

Thanks. I don’t know if it helped, but at this moment the upgrade to 2.2 is succeeded.
I deleted in phpmyadmin all the indexes and fields that were added by 2.2 and in the end that solved it.

I tried what Ron suggested and reverted back to 2.1.3 and edited the config to read version 212. Then I ran the installer again, and now I am getting a new error:

A Database Error Occurred

Error Number: 1060

Duplicate column name ‘batch_location’

ALTER TABLE `exp_upload_prefs` ADD `batch_location` VARCHAR(255)

Filename: updates/ud_215.php

Line Number: 169

I tried starting all over once again. I reverted back to 2.1.3 and my old database. I double checked that everything was working. I went back through all the updating steps including clearing cache and checking file permissions. I made sure the config file stated version 2.1.3 (which it is).

I ran the installation, and I got a new error:

A Database Error Occurred

Error Number: 1050

Table ‘exp_file_watermarks’ already exists

CREATE TABLE `exp_file_watermarks` ( `wm_id` int(4) UNSIGNED AUTO_INCREMENT, `wm_name` varchar(80), `wm_type` varchar(10) DEFAULT ‘text’, `wm_image_path` varchar(100), `wm_test_image_path` varchar(100), `wm_use_font` char(1) DEFAULT ‘y’, `wm_font` varchar(30), `wm_font_size` int(3) UNSIGNED, `wm_text` varchar(100), `wm_vrt_alignment` varchar(10) DEFAULT ‘top’, `wm_hor_alignment` varchar(10) DEFAULT ‘left’, `wm_padding` int(3) UNSIGNED, `wm_opacity` int(3) UNSIGNED, `wm_x_offset` int(4) UNSIGNED, `wm_y_offset` int(4) UNSIGNED, `wm_x_transp` int(4), `wm_y_transp` int(4), `wm_font_color` varchar(7), `wm_use_drop_shadow` char(1) DEFAULT ‘y’, `wm_shadow_distance` int(3) UNSIGNED, `wm_shadow_color` varchar(7), PRIMARY KEY `wm_id` (`wm_id`) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Filename: updates/ud_215.php

Line Number: 317

After several tries, I finally got past all the errors I’ve already listed and came across a Structure error.

Fortunately, the Structure error had already been reported and a user published a temporary fix that would allow the EE installer to complete and get past the Structure issue.

https://structure.tenderapp.com/discussions/questions/432-ee-220-upgrade-with-structure-anyone-else-getting-an-error

Thankfully, I am now running EE 2.2. I honestly have know idea why I got such a variety of errors during my multiple attempt at installing the EE update. I did the same exact process each time.

Hi all,

Can you let us know what browser were you using to run the upgrade? It seems the update script can run multiple times in some instances.

I’m sorry, I won’t be much help. I actually got the error Ron started this thread with in Firefox, Safari, and Chrome on a Mac. I tried all of those.

I ended up settling on using Firefox when I experienced the other errors I mentioned in this thread. I didn’t think of it at the time, but in hindsight I wonder if the fact that Firefox auto-updated me to Firefox 5 this last week was a factor?

JLoft - Table ‘exp_file_watermarks’ already exists

That’s a 2.2 only table, if you hadn’t totally removed all the tables in the database container, that makes sense why you got that error.

But everything is OK now?

Im also getting the same error… although have started a new thread for it… http://ellislab.com/forums/viewthread/192819/

Etheya, let’s continue troubleshooting your thread there instead. Deal.

Everybody else OK now?