Try applying this patch [1]. I also created a pull request for this, However, I did not test this in any way. Please report back how that worked.
On Tue, Nov 3, 2015 at 1:11 PM, Podrigal, Aron <[email protected]> wrote: > Here [1] is where your issue is. That it simply executes the query but > returns no results. I guess we need to have some conditional to run the > update function for update statements instead. > > [1] > https://github.com/OpenSIPS/opensips/blob/98dccc53f4c25da6edf756333ef45a93bc2f41c7/modules/db_sqlite/dbase.c#L336 > > > On Tue, Nov 3, 2015 at 1:03 PM, Patrick Wakano <[email protected]> wrote: > >> 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 >> >> > > > -- > 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' > > -- 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
