<div>i am using asterisk1.2.1 realtime mysql4.1.x</div>
<div> </div>
<div>i found same update error in debug mode</div>
<div> </div>
<div>i cat /var/log/asterisk/debug follow:</div>Dec 13 00:12:28 DEBUG[7533] db.c: Unable to find key '99015' in family 'SIP/Registry'<br>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'
<br>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'<br>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
<br>Dec 13 00:12:28 DEBUG[7529] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_user WHERE name = '99015'<br>Dec 13 00:12:28 DEBUG[7529] db.c: Unable to find key '99015' in family 'SIP/Registry'<br>
<div> </div>
<div>this UPDATE statements often get error messages.</div>
<div>are those bug???</div>
<div>how are influence on my services?</div>
<div> </div>
<div>thanks</div>
<div>hoowa sun</div>
<div> </div>
<div> </div>