Hi
I noticed that when I trie to modify a IT Services ( for example modify Status calculation algorithm ) I have got this error :
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 'status=0,algorithm=2,showsla=0,goodsla=99.05,sort order=99 where serviceid=10' at line 1
Query: update services set name='Test',triggerid=,status=0,algorithm=2,showsl a=0,goodsla=99.05,sortorder=99 where serviceid=10
Version used :
Linux : Red Hat Enterprise Linux ES release 4 (Nahant Update 1)
MySql : mysql-server-4.1.10a-2.RHEL4.1
Zabbix : ZABBIX 1.1beta2
Help please
Thanks
Bertrand
I noticed that when I trie to modify a IT Services ( for example modify Status calculation algorithm ) I have got this error :
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 'status=0,algorithm=2,showsla=0,goodsla=99.05,sort order=99 where serviceid=10' at line 1
Query: update services set name='Test',triggerid=,status=0,algorithm=2,showsl a=0,goodsla=99.05,sortorder=99 where serviceid=10
Version used :
Linux : Red Hat Enterprise Linux ES release 4 (Nahant Update 1)
MySql : mysql-server-4.1.10a-2.RHEL4.1
Zabbix : ZABBIX 1.1beta2
Help please
Thanks
Bertrand