Cannot save thrshold-templates after upgrade to thold 0.4.9

[thorsson]

Hi all,
after upgrading cacti to 0.8.8a and thold from version 0.4.1 to 0.4.9 I cannot change any value in threshold-template.

After changing of any value or adding new value (f.e. warnings) and final pressing SAVE the value is reset to old and error message "Error:Save Failed" appears.
I can do it on an excisting template or new one - the result is the same.

Is it a bug or did I something wrong with updating thold?
I just copied the new thold in ../cacti/plugins/thold directory.

Can anybody give an advice?
Nice weekend

Jörg

[artagel]

What version of php are you running?
I remember I had this problem with Php 5.4, and I had to take define_syslog_variables(); out of some of the thold php files.
http://php.net/manual/en/function.defin ... iables.php
-Dan

[thorsson]

Good Morning,
it's PHP Version => 5.2.6

[thorsson]

Commenting out the "define_syslog_variables();" in thold php-files didn't fix the problem.

[artagel]

I wouldn't expect since your version is not 5.4.
Can you check your log for any SQL failures?
-Dan

[thorsson]

Yes, the is one (many times)

10/01/2012 12:45:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT thold_data.id, thold_data.name AS thold_name, thold_data.graph_id, thold_data.percent_ds, thold_data.expression, thold_data.data_type, thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, UNIX_TIMESTAMP(thold_data.lasttime) AS lasttime, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id, data_template_data.rrd_step, data_template_rrd.rrd_maximum FROM thold_data LEFT JOIN data_template_rrd ON (data_template_rrd.id = thold_data.data_id) LEFT JOIN data_template_data ON ( data_template_data.local_data_id = thold_data.rra_id ) WHERE data_template_rrd.data_source_name!='' AND thold_data.rra_id IN(272)"

Thank you for your help so far

[artagel]

Looks like your thold tables aren't properly created. Try running the db repair cli tool in the cli subdir. If that doesn't fix it remove and reinstall thold in plugins management area.

[thorsson]

Thank you very much.
Uninstall thold and reinstall fixes the problem but I have to renew all thresholds and templates. OK - sh... happens
Kind regards

Joerg