Re: alter table return error

[Michael Stassen]

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 ?
>