Felix, I assume this is a MySQLCC bug.
Can you perform the ALTER TABLE from using the mysql interactive SQL client program? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: ""Félix Beltrán"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, December 16, 2003 7:31 PM Subject: Change the size of an InnoDB table field > I'm trying to change the size of an InnoDB table field from CHAR(20) > to CHAR(30) using MySQLCC, but i'm getting this error message > > ERROR 1091: Can't DROP '0_87'. Check that column/key exists > > This is the create query: > > CREATE TABLE `presentacion` ( > `cl_Presentacion` char(4) NOT NULL default '', > `cl_Embase` char(4) NOT NULL default '', > `cl_Tamano` char(4) NOT NULL default '', > `cl_Variedad` char(4) NOT NULL default '', > `de_Presentacion` char(20) default NULL, > PRIMARY KEY (`cl_Presentacion`), > KEY `presentacion_FKIndex1` (`cl_Variedad`), > KEY `presentacion_FKIndex2` (`cl_Tamano`), > KEY `presentacion_FKIndex3` (`cl_Embase`), > CONSTRAINT `0_85` FOREIGN KEY (`cl_Variedad`) REFERENCES `variedad` > (`cl_Variedad`), > CONSTRAINT `0_86` FOREIGN KEY (`cl_Tamano`) REFERENCES `tamano` > (`cl_Tamano`), > CONSTRAINT `0_87` FOREIGN KEY (`cl_Embase`) REFERENCES `embase` > (`cl_Embase`) > ) TYPE=InnoDB; > > Any clues about this?? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
