hoowa sun
2005-Dec-17 06:41 UTC
[Asterisk-Users] asterisk 1.2.1 realtime mysql.4.1.xx report errors
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051217/6b75461f/attachment.htm