Deleting Foreign Keys

[Sean Bergam]

Hi. I am trying to delete a foreign key but I keep getting an error message like this:

#1025 - Error on rename of './db/mantis_user_table' to './db/#sql2-15715-1bc' (errno: 152)

I don't know why it thinks I am renaming any table. Does anyone know how to fix this?

Here is the SQL -

ALTER TABLE mantis_user_table DROP FOREIGN KEY mantis_user_table_ib

and it gives me that message. Any thoughts? I can't delete the table and I can't delete the fk. What do I do?