MySQL #1025 Error -


I get this query # 1025 error.

SQL query: 

  Optional tab 'route' change 'end_lock' `and_LOC 'set VARCHAR (500) character utf8 COLLATE utf8_bin null   
 MySQL said:  
  # 1025 - Error in rename './ridestr/#sql-1f44_26eeb' './ridestr/routes' (errno: 150)   
 Which is strange because I'm setting up this query in PHP MyAdmin ?? I do not know why I'm getting a foreign key error ?? I'm just trying to change something from int   
 
 
 if  routes.end_loc  
  column is being used in a foreign key, then you can not change its data type. You have to change the data type of both the parent and the child leaving the foreign key, and then add the foreign key again.  
 For details of this error, see the  Show Engine Engine Status \ G  and then refer to  Latest Foreign Key Error  section.

Comments

Post a Comment