Unable to add a new device, facing the "Error:Saved Failed"

[skywing88]

At the beginning, I used cacti with mysql 5.6 installed. Everythings functioned properly till that I wanted to add a notificaiton list. I got the "Error:Saved Failed" after I clicked "save" button so that I couldnt' add a notification.

Later, I uninstalled the mysql5.6 and try the mysql5.1,hoping that can help to resolve this issue.

However, after that, the first problem seemed to have been issued. I can successfully add a new notification list. A new problem occurred, It returned the same Error when I am going to add a new device.

Having spent serveral days looking into the resolution, I will appreciate very much if any master here can help!

Thanks!!!

[msalvatori]

Seems like you have to run the database_upgrade.php script.

Found the answer here: http://forums.cacti.net/about18916.html

[imofeng]

i have the same problem not long ago. it seems as if the newest MYSQL's sql_mode didn't allow the form of '0000-00-00 00:00:00' to insert into database. You just change the sql_mode, it will be well.

[skywing88]

Thanks for ur replies,friends. But I can't find the database_upgrade.php in the directory "/var/www/html/cacti", and I have checked the cacti.log,but it's empty. Plus, the Os is RHEL6.5, not windows.

Oh, imofeng, thank u. I got the message"You are running MySQL in Strict Mode, which is not supported by Thold" when clicking the "thold" tab.
So according to ur advice, I changed the "Mode" using "set @@GLOBAL.sql_mode='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'" command. Looks like it worked this time.