Re: [OpenSIPS-Users] Migrating form 1.11.5 to 1.11.9

2016-11-09 Thread Alain Bieuzent
s.opensips.org> Objet : Re: [OpenSIPS-Users] Migrating form 1.11.5 to 1.11.9 Hi, Alain! Somewhere between 1.11.5 and 1.11.9 we figured out a problem related to mysql queries: if your database entry is NULL, we can't just simply set a NULL value to an AVP, because that just deletes the previ

Re: [OpenSIPS-Users] Migrating form 1.11.5 to 1.11.9

2016-11-09 Thread Răzvan Crainea
Hi, Alain! Somewhere between 1.11.5 and 1.11.9 we figured out a problem related to mysql queries: if your database entry is NULL, we can't just simply set a NULL value to an AVP, because that just deletes the previous value. So you end up in a very inconsistent state. That's why we decided to

Re: [OpenSIPS-Users] Migrating form 1.11.5 to 1.11.9

2016-11-09 Thread Bogdan-Andrei Iancu
Hi Alain, yes, it was a fix in avp_db_query() - if you query for multiple columns in a row, and if one of these columns returns NULL, it will not be reported as empty AVP , but as an AVP holding "" value : https://github.com/OpenSIPS/opensips/commit/e1257269bcc30df56dd9b6bc90a243c5839d5922

[OpenSIPS-Users] Migrating form 1.11.5 to 1.11.9

2016-11-09 Thread Alain Bieuzent
Hi All, I’m trying to migrate form 1.11.5 to 1.11.9 and i have a problem to test the value of a mysql query when the reseult is null. In 1.11.5 this test « if (!$avp(redirect) == NULL) » works, but doesn’t work in 1.11.9. Is there a change in code ? What is the corect way to test a