Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Off topic - trigger not firing

BubikolRamios's profile image BubikolRamios posted 3 years ago in General Permalink

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's profile image BubikolRamios posted 3 years ago Permalink

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's profile image BubikolRamios posted 3 years ago Permalink

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.