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.

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"

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