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