mysql-error-1025

What does mysql error 1025 (HY000): Error on rename of './foo' (errorno: 150) mean?

I tried this in mysql: mysql> alter table region drop column country_id; And got this: ERROR 1025 (HY000): Error on rename of './product/#sql-14ae_81' to './product/region' (errno: 150) Any ideas? Foreign key stuff? ...

MySQL - Unable to create column

I am using MySQL 5.1. When i am trying to add new field, it throws error like this, Database name is "ebill". Error Code : 1025 Error on rename of '.\ebill\#sql-98_477' to '.\ebill\user' (errno: 150) (0 ms taken) This is my sql query: alter table `ebill`.`user` add column `User_Password` varchar(25) NULL Where is the issue? ...

Weird mysql error

Hello I have a mysql database with in it an addresses table. This is the way it's created: CREATE TABLE IF NOT EXISTS `addresses` ( `adr_id` int(11) NOT NULL AUTO_INCREMENT, `per_id` int(11) NOT NULL, `adr_street` varchar(50) NOT NULL, `adr_houseno` int(11) DEFAULT NULL, `adr_housenoadd` varchar(10) DEFAULT NULL, `adr_postc...

Renaming foreign-key columns in MySQL

We're trying to rename a column in MySQL (5.1.31, InnoDB) that is a foreign key to another table. At first, we tried to use Django-South, but came up against a known issue: http://south.aeracode.org/ticket/243 OperationalError: (1025, "Error on rename of './xxx/#sql-bf_4d' to './xxx/cave_event' (errno: 150)") AND Error on ren...

mysql rename table column name

How to rename the table field in table xyz, Fields are manufacurerid,name,status AI,PK,int Want to rename to manufacturerid , I tried using phpmyadmin panel , its not working, show error, MySQL said: Documentation #1025 - Error on rename of '.\shopping\#sql-c98_26' to '.\shopping\tblmanufacturer' (errno: 150) ...