Re: [OpenSIPS-Users] issues with prepared statements in mysql

well, in this case, the mysql driver in opensips reports the truth :)... the only option here is to make your trigger more fault-resistant ;) Regards, Bogdan Alex G wrote: > > It fails completely. As a matter o fact... anything that doesn't > return "query OK" fails: :( > >> On Mar 3, 2010 12:

Re: [OpenSIPS-Users] issues with prepared statements in mysql

That's because it is a single transaction and is being rolled back, most likely. On 03/03/2010 01:23 PM, Alex G wrote: > It fails completely. As a matter o fact... anything that doesn't return > "query OK" fails: :( > >> On Mar 3, 2010 12:17 PM, "Bogdan-Andrei Iancu" >

Re: [OpenSIPS-Users] issues with prepared statements in mysql

It fails completely. As a matter o fact... anything that doesn't return "query OK" fails: :( On Mar 3, 2010 12:17 PM, "Bogdan-Andrei Iancu" wrote: Hi Alex, and the acc record is actually added (even with the trigger error) ? or the acc insert fails completely ? Regards, Bogdan Alex G wrote:

Re: [OpenSIPS-Users] issues with prepared statements in mysql

Hi Alex, and the acc record is actually added (even with the trigger error) ? or the acc insert fails completely ? Regards, Bogdan Alex G wrote: > I have a scenario where I execute a trigger in mysql when info is > added to the acc table. In some circumstances, my trigger results in a > dupli

[OpenSIPS-Users] issues with prepared statements in mysql

I have a scenario where I execute a trigger in mysql when info is added to the acc table. In some circumstances, my trigger results in a duplicate key when it tries to add info to another table. The prepared statement functionality reads this as an error, and fails to do the insert into the acc tab