mysql trigger stored trigger is already used by statement which invoked stored trigger
Solution 1:
MySQL triggers can't manipulate the table they are assigned to. All other major DBMS support this feature so hopefully MySQL will add this support soon.
http://forums.mysql.com/read.php?99,122354,240978#msg-240978