-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hmmm. I did some experiments - upgraded MySQL from 5.0.51 to 5.0.83-1
and also tried completely different machine as a database backend, with
functional 5.0.32. It occurs on all of them.
Then I tried to isolate the simpliest model code change, which leads to
OperationalError. It is being raised if I try to remove field2 from the
following code snippet:
db.define_table('ref2',
SQLField('name', 'string')
)
db.define_table('testing4',
SQLField('field', 'string'),
SQLField('field2', db.ref2, requires = \
IS_IN_DB(db, 'ref2.id', '%(name)s')),
)
On your machine it does not happen?
Thanks!
David
mdipierro napsal(a):
> I do not know. The error says:
>
> OperationalError: (1025, "Error on rename of './jfind/#sql-ac1_5e' to
> './jfind/person' (errno: 150)")
>
> This is a database error, not a web2py error, I do not know what "'./
> jfind/#sql-ac1_5e" is. web2py did not create it.
>
> I suggest remove the database and everthing in "databases/" then start
> again.
>
>
> On Jul 21, 6:42 am, David Zejda <[email protected]> wrote:
> The same error occurs, if I remove from the table model SQLField, which
> relates to an another table, like this:
>
> SQLField('name', db.permission_level, default=1, requires =
> IS_IN_DB(db, 'permission_level.id', '%(level)s - %(name)s'))
>
> I don't know - maybe there is no relation to MySQL and it's table
> engines. My project is under development, so it is not so painful to
> delete whole db and let the web2py to regenerate it, but in the full
> operation it would be bad..
>
> Thanks for ideas..
>
> David
>
> mdipierro napsal(a):
>
>>>> The DAL assumes InnoDB, not MYISAM. Perhaps that is the problem?
>>>> On Jul 20, 12:05 pm, David Zejda <[email protected]> wrote:
>>>> 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
iEYEARECAAYFAkpmDp8ACgkQ3oCkkciamVH/TACdEEXhFqGeBTg3VeJy+xr4/SDX
et4AnjRP/VQbjWFeCeCEshkyNSypoMHZ
=DIIL
-----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
-~----------~----~----~----~------~----~------~--~---
