Off topic - trigger not firing

BubikolRamios posted 3 years ago in General

http://shrani.si/f/1U/11W/24T9L4ON/tmp.jpg

So this is from two db-s with same table & trigger. Any explanation on difference ?

It appears at DB1 trigger before insert is not fired at all. At DB2 it is giving some warnings which are pointless since all that is filled on before insert trigger.

BubikolRamios posted 3 years ago

The trick is:

Set the SQL mode to strict

comented, coz strict blocks insert althought key field is filled on before insert trigger

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

BubikolRamios posted 3 years ago

I did not ment to shout that, text looked normal when editing, doh pasted from somewhere.

Please login to leave a reply, or register at first.