Upgrading fails Duplicate column name 'locale'

[Zystorm]

Hi
I'm trying to upadte my 2011 to the latest 2012 version
Latest Available Version: 2012R2.5
Installed Version: 2011R3.3

Upgrading stops with ;

Stopping nagios : done
Starting nagios : done
NagiosQL failed to update user table!
Duplicate column name 'locale'

Any hints to resolving this ?

Thanks

[BanditBBS]

http://support.nagios.com/forum/viewtop ... ale#p42497

Does that help at all?

[abrist]

Yep. I presume the column exists, correct? (its DEFAULT value should be 'EN_en') If it does, you can comment out lines #26-42 of the file:

Code: Select all

/tmp/nagiosxi/subcomponents/nagiosql/db_upgrades.php

The lines to comment out are:

Code: Select all

if(intval($oldversion) < 304) {
        if(db_connect_select($dba)) {
                $query = "ALTER TABLE tbl_user ADD COLUMN locale VARCHAR(6) DEFAULT 'en_EN'";
                if(!mysql_query($query)) {
                        echo "NagiosQL failed to update user table!\n".mysql_error()."\n";
                        exit(1);
                }
                else {
                        echo "NagiosQL user table updated successfully!\n";
                        exit(0);
                }
        }
        else {
                "Unable to connect to NagiosQL database!\n";
                exit(1);
        }
}

Let me be clear here. Only comment out these lines if the 'locale' column exists in the nagiosql database and it is populated with 'EN-en'.

[Zystorm]

Worked like a dream Thanks

[slansing]

Excellent, do you have any other questions on this?