I have problems with Configuration->IT Services

[debora]

I need your help for this because i have monitoring many servers, where is the error look:

Error in query [select count(*) as cnt from services_links where servicedownid= and soft=0] [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 'and soft=0' at line 1]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/zabbix/public_html/include/db.inc.php on line 174
Error in query [select count(*) as cnt from services_links where servicedownid= and soft=0] [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 'and soft=0' at line 1]

[Trigger added]

SQL error: 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 'on,0,off,99)' at line 1
Query: insert into services (name,status,triggerid,algorithm,showsla,goodsla,s ortorder) values ('Version of zabbix_agent(d) was changed on {HOSTNAME}',0,12264,on,0,off,99)
SQL error: 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 '7,0)' at line 1
Query: insert into services_links (servicedownid,serviceupid,soft) values (,7,0)

[Alexei]

Please wait for 1.1.2. It is already fixed.

[debora]

But any thing by now? because i can't wait for release next version, i'm monitoring servers in production in a enterprise

[Alexei]

But any thing by now? because i can't wait for release next version, i'm monitoring servers in production in a enterprise

Use of open source software without purchasing a commercial support suggests that you can wait We plan to release 1.1.2 within two weeks.

[debora]

Thanks Alexei i waiting for this release next version

[elp]

IT - Services


Error: "Error in query [select count(*) as cnt from..."
Change include/services.inc.php line 58:
old line: $sql="select count(*) as cnt from services_links where servicedownid=$serviceid and soft=0";
correct line: $sql="select count(*) as cnt from services_links where servicedownid='$serviceid' and soft=0";

and

Error: "SQL error: You have an error in your SQL syntax..."
Change include/services.inc.php line 27
old line: " values (".zbx_dbstr($name).",0,$triggerid,$algorithm,$sho wsla,$goodsla,$sortorder)";
correct line: " values (".zbx_dbstr($name).",0,$triggerid,'$algorithm',$s howsla,'$goodsla',$sortorder)";


good luck

[debora]

Very Thanks now work fine