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
