Zen Cart out-of-the-box does not use any foreign key constraints.
You'll have to undo whatever you've done to add foreign key constraints if you want to proceed with whatever you're trying to do that shows that error.