-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello,
my db backend is MySQL 5.0.51a-24 on Linux.
If I try to gently alter already generated table schema, like to rename
SQLField('relation', 'text', requires = \
IS_NULL_OR(IS_IN_DB(db, 'relation_type.id', 'relation_type.id',
multiple=True)))
to
SQLField('relation_type', 'text', requires = \
IS_NULL_OR(IS_IN_DB(db, 'relation_type.id', 'relation_type.id',
multiple=True)))
i get this:
Traceback (most recent call last):
File "/home/zejdad/!a/jfind/web2py/gluon/restricted.py", line 98, in
restricted
exec ccode in environment
File "/home/zejdad/!a/jfind/web2py/applications/jfind/models/db.py",
line 346, in <module>
migrate="person"
File "/home/zejdad/!a/jfind/web2py/gluon/sql.py", line 938, in
define_table
raise e
OperationalError: (1025, "Error on rename of './jfind/#sql-ac1_5e' to
'./jfind/person' (errno: 150)")
Maybe, it is related to the troubles mentioned there:
http://forums.mysql.com/read.php?22,95361
Please, do you have any experiences with a such type of errors?
I would like to test it with MyISAM instead of InnoDB tables, but it is
not easy to change it in already generated and interrelated tables:
ALTER TABLE `person` ENGINE = MYISAM
#1217 - Cannot delete or update a parent row: a foreign key constraint
fails
Or should I try other MySQL version?
Thank you for advices!
David
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkpko+cACgkQ3oCkkciamVF3nACfdej9+FBUseSRBgMtJyBm0elR
wKUAnjx/qSTnNzG+Dr47AKmHm40PxJUK
=HqDy
-----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
-~----------~----~----~----~------~----~------~--~---
