MySQL: Cannot truncate a table referenced in a foreign key constraint …

fast trick:

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE tablename;
SET FOREIGN_KEY_CHECKS=1;

With these statements, you risk letting in rows into your tables that do not ad here to the foreign key constraints.