OK, I see we have a problem with removing fields that have an index associated to them. Can you try remove the index manually and then attempt the migration?
Massimo On Jul 21, 5:45 pm, Fran <[email protected]> wrote: > On Jul 21, 11:42 pm, Fran <[email protected]> wrote: > > > Confirmed. MySQL-5.1.36 with MySQL-python-1.2.2.win32 on Python-2.5.4 > > on Windows XP > > OperationalError: (1025, "Error on rename of '.\\db\\#sql-198_4' to '.\ > > \db\\testing4' (errno: 150)") > > sql.log doesn't show anything interesting: > timestamp: 2009-07-21T23:39:53.171000 > CREATE TABLE ref2( > id INT AUTO_INCREMENT NOT NULL, > name VARCHAR(32), > PRIMARY KEY(id) > ) ENGINE=InnoDB CHARACTER SET utf8; > success! > timestamp: 2009-07-21T23:39:53.750000 > CREATE TABLE testing4( > id INT AUTO_INCREMENT NOT NULL, > field VARCHAR(32), > field2 INT, INDEX field2__idx (field2), FOREIGN KEY (field2) > REFERENCES ref2(id) ON DELETE CASCADE, > PRIMARY KEY(id) > ) ENGINE=InnoDB CHARACTER SET utf8; > success! > timestamp: 2009-07-21T23:40:27.906000 > ALTER TABLE testing4 DROP COLUMN field2; > > F --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
