1025 - Error on rename of database sql-2e0f 1254ba7 to database table errno 150

Question

So I am trying to add a primary key to one of the tables in my database  Right now it has a primary key like this   PRIMARY KEY  user id  round number    Where user id is a foreign key   I am trying to change it to this   PRIMARY KEY  user id  round number  created at    I am doing this in phpmyadmin by clicking on the primary key icon in the table structure view   This is the error I get    1025 - Error on rename of    database  sql-2e0f 1254ba7  to    database table   errno  150    It is a MySQL database with InnoDB table engine

User · Answer

I had this problem  it is for foreign-key  Click on the Relation View  like the image below  then find name of the field you are going to remove it  and under the Foreign key constraint  INNODB  column  just put the select to nothing  Means no foreign-key    Hope that works

User · Answer

For those who are getting to this question via google    this error can also happen if you try to rename a field that is acting as a foreign key

User · Answer

As was said you need to remove the FKs before  On Mysql do it like this   ALTER TABLE  table name  DROP FOREIGN KEY  id name fk    ALTER TABLE  table name  DROP INDEX  id name fk

User · Answer

To bypass this in PHPMyAdmin or with MySQL  first remove the foreign key constraint before renaming the attribute     For PHPMyAdmin users  To remove FK constrains in PHPMyAdmin  select the attribute then click  relation view  next to  print view  in the toolbar below the table structure

User · Answer

If you are trying to delete a column which is a FOREIGN KEY  you must find the correct name which is not the column name  Eg  If I am trying to delete the server field in the Alarms table which is a foreign key to the servers table    SHOW CREATE TABLE alarm  Look for the CONSTRAINT  server id refs id 34554433  FORIEGN KEY   server id   REFERENCES  server    id   line  ALTER TABLE  alarm  DROP FOREIGN KEY  server id refs id 34554433   ALTER TABLE  alarm  DROP  server id    This will delete the foreign key server from the Alarms table

User · Answer

If you are adding a foreign key and faced this error  it could be the value in the child table is not present in the parent table    Let s say for the column to which the foreign key has to be added has all values set to 0 and the value is not available in the table you are referencing it   You can set some value which is present in the parent table and then adding foreign key worked for me

User · Answer

There is probably another table with a foreign key referencing the primary key you are trying to change   To find out which table caused the error you can run SHOW ENGINE INNODB STATUS and then look at the LATEST FOREIGN KEY ERROR section

[mysql] #1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

Examples related to mysql

Examples related to sql

Examples related to phpmyadmin

Examples related to innodb

Examples related to mysql-error-1025