I always get that with MySQL 4.1: alter table ACL_GROUPS add description varchar(255) default 'N/A'; ERROR 1025: Error on rename of './downloadgrid/#sql-1361_1a3' to './downloadgrid/ACL_GROUPS' (errno: 150)
If the table type is MyIsam, it works fine, I can alter the table. However I can not revert to innodb after. I don t really see why I can t add a column to a table... should not alter the foreign key constraints... show create table ACL_GROUPS; +------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ACL_GROUPS | CREATE TABLE `ACL_GROUPS` ( `groupid` char(30) character set latin1 NOT NULL default '', `creationtime` datetime default '0000-00-00 00:00:00', `active` smallint(6) default '1', `priority` smallint(6) default '1', PRIMARY KEY (`groupid`) ) TYPE=InnoDB | +------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) Irwin Boutboul Advanced Internet Technology 150 Kettletown Road, B2-N06 Southbury, CT 06488 Phone: 203-486-5614