Error adding config access

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Error adding config access

Post by BanditBBS »

Trying to add someone to core config manager and getting an error:

Code: Select all

Error while inserting data into the database:
Unknown column 'locale' in 'field list' 
When trying to copy an existing I get this:

Code: Select all

Error while inserting the data to the database:
Unknown column '' in 'field list' 
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Error adding config access

Post by scottwilkerson »

What version of XI are you running?
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: Error adding config access

Post by BanditBBS »

scottwilkerson wrote:What version of XI are you running?
Latest, 2012 1.7
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Error adding config access

Post by lmiltchev »

Run the following commands:

Code: Select all

mysql -pnagiosxi nagiosql
ALTER TABLE tbl_user ADD COLUMN locale VARCHAR(6) DEFAULT 'en_EN';
\q
Hope this helps.
Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: Error adding config access

Post by BanditBBS »

lmiltchev wrote:Run the following commands:

Code: Select all

mysql -pnagiosxi nagiosql
ALTER TABLE tbl_user ADD COLUMN locale VARCHAR(6) DEFAULT 'en_EN';
\q
Hope this helps.
I can now add a new one, but can not copy and existing one. That is no big deal, just wanted to make sure the issue was known.
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Error adding config access

Post by abrist »

This was a change applied by our upgrade script. Maybe your version was previously detected incorrectly during an upgrade and the column was not created. Thanks for the heads up.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Locked