Re: Error while altering a table

2003-09-12 Thread Paul DuBois
At 1:04 PM -0400 9/12/03, [EMAIL PROTECTED] wrote: ...just a shot in the dark, but isn't 'description' a reserved word? If so, um, maybe a bug/inconsistency between table types. If not, ramble on. DESC and DESCRIBE are reserved, but DESCRIPTION is not... -- Paul DuBois, Senior Technical Writer

Re: Error while altering a table

2003-09-12 Thread Tbird67ForSale
...just a shot in the dark, but isn't 'description' a reserved word? If so, um, maybe a bug/inconsistency between table types. If not, ramble on. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error while altering a table

2003-09-12 Thread Heikki Tuuri
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&#x

Error while altering a table

2003-09-12 Thread Irwin Boutboul
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 rev