Thread

This question may be related to a resolved thread.

Hi

I seem to be having the same problem as David was having in the thread above. I updated my 1.7.1 to 1.7.3, all went fine. Optimised and repaired my tables, then followed the update instructions. It all looks fine until I get to 2.5.2, where the screen goes blank. If I then refresh I get

A Database Error Occurred
Error Number: 1091
Can’t DROP ‘user_blog’; check that column/key exists
ALTER TABLE `exp_referrers` DROP COLUMN `user_blog`
Filename: /xxxxx/xxx/xxxx/admin/expressionengine/modules/referrer/upd.referrer.php
Line Number: 146

So I tried Dan’s suggestion and took a look in PHPMyAdmin. Sure enough, exp_referrers doesn’t have a user_blog column. So I add it manually (as type “text”, and after ref_agent), and refresh the updater. Again I get a blank screen. Refreshing again shows the error above. Then I check in PHPMyadmin and the new user_blog field has gone.

Any ideas how to fix this? My client is unable to edit their site while all this is going on, so would be good to find a fix ASAP.

Thanks!

Hi Frank,

I’m sorry for the trouble and confusion this has caused for you!

When I gave that advice in the other thread, it was before the bug and fix had been reported.

The best course here would be to take your install back to 1.7.3 using the backup captured before the 2.0 upgrade process.

Next, apply the bug fix as outlined in the report, and run the upgrade again.

If that doesn’t square this away, let me know.

Cheers,

Hi Dan

Thanks for getting back to me. It looks like that bug is already fixed though? In my copy of 2.5.2 that line already says “referrers” - but I’m still getting the error when I try to upgrade…

Sorry to bump, but this is getting quite urgent - my client can’t make any updates until this is done… Any idea what I can try?

Hi Frank,

Sorry to bump…

No worries, bumping has no effect, good or bad, on the order of the support queue. I feel your frustration and I want to get you taken care of. Be on the lookout for an email from EllisLab.

Cheers,

Hi Dan

Thanks for the login request. I’m afraid I’m working on a local copy (on MAMP) rather than on the live site though. The live site is still on 1.7.x while I’m doing this update. Is there anything else you could do diagnosis-wise without having access to the site itself?

Hey Frank,

Work through the Wiki on Troubleshooting Upgrade Errors.

The most important thing is to get the database back to your pre-update-attempt sate. Then run the upgrade straight to 2.5.2 - there is no need to update within the 1.x version first.

How large is your database?

Cheers,

Hi Dan

Thanks - I’ll work through those, and go straight from my 1.7.1 version.

The DB is 60MB. Might that be a problem?

Just tried again going straight from 1.7.1 - still the same error. It’s going fine until it gets to 2.5.2, then, if in Firefox, I get a blank page. If in Chrome I get:

HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.

Refreshing the page gives me the DB error from my first post above. I can’t see anything on that wiki page that would apply. It is a database error, so maybe one of the add-ons I’m using has messed up the DB? I’m not sure where I’d even start diagnosing that though…

I’ve just put a copy onto a temporary domain name and replied to your earlier request for login details - hopefully that will help figure out what’s going on here!

Thanks, Frank

Hi Frank,

It is a database error, so maybe one of the add-ons I’m using has messed up the DB? I’m not sure where I’d even start diagnosing that though…

Add-ons are a possibility. The ExpressionEngine installer will attempt to run the update function on anything in the /system/expressionengine/third_party folder. I’ve taken to a habit of renaming this briefly to “_third_party” then running the EE installer.

Once it’s complete, I name it back, log in and make sure all the add-ons are up-to-date as well.

I’ve just put a copy onto a temporary domain name and replied to your earlier request for login details - hopefully that will help figure out what’s going on here!

Oh, fantastic! Can you try the trick I mentioned as well? We’ll be following up with you on the login thread as well.

~

Hi Frank,

It is a database error, so maybe one of the add-ons I’m using has messed up the DB? I’m not sure where I’d even start diagnosing that though…

Add-ons are a possibility. The ExpressionEngine installer will attempt to run the update function on anything in the /system/expressionengine/third_party folder. I’ve taken to a habit of renaming this briefly to “_third_party” then running the EE installer.

Once it’s complete, I name it back, log in and make sure all the add-ons are up-to-date as well.

I’ve just put a copy onto a temporary domain name and replied to your earlier request for login details - hopefully that will help figure out what’s going on here!

Oh, fantastic! Can you try the trick I mentioned as well? We’ll be following up with you on the login thread as well.

~

Hi Dan

I don’t have anything in /system/expressionengine/third_party other than safecracker_file. As I’m going from EE1 to EE2 all of my add-ons will need to be replaced with 2.x versions - so I’ve not copied them into the new system folder. I’m presuming it’s OK to leave third_party as it is in this case?

If so, I’m not sure what else I can try from my end - hopefully you guys will see something in the one I put online!

Thanks for your help!

Hi Frank,

We’ve got your response and we’ll be working with you to sort out the upgrade.

~

Thanks Dan!