This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
February 02, 2012 11:02pm
Subscribe [2]#1 / Feb 02, 2012 11:02pm
Hello! I tried to update my version of EE from 2.3.1 to 2.4.0, and got the following message when I tried to perform the update:
————————-
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
————————-
What should I do to resolve this??
Thank you!
#2 / Feb 03, 2012 11:11am
Anyone know how to fix this?
#3 / Feb 04, 2012 5:23am
Hello ottercreate,
I am sorry to hear you are running into this problem.
Is this the first attempt to update?
Often times I see this error when an update has failed and a reattempt is being made. I am just curious if this is the case.
At this point, I recommend restoring the site to its pre-upgrade state using the backups you took before proceeding with the backup. Remember to drop all the tables in your database before restoring your DB backup. See this troubleshooting guide for more information on retrying failed upgrades.
When you re-run the upgrade, as soon as you come to an error, stop immediately and post that error message back here for review.
Regards,