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 21, 2011 7:47pm
Subscribe [1]#1 / Feb 21, 2011 7:47pm
Hello. I’m trying to update a 1.x site from 1.6.8 to 1.7.0 and I get this error message when I run the update.php script:
MySQL ERROR:
Error Number: 1060
Description: Duplicate column name ‘username’
Query: ALTER TABLE `exp_password_lockout` ADD `username` VARCHAR(50) NOT NULL AFTER `user_agent`
What does this mean and how can I fix it?
Thanks.
#2 / Feb 21, 2011 9:02pm
Hi Bronze patriot: Sometimes on these upgrades there will be one table that will appear duplicated - some SQL DB corruption issues. The best thing to do is use the most recent 1.6.9 mysql db backup and try again. If that doesn’t work go into ee mysql administrative tools to repair the db. Hope you get it on the first retry. Chris
#3 / Feb 22, 2011 3:28pm
Do you have a pre-update db backup? I’d suggest to roll back, make sure the version number in config.php is correct, then try again. Let us know if there are any issues.