Bug #43118 Alter table engine=innodb returns error 1025 but there is no foreign keys.
Submitted: 23 Feb 2009 18:16 Modified: 24 Mar 2009 8:02
Reporter: Eugene Turkestanov Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.27 OS:Any
Assigned to: CPU Architecture:Any

[23 Feb 2009 18:16] Eugene Turkestanov
Description:
There is a table with MyISAM engien in the database. The rest of them are InnoDB. When I try to alter table to set innodb engine I get an error message:
Error Code : 1025
Error on rename of './tnuk118/#sql-77a7_4068' to './tnuk118/118MerchantAccount' (errno: 150)

I found that there was a foreign key in one table, so I've dropped it. But the error message still takes place. 

How to repeat:
No idea
[24 Feb 2009 8:02] Sveta Smirnova
Thank you for the report.

But version 5.0.27 is old. Please try with current version 5.0.77 and if problem still exists provide output of SHOW CREATE TABLE for table are you going to rename.
[25 Mar 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".