Irwin, do you have in my.cnf
default-character-set=... set to something else than latin1? Can you make a small test case which demonstrates the problem? Can you test with MySQL-4.0.15, and if the error happens also there, please post the output of SHOW INNODB STATUS after that unsuccessful ALTER TABLE? Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for MySQL Order MySQL support from http://www.mysql.com/support/index.html ....................... Subject: Error while altering a table From: Irwin Boutboul Date: Fri, 12 Sep 2003 11:41:29 -0400 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
