Action conditions: listing Discovery Checks gives SQL error

[joel_leonhardt]

Hi, Any suggestions for the following SQL error in Zabbix Appliance 1.9.8?

For a Discovery-event Action to be conditional on a Discovery Check, we need to click on a "Select" link (see image 1 below), and select a specific check from a list of available Discovery Checks (see image 2 for this list in 1.8.4). But instead of giving this list, the Select link now gives an SQL error message (see image 3). Note that we have already created several Discovery Checks, so this issue is not just a case of there being no Discover Checks to be listed.

Image 1:

Image 2:

Image 3:
• Error in query [SELECT DISTINCT r.name,c.dcheckid,c.type,c.key_,c.ports. FROM drules r,dchecks c WHERE r.druleid=c.druleid AND r.druleid BETWEEN 000000000000000 AND 099999999999999] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM drules r,dchecks c WHERE r.druleid=c.druleid AND r.druleid BETWEEN 00000000' at line 1]
• mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:572]
• mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:573]


Please let me know if this is a bug, or if I'm missing something.

Thanks,
Joel Leonhardt
MSVU

[joel_leonhardt]

fixed, but when available in appliance?

Oops, I just noticed that this issue was already reported (ZBX-4436 (closed) on 2011 Dec 13) and fixed (revision 23994 by Dec 15). Unfortunately, the 1.9.8 appliance was created before that (Dec 6).

Any chance of a 1.9.9 appliance?

Thx,
Joel

[richlv]

actually, 1.9.9 appliance was created, but i didn't have the time to even briefly test it.
now there seems to be a slight dataloss in the configuration somewhere, so i'll try to recover that and get the 1.9.9 appliance out