Foreign Key's work on local machine but give contraint errors when moved to dreamhost



Hi all,

I have a symfony 1.4 script that works fine on my local machine.

I can create a category, and create items that belong in that category. I’ve set my schema.yml to CASCADE, so when a category is deleted it also deletes the items.

This only works on my local machine. Once I move everything into dreamhost, keeping the same setup, I get integrity constraint errors whenever I delete something that has child objects.

I’m not sure what’s up. Any ideas?