Yes, that should be easy to do. I will fix it in the next couple of
days.
On Jul 24, 5:23 am, David Zejda <[email protected]> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Massimo, would it be possible to let the DAL to drop foreign keys before
> dropping index or field itself if dealing with MySQL?
>
> David
>
> David Zejda napsal(a):
>
>
>
> > Yes, the problem is connected with dropping the index on interrelated
> > field. If I try to manually
>
> > DROP INDEX field2__idx ON testing4;
>
> > or
>
> > ALTER TABLE testing4 DROP field2;
>
> > i get the error too. I examined the problem more and the result is:
>
> > Field with a FOREIGN KEY can't stay without at least one index defined
> > on it. But if you remove the relation first:
>
> > ALTER TABLE testing4 DROP FOREIGN KEY testing4_ibfk_1;
>
> > Either the index or the whole field may be removed without error..
>
> > David
>
> > mdipierro napsal(a):
> >> 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
>
> -
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
> Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org
>
> iEYEARECAAYFAkppi4wACgkQ3oCkkciamVE2+ACgqN6dNMymHfg8csP3ZuDDbIKy
> KO8AoLfQ9xi6oXqNzLSbPpKIdWxS3t2J
> =rixq
> -----END PGP SIGNATURE-----
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
