QA: Problem with non-templated tholds

[xmacan]

Thold 1.8 - it seems that non-templated tholds doesn't work. These tholds should be restored:

From normal -> triggered-> breached is the same problem:

Templated tholds works fine.

[xmacan]

without thold daemon

[TheWitness]

I did not see your sentence about the non-templated not clearing their state. Any errors in the log?

[TheWitness]

You will have to re-upgrade your database. I've added another column to the notification_queue table and ran a sql query to fix the non-templated tholds.

[xmacan]

Still not working

[xmacan]

It seems that problem is in include/polling.php in thold_check_all_thresholds() function. My problematic thold:

select thold_enabled, thold_per_enabled, template_enabled,tcheck, thold_template_id from thold_data where id=11886; +---------------+-------------------+------------------+--------+-------------------+-----------------------+ | thold_enabled | thold_per_enabled | template_enabled | tcheck | thold_template_id | +---------------+-------------------+------------------+--------+-------------------+-----------------------+ | on | on | off | 0 | 2 | +---------------+-------------------+------------------+--------+-------------------+-----------------------+

ID 11886 will never been processed because SQL condition for tholds is: WHERE td.thold_enabled = 'on' AND td.thold_per_enabled = 'on' AND ((thold_template_id > 0 AND td.template_enabled = 'on') OR thold_template_id = 0) AND td.tcheck = 1 AND h.status = 3

My non-templated thold are created from templated, only disable Template Propagation Enabled and change hi/lo values.

I don't know how right sql for non-templated thold looks like. @TheWitness Could you help me?

[xmacan]

works great.