I just finished migrating our web interface from Mysql to SQlite3
and everything seems to be working fine. I just have one detail. The
following keeps appearing on my logs:
[Apr 29 13:09:32] WARNING[30494]: res_config_sqlite3.c:520
realtime_sqlite3_execute_handle: Could not execute 'UPDATE
"sip_buddies"
SET "ipaddr" = '192.168.0.52', "port" =
'5060', "regseconds" =
'1398795032', "defaultuser" = '112',
"useragent" = 'Zoiper r21999',
"lastms WHERE "name" = '112'': near "112":
syntax error5060;rinst
[Apr 29 13:10:26] WARNING[30494]: res_config_sqlite3.c:520
realtime_sqlite3_execute_handle: Could not execute 'UPDATE
"sip_buddies"
SET "ipaddr" = '192.168.0.52', "port" =
'5060', "regseconds" =
'1398795086', "defaultuser" = '112',
"useragent" = 'Zoiper r21999',
"lastms WHERE "name" = '112'': near "112":
syntax error5060;rinst
I guess these are the realtime updates when an extension registers
with Asterisk. I really do not know why it is trying to update the
"defaultuser" field but the problem seems to be that the SQL code for
updating the table is has a syntax error. So far everything is working,
just keep getting this messages on the log file. Should I report this
as a bug?
We are using Asterisk 11.7.0 on CentOS 6
--
Telecomunicaciones Abiertas de M?xico S.A. de C.V.
Carlos Ch?vez
+52 (55)9116-91161
