删除触发器后的MySQL select语句结果始终为null

I'm having a little issue with a trigger in a MySQL database. I have a DB with two tables: "tasks" and "files". The "tasks" table have a field which is a foreign key of the primary key from the "files" table. It also sometimes may be null.I'm having a little issue with a trigger in a M