Thread

Hi

Got this error when doing the upgrade to 2.4.0

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

Can someone help asap?

Thanks

Ended up having to restore db to back up as well as entire site. So now I’m back at 2.1.3

Every single time I have to upgrade EE, I go through similar types of pain. What is the deal? With WordPress you just click a button in the admin and it upgrades automatically including all plugins. Is this kind of simple functionality not possible to attain with EE?

Hi Jarin,

I’m sorry for the trouble you’ve been though trying to update ExpressionEngine. We are keenly aware of the headaches it causes for some users. I must applaud you for having backups handy, bravo!

In these instances, I recommend running the update process on a dev or local server to make sure there are no snags in the process.

With WordPress you just click a button in the admin and it upgrades automatically including all plugins. Is this kind of simple functionality not possible to attain with EE?

ExpressionEngine is more complex than WordPress in many ways, so that complicates the prospects of “1-click updates”. We have had numerous feature requests for this, so we know it is important to the Community.

Cheers,

Hi Dan, thanks for your reply. I finally got it to update. I accomplished it in a kind of hacky way: I had to go through each update file (ud_215.php, etc) and comment out the lines that were throwing errors. This took a while, but in the end it got me through the process.

I realize now that either the DB backup I was using was one taken after an initial failed attempt to update OR it had artifacts or remnants from prior updates or something. Basically it wasn’t a completely pure pre-update-attempt version of the DB.

I would advise anyone having problems with updating (and I have noticed a lot of them in these forums) to be super-anal about backing up entire site and DB prior to any modifications or upgrade attempts. If it’s too late for such precautions, I would recommend forging ahead even if it requires the tedious commenting of lines from the update files as mentioned above.

Thanks and good luck!

PS Also, I understand that perhaps EE is more complicated than WP but wow if EE had the same kind of simple one-click upgrade functionality, I would be 100% sold for life.

Hey jarintabata,

Thank you for letting us know!

If you need anything else, please just let us know by opening a new thread.

Cheers,