SQL Failure when updating license key

[cwscribner]

Hi all.

Fresh install of Fusion on a barebones CentOS 6 server. I tried updating the license key but I get the following error:

Code: Select all

SQL: INSERT INTO fusion_options (name,value) VALUES ('license_key','my_license_key')	SQL Error [nagiosfusion] : ERROR: duplicate key value violates unique constraint "fusion_options_pkey"	SQL: INSERT INTO fusion_options (name,value) VALUES ('license_key','') SQL Error [nagiosfusion] : ERROR: duplicate key value violates unique constraint "fusion_options_pkey"

[cwscribner]

BUMP

[mguthrie]

There might be something goofy going on with the postgres sequences, XI has a similar error show up from time to time. I'll take a look at the XI fix and see if I can come up with something comparable for Fusion (if it's not already there).

[mguthrie]

Give this script a try and see if it takes care of the issue. Place it in your /usr/local/nagiosfusion/scripts directory and add executable permissions.

[cwscribner]

That fixed it. Thanks!

[mguthrie]

Awesome! I'll commit that script so it's available for future releases.