Page 1 of 1
Upgrade to 1.4 not working
Posted: Thu Jan 17, 2013 11:05 am
by BanditBBS
Trying to upgrade to 1.4 and receiving this:
Code: Select all
[clarkj@svphlnagios02 nagiosxi]$ sudo ./upgrade
OLD VERSION: 303
ERROR 1060 (42S21) at line 1: Duplicate column name 'locale'
Re: Upgrade to 1.4 not working
Posted: Thu Jan 17, 2013 11:35 am
by sreinhardt
It would seem that you are seeing a mysql error on line 371 if ./upgrade. Can you check if you currently have a locale column in the tbl_user table? If so, or if you have already ran the upgrade script once and it error-ed out, you may try commenting this line out.
Re: Upgrade to 1.4 not working
Posted: Thu Jan 17, 2013 11:47 am
by BanditBBS
sreinhardt wrote:It would seem that you are seeing a mysql error on line 371 if ./upgrade. Can you check if you currently have a locale column in the tbl_user table? If so, or if you have already ran the upgrade script once and it error-ed out, you may try commenting this line out.
Yes, there already is a locale field in that table. Any clue why it would be there if it is new to 1.4?
Re: Upgrade to 1.4 not working
Posted: Thu Jan 17, 2013 11:51 am
by BanditBBS
Nevermind. I know why. I ran ./upgrade and forgot to use sudo first. So it probably ran that line before it errored out with a permission issue.
Re: Upgrade to 1.4 not working
Posted: Thu Jan 17, 2013 11:55 am
by sreinhardt
It happens! Let me know if you run into any further issues!
Re: Upgrade to 1.4 not working
Posted: Thu Jan 17, 2013 11:57 am
by BanditBBS
Both servers upgraded fine
