VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
| View previous topic :: View next topic |
| Author |
Message |
cursor at telecomabmex...
Guest
|
 Posted: Tue Feb 18, 2014 1:14 pm Post subject: [asterisk-users] Syntax error for Realtime SQLite3 |
 |
|
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
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users |
|
| Back to top |
|
 |
iax at keybits.org
Guest
|
| Posted: Tue Feb 18, 2014 1:47 pm Post subject: [asterisk-users] Syntax error for Realtime SQLite3 |
|
|
Il 18/02/2014 19.15, Carlos Chavez ha scritto:
| Quote: | 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:
|
[...]
| Quote: | [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++
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users |
|
| Back to top |
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
Search
