SQL query error ...

[mohierf]

... catched in the brokerd.log file:

[1448554607] WARNING: [broker-master] [MysqlDB] A query raised a programming error: UPDATE glpi_plugin_monitoring_shinkenstates set is_ack='1' , last_check='2015-11-26 17:16:43' , state_type='HARD' , state='2' , last_perfdata='''C:\ used''=374.77849GB;322.10546;362.36864;0;402.63183 ''C:\ used %''=93%;79;89;0;100 ''E:\ used''=0.01332GB;1.58984;1.78857;0;1.9873 ''E:\ used %''=0%;80;90;0;100 ''F:\ used''=0.10888GB;23.43749;26.36718;0;29.29687 ''F:\ used %''=0%;79;89;0;100 ''G:\ used''=18.46135GB;17.4164;19.59345;0;21.7705 ''G:\ used %''=84%;79;89;0;100 ''L:\ used''=0B;0;0;0;0 ''O:\ used''=1.48173TB;1.45545;1.63738;0;1.81932 ''O:\ used %''=81%;80;90;0;100 ''\\?\' , last_output='CRITICAL C:\: 374.778GB/402.632GB used, G:\: 18.461GB/21.771GB used, O:\: 1.482TB/1.819TB used'  WHERE hostname='pc-fred' and service='nsca_disk' , (1064, "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 'CRITICAL C:\\: 374.778GB/402.632GB used, G:\\: 18.461GB/21.771GB used, O:\\: 1.482T' at line 1")
[1448554607] WARNING: [broker-master] [MysqlDB] A query raised a programming error: INSERT INTO glpi_plugin_monitoring_serviceevents  (latency , execution_time , plugin_monitoring_services_id , perf_data , state_type , state , date , event  ) VALUES ('0' , '0' , '36513' , '''C:\ used''=374.77849GB;322.10546;362.36864;0;402.63183 ''C:\ used %''=93%;79;89;0;100 ''E:\ used''=0.01332GB;1.58984;1.78857;0;1.9873 ''E:\ used %''=0%;80;90;0;100 ''F:\ used''=0.10888GB;23.43749;26.36718;0;29.29687 ''F:\ used %''=0%;79;89;0;100 ''G:\ used''=18.46135GB;17.4164;19.59345;0;21.7705 ''G:\ used %''=84%;79;89;0;100 ''L:\ used''=0B;0;0;0;0 ''O:\ used''=1.48173TB;1.45545;1.63738;0;1.81932 ''O:\ used %''=81%;80;90;0;100 ''\\?\' , 'HARD' , 'CRITICAL' , '2015-11-26 17:16:43' , 'CRITICAL C:\: 374.778GB/402.632GB used, G:\: 18.461GB/21.771GB used, O:\: 1.482TB/1.819TB used'  ), (1064, "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 'HARD' , 'CRITICAL' , '2015-11-26 17:16:43' , 'CRITICAL C:\\: 374.778GB/402.632GB ' at line 1")

Probably, we need to escape the check output field ... :/P