XF 1.1 Cannot delete or update a parent row:

[seriosbrad]

I'm trying to change "xf_user" to MyISAM because my server does not run well when using InnoDB.

Anyways I get the error of

#1217 - Cannot delete or update a parent row: a foreign key constraint fails

When using

ALTER TABLE `xf_user` ENGINE = MYISAM

 

[Jake Bunce]

XF doesn't use foreign key constraints. Try removing any constraints you have added to that table.

http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html#id999979