Thread

Hi,

I am getting a database error updating to the latest version of EE. It is the same error message as in the thread http://ellislab.com/forums/viewthread/192213/#907297.

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 would have to try and remove the problem manually from the database as I tried to update before and it did not work and I do not have a version of the database that goes back that far.

What is the best way of removing the column name ‘batch_location’  and others if necessary to get the installation to work?

It is hosted on EngineHosting.

Hi David,

I’m sorry this update is producing errors for you. You say you don’t have a copy of the database from before you attempted an update? Have you contacted EngineHosting to see if they might have one they can roll you back to? Manually rolling back the changes that the update process made before it got to this point would be tedious at best.

What version of ExpressionEngine are you updating from?

Cheers,

Hi Dan

It was back in Mid July when I tried before so EngineHosting does not have versions that go back that far.

EE version is v2.1.4.

What is the best procedure for doing this manually. I don’t really know anything about databases.

Thanks

David

I ‘am now getting this error after deleting `exp_upload_prefs`

A Database Error Occurred
Error Number: 1146

Table 'eh7340a.exp_upload_prefs' doesn't exist

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

Filename: updates/ud_215.php

Line Number: 169

David,

Please roll back to your last-know good database, back up your site files and be on the lookout for an email from me.

Cheers,

David,

When I wen to login to your site, I was presented with the ExpressionEngine installer.

Without a database backup that predates an attempt to update, I’m afraid EE support is going to be unable to resolve this. There is simply nothing we can do with the database in an unknown state. Our suggestion is that you post a to the Job Board for a database expert that will be able to forensically roll your database back to its 2.1.4 state. Once the db has been walked back, take a backup and follow the instructions completely before attempting an update again.

Backing up *before* updating is the most crucial part of the update process. It *must* be done, otherwise if errors arise, there is very little we can offer in the way of help.

Cheers,

Dan

Backing up *before* updating is the most crucial part of the update process. It *must* be done, otherwise if errors arise, there is very little we can offer in the way of help.

Its back to its original state before I updated.

The same problems will occur again with the database because as I mentioned before I tried updating and it did not work so there must be something left over from that update which is causing the problems?

I did follow the instructions as per updating. I have done updates to other sites to the latest version and have had no problems.

Is this site therefore not going to updated unless somebody looks at the database?

Thanks

David

David,

The same problems will occur again with the database because as I mentioned before I tried updating and it did not work so there must be something left over from that update which is causing the problems?

This is correct, and the reason I advise posting a Job to the Job Board for a database expert that can take you database back to a schema that matches the version of ExpressionEngine that you are running on this site.

Dan

So the database needs taking back to July when I first tried to update the site?

There is no funding for this so I doubt if it will be possible. It will just have to stay as is.

Thanks

David

David,

That is correct. In order to successfully update, the database will need to be in exactly the state it was in before you attempted any updates. This is the reason that it is imperative to have a backup as outlined early in the update instructions and warned again in a pop-up before the update script runs.

Cheers,

Hi

I contacted Tim Mahoney at http://eevolution.co.uk who helped me with this problem. Tim was very informative and helpful in sourcing the problem and then recommending how to fix it.

Hi David,

So Tim was able to get you all squared away? Were you able to successfully update with his help?

Cheers,

Yes, now updated to latest version.

Glad you are up and running again. Feel free to start a new thread if you have any more questions.

Closing