i am using asterisk1.2.1 realtime mysql4.1.x
i found same update error in debug mode
i cat /var/log/asterisk/debug follow:
Dec 13 00:12:28 DEBUG[7533] db.c: Unable to find key '99015' in family 'SIP/Registry'Dec 13 00:12:28 DEBUG[7533] res_config_mysql.c: MySQL RealTime: Update SQL: UPDATE sip_user SET ipaddr = '', port = 'Ð'ê·¬'ê·qœ¥', regseconds = '0', username = '99015' WHERE name = '99015'
Dec 13 00:12:28 DEBUG[7533] res_config_mysql.c: MySQL RealTime: Query: UPDATE sip_user SET ipaddr = '', port = 'Ð'ê·¬'ê·qœ¥', regseconds = '0', username = '99015' WHERE name = '99015'
Dec 13 00:12:28 DEBUG[7533] res_config_mysql.c: MySQL RealTime: Query Failed because: 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 'ê·¬'ê·qœ¥', regseconds = '0', username = '99015' WHERE name = '99015'' at line 1
Dec 13 00:12:28 DEBUG[7529] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_user WHERE name = '99015'
Dec 13 00:12:28 DEBUG[7529] db.c: Unable to find key '99015' in family 'SIP/Registry'
this UPDATE statements often get error messages.
are those bug???
how are influence on my services?
thanks
hoowa sun
_______________________________________________ --Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
