after upgrade to 1.2.16 we get sql error in the log from netxmsd

Started by edward.borst, August 18, 2014, 09:04:01 AM

Previous topic - Next topic

edward.borst

this is one of the errors:

[15-Aug-2014 18:50:41.373] [ERROR] SQL query failed (Query = "INSERT INTO snmp_trap_log (trap_id,trap_timestamp,ip_addr,object_id,trap_oid,trap_varlist) VALUES (17210,1408121441,'172.30.108.252',109,'.1.3.6.1.4.1.9.9.171.2.0.2','.1.3.6.1.4.1.9.9.171.1.2.2.1.6.1.4.188.204.63.138.1.4.87.197.107.139.473 == ''¼Ì?''; .1.3.6.1.4.1.9.9.171.1.2.2.1.7.1.4.188.204.63.138.1.4.87.197.107.139.473 == ''WÅk''; .1.3.6.1.4.1.9.9.171.1.2.3.1.16.473 == ''8640000''; .1.3.6.1.4.1.9.9.171.1.4.2.1.1.2.473 == ''3''')"): 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 ''.1.3.6.1.4.1.9.9.171.1.2.2.1.6.1.4.188.204.63.138.1.4.87.197.107.139.473 == ''' at line 1

another error is:

[15-Aug-2014 13:28:24.612] [ERROR] SQL query failed (Query = "UPDATE alarms SET alarm_state=0,ack_by=87686256,term_by=30541662,last_change_time=87686256,current_severity=0,repeat_count=0,hd_state         =0,hd_ref='`Ò',timeout=0,timeout_event=51,message='Ò',resolved_by=0, ack_timeout=0 WHERE alarm_id=49001504"): 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 ''`' at line 1