Added threshold but no enabled threshold in thold

[adjuan]

i have this problem when i want to add a new threshold, when i click Save. It appears Record updated, but it seems like not in the threshold database because when i check threshold, the threshold i just added is not there.

checked cacti log, found this error

CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1364', SQL:"INSERT INTO plugin_db_changes (plugin, `table`, method) VALUES ('thold', 'plugin_thold_log', 'create')'

anyone can help??

[cosmin]

I'm getting something like that also,

02/02/2010 09:36:28 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"UPDATE thold_data SET tcheck = 0'

And after i add a thresholt to a graph, it does not apear in the Threshold TAB.

[gdieudonne]

Any help would be much appreciated.

[zeki]

make sure you have settings plugin installed and added in includes/global.php
also go to admin user and enable plugin management
go to plugin management and install then enable thold plugin

[TheWitness]

MySQL error code 145 = Table was marked as crashed and should be repaired

You should run the repair_database.php script in the cli directory.

TheWitness

[gdieudonne]

I have only one 'error' left.
When I try to add a threshold, it says 'record updated' but still no threshold is created (the thold_data database is not filled in).

Again, I don't know how to debug it.
Could anyone help me with this?

[TheWitness]

Cacti log?

TheWitness

[gdieudonne]

I have only one 'error' left.
When I try to add a threshold, it says 'record updated' but still no threshold is created (the thold_data database is not filled in).

Again, I don't know how to debug it.
Could anyone help me with this?

OK,

I finally got it working.
I changed the MySQL Mode to MYSQL40.