[asterisk-users] Syntax error for Realtime SQLite3

Carlos Chavez cursor at telecomabmex.com
Tue Feb 18 12:15:30 CST 2014


     I am using Realtime on Asterisk 11.5 with a SQLite3 backend. While 
everything seems to be working fine I keep getting this error on my log 
files:

[2014-02-17 19:55:18] WARNING[20569] res_config_sqlite3.c: Could not 
execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.2.23', "port" = 
'5060', "regseconds" = '1392692118', "defaultuser" = '2012', "useragent" 
= 'Aastra 57i/3.2.2.2044', "lastms" = '-1', "fullcontact"  WHERE "name" 
= '2012'': near "2012": syntax error
[2014-02-17 19:55:30] WARNING[20569] res_config_sqlite3.c: Could not 
execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.2.215', "port" = 
'5060', "regseconds" = '1392692130', "defaultuser" = '4000', "useragent" 
= 'Aastra 55i/2.5.0.82', "lastms" = '-1', "fullcontact" = WHERE "name" = 
'4000'': near "4000": syntax error
[2014-02-17 20:55:03] WARNING[20569] res_config_sqlite3.c: Could not 
execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.2.23', "port" = 
'5060', "regseconds" = '1392695703', "defaultuser" = '2012', "useragent" 
= 'Aastra 57i/3.2.2.2044', "lastms" = '42', "fullcontact"  WHERE "name" 
= '2012'': near "2012": syntax error
[2014-02-17 20:55:15] WARNING[20569] res_config_sqlite3.c: Could not 
execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.2.215', "port" = 
'5060', "regseconds" = '1392695715', "defaultuser" = '4000', "useragent" 
= 'Aastra 55i/2.5.0.82', "lastms" = '42', "fullcontact" = WHERE "name" = 
'4000'': near "4000": syntax error

     The table has all relevant fields and I can insert/select/update 
information on my own.  I am guessing the syntax error may be in the 
code Asterisk uses to update the table when a phone registers.  Is there 
a fix coming?

-- 
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161




More information about the asterisk-users mailing list