[OpenSIPS-Users] Can I use 'UPDATE' in avp_db_query ?

[Patrick Wakano]

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 <pimenta at inatel.br>
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:* users-bounces at lists.opensips.org <users-bounces at lists.opensips.org>
> em nome de Podrigal, Aron <aronp at guaranteedplus.com>
> *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 <
> pimenta at inatel.br> 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
>> Users at lists.opensips.org
>> 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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20151103/a69eb6db/attachment.htm>