[SR-Users] Sqlops
arish haque
arish.haq at gmail.com
Wed Aug 7 14:47:43 CEST 2019
Hi all,
I am querying mysql db inside routing block in kamailio.cfg
ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on
query: Unknown column '8d77' in 'where clause' (1054)
Aug 7 18:09:22 localhost /usr/local/sbin/kamailio[25333]: ERROR: <core>
[db_query.c:181]: db_do_raw_query(): error while submitting query
Aug 7 18:09:22 localhost /usr/local/sbin/kamailio[25333]: ERROR: sqlops
[sql_api.c:265]: sql_do_query(): cannot do the query [select * from
vca_asterisk where front_id=8d77]
I'm getting the above error message when, variable front_id=8d77 is
alphanumeric.
It's working fine when front_id is pure numeric. eg: front_id=877
Database column front_id is VARCHAR(255).
Any suggestions to solve this error?
Thanks,
Arish
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190807/155e8d0a/attachment.html>
More information about the sr-users
mailing list