Thread

I’ve been trying to upgrade to 2.2 since yesterday.  I just downloaded the latest version of 2.2 but I’m still getting errors on install. This happens after the terms and conditions page.  PLEASE HELP

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

Duplicate column name 'show_sidebar'<\/p>\n\n

ALTER TABLE exp_members ADD show_sidebar char(1) NOT NULL default 'y' AFTER quick_tabs<\/p>\n\n

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

Line Number: 53<\/p>"}

nothing?

I desperately need help with this.  I’ve tried everything I can think of. I even disabled all modules and add-ons before upgrading.

I’ve tried manually manipulating the DB as well. I’m completely lost and my boss doesn’t understand why our site is still down.  I’m losing valuable time.

If I have to do a complete re-install, it’s going to take weeks to re-input all of the data.

Please help.

Tried to do a fresh install but now, when I go to the CP, I’m getting:

An Error Was Encountered
Unable to load the requested class: auth

I am truly in Expression Engine hell.

Let’s get things on track for you.  First- download a fresh copy of EE.  That auth error is odd and there were some hotfixes that shouldn’t be related to your install/update issue, but better to have a fresh, clean copy.

Next- do you want to try the update again or a clean install?  If you’re wanting to upgrade, I’d tend to say let’s just work our way through that.

If so- what version are you updating from?  The error you ran into?  Occurs in the 2.1.2 update:

$Q[] = "ALTER TABLE exp_members ADD show_sidebar char(1) NOT NULL default 'y' AFTER quick_tabs";        
$Q[] = "ALTER TABLE exp_member_fields ADD m_field_cp_reg char(1) NOT NULL default 'n' AFTER m_field_reg";

Sometimes that will happen if the updater tries to run the same script twice.  One thing to do if you try to update and get the same error again?  Go in and see if all of the other queries for that update have been run.

For example- does the exp_member_fields table have a column called m_field_cp_reg in it?  If so- that query has also been run.  If you track that update file to the end, the last query is

$Q[] = "UPDATE exp_comments SET location = '' WHERE location = '0'";

So- if in exp_comments the location field has no 0 values- and empty field instead?  All the queries actually ran succussfully.

We can manually change the config to show you’re running 2.1.2 and then restart the update- which should start running the 2.1.3 update.

But I know that’s a lot to parse.  So let’s just run the update, see if it does fail in the same spot- if it does, let me know if those other queries I mention above executed.

And if any of that was confusing, let me know and I’ll walk you through it in more detail.

I am having the exact same issue. However I don’t have a 0 in the location for the exp_comments table. I assume the entire update didn’t go through.

HELP PLEASE!!! Thanks in advance!

@capstonedesigngroup- check this for me- in your exp_member_fields table, do you have a field named m_field_cp_reg?

Robin,
I just ended up reversing to a previous version of EE for now. I am not going to sweat it at this time.

Good news.  I upgraded successfully.  I’m having issues with the file manager not showing my old files, but I guess that’s another thread.

This is what I did to upgrade:

I reverted back to my previous install, installed the comments module, just to be safe.
Downloaded the newest release of EE 2.2
Changed my version from ‘213’  to ‘212’  in config.php.

Followed the upgrade instructions.

Sounds good, capstone.  I don’t believe there’s a bug, but if you need help when it is time to upgrade, let us know.

Ron- thanks for update on what you did- filemanager issue may be because you need to sync your files to get them in the db.  See docs- it was mentioned in version notes, but 2.1.4 notes, so could have been missed.  But yep, if you’re having an issue after that, try a new thread.

And Paw Paw- how’s it going with you?

I just got the exact same error. Upgrading from 1.7.1 to 2.2.2. My EE2 config.php file shows v 212.  I have m_field_cp_reg in the exp_member_fields table and there are no 0 values in the exp_comments location field - only empty values. and some actual location values.

[edit] I just changed the version number to 213 in the config.php file and the upgrade process concluded all the way to 2.2.2… was this a bad idea?

Luke- looks like 212 updates did apply and it was just an issue with the config.  From here, looks like you did the right thing and all should be well.

Any issues cropping up, or are you running smoothly?

Yes Thanks Luke

Yes, so far so good, thanks Robin

Sounds like all’s well then.  I’m going to wrap this one up, as it could start to get confusing in length/breadth.  But if something does crop up, just start a new thread and we’ll hit it.

Thanks!