[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