This problem occured after i deleted every single service inside NAGIOSQL Supervision. I was testing something and decided to start from scratch when i discovered that deleting all services apparently broke something. Now when i'm trying to create a new service inside NagiosQL i get the following error: "Error while inserting the data into the database
:Field 'import_hash' doesn't have a default value" I know this has something to do with the SQL query, but i have no idea what to do with this error, and sadly hours of google searching provided no answers for my case. Do i have to start over again, or is there any easy way to fix this error?
NAGIOSQL error when creating new service
-
Box293
- Too Basu
- Posts: 5126
- Joined: Sun Feb 07, 2010 10:55 pm
- Location: Deniliquin, Australia
- Contact:
Re: NAGIOSQL error when creating new service
It's probably easier to re-install Nagios QL, or at least re-create the database.
Perhaps run up another server and install NagiosQL on it and then backup the database and restore it on your original server.
Perhaps run up another server and install NagiosQL on it and then backup the database and restore it on your original server.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Re: NAGIOSQL error when creating new service
Whats the easiest way to recreate the database?
Re: NAGIOSQL error when creating new service
It's what @Box293 mentioned -nuggi wrote:Whats the easiest way to recreate the database?
This would preserve the structure of QL, and allow you to then dump it on the new server and import the SQL dump to your old server.Perhaps run up another server and install NagiosQL on it and then backup the database and restore it on your original server.
Former Nagios Employee