Syntax Error For Realtime SQLite3

Home » Asterisk Users » Syntax Error For Realtime SQLite3
Asterisk Users 1 Comment

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?

One thought on - Syntax Error For Realtime SQLite3

  • Il 18/02/2014 19.15, Carlos Chavez ha scritto:

    […]

    Seems that fails to build a proper query if the fullcontact field is null. Looks like a bug but you can try a possible workaround: set the full name for peers.