Thread

Hi there,

I tried to upgrade from 2.1.4 to 2.3.0. However, I must admit that I tried to upgrade on earlier version and it also failed at that time.
I think problems started when I tried to upgrade to 2.1.5 and for whatever reason it did not complete and I aborted the upgrade.

Now, trying to upgrade to 2.3.0 I get the following 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 checked the related table, but the entry already exists (batch_location). How can I go on? Do I have to change the table manually?

I run my site just for my personal use, so I am not really an expert on all the db stuff.

Can you point me in the right direction?

Thanks

stefan

Hi stefan and welcome to the forums

We have a help article which covers an attempted upgrade, the duplicate table and what to do next.

Let us know how you get on with the suggestions there

Hi John,

thanks for your reply.
I was aware of the help articles. The problem is that I am not really sure, when the problems were induced (I was not aware of the db manipulations at that time). Therefore I don’t have a backup of the database that has the “correct” structure. So going way back with a backed up version is not an option as I would loose too much data.
Is there a manual way to sort the database problems out? In other words can I work out the error messages?
As stated in my first post, the variable batch_location is already existing in the mentioned table.

Stefan,

Did you capture a backup of the database before attempting to update? What you will need to do is roll back to that database and then look for the problem column in the table. If you find “batch_location” in your backup, then we would need to know if you ever attempted an update previous to this that didn’t work?

Cheers,

Hi Dan,

thanks for your reply.
As I suspected, the problems started, when I tried to update 214 to 215. Therefore I changed the version number in config.php to 215 last night and tried again. This time it worked flawless.
I am still working on my addons (tags, super search), but I think that will work out as well.

Thnaks for your effort!!

stefan

Stefan,

Excellent! Good luck with your add-on updates. If you need further assistance, let us know via a new thread.

Cheers!