I think Opensips lexer is converting your 'yes' to the integer 1 when running the SQL query in your DB. See this thread: http://lists.opensips.org/pipermail/users/2015-February/030946.html
Try to use something different from 'yes' to see what happens. Patrick On Tue, Nov 3, 2015 at 3:50 PM, Rodrigo Pimenta Carvalho <[email protected]> wrote: > Hi Aron. > > > Do you know whether it is necessary to commit the modifications made by > avp_db_query("Update....") ? > > Is there some kind of ' commit' command to be executed in the OpenSIPS > script? > > > Any hint will be very helpful! > > > Thanks a lot. > > > RODRIGO PIMENTA CARVALHO > Inatel Competence Center > Software > Ph: +55 35 3471 9200 RAMAL 979 > > > ------------------------------ > *De:* [email protected] <[email protected]> > em nome de Podrigal, Aron <[email protected]> > *Enviado:* terça-feira, 3 de novembro de 2015 15:26 > *Para:* OpenSIPS users mailling list > *Assunto:* Re: [OpenSIPS-Users] Can I use 'UPDATE' in avp_db_query ? > > Try removing the second argument *"$avp(CallMaxDuration)"* from > avp_db_query() Because the database backend does not return any results. > > On Tue, Nov 3, 2015 at 8:50 AM, Rodrigo Pimenta Carvalho < > [email protected]> wrote: > >> Dear OpenSIPS-users, >> >> >> In the OpenSIPS database I have created some new tables, for my project. >> I can read from such tables successfully. For example, the instruction >> >> >> *avp_db_query("select Value from GeneralConfigurations where Attribute >> = 'CallMaxDuration'", "$avp(CallMaxDuration)");* >> >> >> run and works very well. It put the right value in the apv! >> >> >> However, when the following instruction is executed, it doesn't take any >> effect in the database: >> >> >> * avp_db_query("update GeneralConfigurations set Value = 'yes' where >> Attribute = 'Exists_Intercom_Call'", "$avp(UpdateResult)");* >> >> >> The log says: >> >> >> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- >> >> >> Nov 3 11:32:52 [29114] DBG:avpops:ops_dbquery_avps: query [update >> GeneralConfigurations set Value = 'yes' where Attribute = >> 'Exists_Intercom_Call'] >> Nov 3 11:32:52 [29114] DBG:avpops:db_query_avp: no result after query >> Nov 3 11:32:52 [29114] DBG:avpops:db_close_query: close avp query >> Nov 3 11:32:52 [29114] ERROR:db_sqlite:db_sqlite_free_result: invalid >> parameter value >> >> >> >> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ >> >> >> But the query UPDATE is correct, because I have already tested it >> directly in the database. >> >> >> So, am I doing something wrong? What exactly does mean that error >> "invalid parameter value" in this case? Can I use UPDATE in an avp_db_query? >> >> >> Any hint will be very helpful! >> >> >> Best regards. >> >> >> >> >> >> >> >> >> RODRIGO PIMENTA CARVALHO >> Inatel Competence Center >> Software >> Ph: +55 35 3471 9200 RAMAL 979 >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > > -- > Aron Podrigal > - > '1000001', '1110010', '1101111', '1101110' '1010000', '1101111', > '1100100', '1110010', '1101001', '1100111', '1100001', '1101100' > > P: '2b', '31', '33', '34', '37', '34', '35', '38', '36', '30', '39', '39' > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
