[asterisk-users] Syntax error for Realtime SQLite3

giovanni.v iax at keybits.org
Tue Feb 18 12:50:35 CST 2014


Il 18/02/2014 19.15, Carlos Chavez ha scritto:
>      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 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

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.


-- 
TeeBX VoIP communication platform (coming soon)
http://code.google.com/p/teebx/
-----------------------------------------------
Lightweight++ Business Friendly++ Open++



More information about the asterisk-users mailing list