On Tuesday, February 16, 2016 at 3:51:47 PM UTC-8, Winter Kryz wrote: > > > > > I created a module Countries.py with all the country names, imported into > my model db.py and > > from applications.Egressum.modules. > countries import * > ... > Field ('countries', requires = IS_IN_SET(COUNTRIES), default='United > States'), > > then when I go to execute it, I get the following error > > <class '_mysql_exceptions.OperationalError'> (1025, "Error on rename of > './Kryz@0024db_egressum_we2py/#sql-3348_193e111' to > './Kryz@0024db_egressum_we2py/Person' (errno: 150)") > What am I doing wrong? > Thanks! > >
The 'rename' in the error message makes me think it is a migration error. In moving to the set usage, you've changed the table layout, and that requires a migration. But I'm not a MySql guru, and don't know the error numbers, so I'm just going by the text of the message. However, a quick google turns up <URL:http://stackoverflow.com/questions/160233/what-does-mysql-error-1025-hy000-error-on-rename-of-foo-errorno-150-me> which I hope you can make sense of. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.