Ok Aronp.
Thank you very much. I will try this solution, test and tell you about the result. By the way, It will be my first time applying a patch. So let me ask you: Have I to download your fixed source code, or have i to download some binary file? After getting the file, I will apply the patch following a kind of tutorial about it. Best regards. 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 16:32 Para: OpenSIPS users mailling list Assunto: Re: [OpenSIPS-Users] Can I use 'UPDATE' in avp_db_query ? Woop, I missed the link. Try applying this patch [1]. I also created a pull request [2] for this, However, I did not test this in any way. Please report back how that worked. [1] https://github.com/ar45/opensips/commit/62c638fb2d5bf795775908cf0f45be6c30df5044 [2] https://github.com/OpenSIPS/opensips/pull/689 On Tue, Nov 3, 2015 at 1:31 PM, Podrigal, Aron <[email protected]<mailto:[email protected]>> wrote: 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]<mailto:[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]<mailto:[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]<mailto:[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<tel:%2B55%2035%203471%209200> RAMAL 979 ________________________________ De: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> em nome de Podrigal, Aron <[email protected]<mailto:[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]<mailto:[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<tel:%2B55%2035%203471%209200> RAMAL 979 _______________________________________________ Users mailing list [email protected]<mailto:[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]<mailto:[email protected]> http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected]<mailto:[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' -- 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
