Page 1 of 1
Error adding config access
Posted: Wed Apr 17, 2013 9:04 am
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'
Re: Error adding config access
Posted: Wed Apr 17, 2013 9:59 am
by scottwilkerson
What version of XI are you running?
Re: Error adding config access
Posted: Wed Apr 17, 2013 10:02 am
by BanditBBS
scottwilkerson wrote:What version of XI are you running?
Latest, 2012 1.7
Re: Error adding config access
Posted: Wed Apr 17, 2013 10:25 am
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.
Re: Error adding config access
Posted: Wed Apr 17, 2013 10:53 am
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.
Re: Error adding config access
Posted: Wed Apr 17, 2013 11:15 am
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.