From: Michael Stassen
Date: February 28 2005 3:45pm
Subject: Re: alter table return error
List-Archive: http://lists.mysql.com/mysql/180665
Message-Id: <42233CB3.4050407@verizon.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Did you try perror?

   ~: perror 150
   Error code 150:  Unknown error: 150
   150 = Foreign key constraint is incorrectly formed

Michael

Philippe Poelvoorde wrote:

> Hi,
> 
> I'm trying to add an 'unsigned' attribute to one column :
> 
>  > alter table markets modify Id integer unsigned not null auto_increment;
> ERROR 1025: Error on rename of './eurex_dax/#sql-1d2c_2f' to 
> './eurex_dax/markets' (errno: 150)
> 
> The query runs without any problems on any others tables (all are 
> innoDB), all permissions seems to be fine. I don't really know where to 
> look for hints, any ideas ?
>