[web2py] Re: MySQL - OperationalError: Error on rename (errno: 150)

2014-07-07 Thread Massimo Di Pierro
No. web2py does not automatically delete indexes. You have to do it manually. Sorry. Please open a ticket about this. On Friday, 4 July 2014 17:44:53 UTC-5, José Antonio Salazar Montenegro wrote: > > I realize this is an ancient topic, but I'm having the very same error > migrating a MySQL tabl

[web2py] Re: MySQL - OperationalError: Error on rename (errno: 150)

2014-07-06 Thread José Antonio Salazar Montenegro
I realize this is an ancient topic, but I'm having the very same error migrating a MySQL table where I'm only removing a self reference field. It seems like an index was created to guard the (self) foreign-key constraint and DAL doesn't remove it when deleting the field. There are no manually-cr