[Asterisk-Users] asterisk 1.2.1 realtime mysql.4.1.xx report errors

hoowa sun hoowa.sun at gmail.com
Sat Dec 17 06:41:43 MST 2005


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


More information about the asterisk-users mailing list