[SR-Users] Sqlops

[Fred Posner]

Are you putting the value in single quotes?

-- Fred
direct/sms +1 (336) 439-3733


> On Aug 7, 2019, at 07:47, arish haque <arish.haq at gmail.com> wrote:
> 
> 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
> 
> 
> 
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users