Thread

I had this exact same problem trying to upgrade to the beta version of EE2.  I keep getting these database errors when it goes to upgrade and it’s getting really irritating!  See below.

1. This is the very first error I get in the upgrade process, so I go in the database and delete this one just to see what happens.

Error Number: 1050

Table ‘exp_snippets’ already exists

2.  So i delete the snippets one and it creates it back and then I get this one.

Error Number: 1050

Table ‘exp_accessories’ already exists

And so forth and so forth.  It seems that EE wont upgrade or overwrite these tables as it should be able to do, to upgrade to 2.1.  Does anyone from Ellis labs have any help or suggestions on this.  I can’t be the only one to have this problem.

I’m on apache/mysql (latest versions) so it’s not a windows server causing the problems.  Also I have the latest version of 2.1 I just downloaded it this morning at 4am.

Just an update: a clean install works fine on my server, so it’s def. a problem upgrading from 1.x to 2.1

Hi, Kit2002.  It sounds like you’ve run some of the updates but perhaps your config.php has not been updated.  Please make sure your config.php is set to 666 permissions.  Also, do you see something like ud_next_step in the config.php If so, please tell us what that says.

Ok, I will have to upload all the files and stuff again and run the update wizard.  I had to revert back to 1.x so my site would work.

Ok let us know how you get on.

Encountering exactly the same error messages.

I deleted first the exp_snippets table, then the exp_accessories, now I get an “Error Number: 1050 Table ‘exp_layout_publish’ already exists”...

The next step written in my config.php is:

$config['ud_next_step'] = "database_changes";

Any help would be much appreciated!

forgot to explain that I first upgraded from 1.6.8 to 1.6.9, before trying 2.1.

I am also getting this error and I am also have ud_next_step = “database_changes”

Hi Jean-Michel and PJ4Quilts,

Please revert to your backups of 1.6.9 and then run the EE2 Server Wizard just to confirm that your server should support EE2 properly.

Cheers

Greg

Hi Greg, I am just doing a fresh install of the new verison. I don’t have a copy of 1.6.9 on my computer and I don’t have one to download in my downloads area. I did revert it back to 1.6.8 and it did come up.
If after doing the new install I have any problems I will write again.

Hi PJ4Quilts,

Okay, please let us know what happens, whether successful or not.

Cheers

Greg

Thanks Greg, it went successfully. I am doing another fresh install so that I can change the site theme.
While I was in there messing around it seemed to work fine. Just need to get used to where everything is.
If I run into any problems with the new fresh install I will write again.

Just on a side note, when someone wants to do a fresh install can most files be left on the server and only a few removed as well as the database to get to the fresh install point? If so it would make a great Wiki tutorial.

Hi Jean-Michel and PJ4Quilts,

Please revert to your backups of 1.6.9 and then run the EE2 Server Wizard just to confirm that your server should support EE2 properly.

Cheers

Greg

Test passed… for what it’s worth, I’m using MAMP Pro, MySQL 5.0.41, PHP 5.2.6

Jean-Michel,

Go ahead and revert back to your 1.6.9 files and database. You mentioned that you deleted some tables when attempting to upgrade, which shouldn’t be necessary. So, please roll-back to 1.6.9, attempt the upgrade and let us know the very first error you’re encountering before doing anything else.

ok, went back to my original 1.6.8 installation (reverted to backed up DB), first upgraded straight to 2.1 and got this message:

A Database Error Occurred
Error Number: 1060
Duplicate column name 'has_publish_fields'
ALTER TABLE `exp_modules` ADD COLUMN `has_publish_fields` char(1) NOT NULL default 'n'

So I started again, first upgraded to 1.6.9, but got the same error.

I also tried commenting out

//$Q[] = "ALTER TABLE `exp_modules` ADD COLUMN `has_publish_fields` char(1) NOT NULL default 'n'";

as suggested on another forum post, but then got a

Error Number: 1060  
Duplicate column name 'field_settings'  
ALTER TABLE `exp_channel_fields` ADD `field_settings` TEXT NULL

thanks for your help and patience with this.