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" <bog...@voice-system.ro >> <mailto:bog...@voice-system.ro>> 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: >> > I have a scenario where I execute a trigger in mysql when info is >> > added to the a... >> >> > ------------------------------------------------------------------------ >> > >> > _______________________________________________ >> > Users mailing list >> > Users@lists.opensips.org <mailto:Users@lists.opensips.org> >> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > >> >> >> -- >> Bogdan-Andrei Iancu >> www.voice-system.ro <http://www.voice-system.ro> >> >> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org <mailto:Users@lists.opensips.org> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Balashov - Principal Evariste Systems LLC Tel : +1 678-954-0670 Direct : +1 678-954-0671 Web : http://www.evaristesys.com/ _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users