Hi,
I have this problem: a table have a field that is a reference to id of
auth_users.
BEFORE it was:
db.define_table('courses',
Field('id_user',db.users),
...
NOW is:
db.define_table('courses',
Field('id_user',db.auth_user),
...
Now the table 'users' is n more used.
The problem is that if I insert new courses record the app faults with this
error:
<class 'gluon.contrib.pymysql.err.IntegrityError'> (1452, u'Cannot add or
update a child row: a foreign key constraint fails (`course`.`courses`,
CONSTRAINT `courses_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `users`
(`id`) ON DELETE CASCADE)')
In query is present 'users' table that is no more used nowhere (I searched
it in all project file!). If the user is present in users table the record
in courses is created.
Auth_user have extra field:
auth.settings.extra_fields['auth_user']= [
Field('address'),
Field('city'),
...
I read all post about migrate, fake_migrate, etc, but for me there is a
problem with migration. For example if I delete a table that is declared in
db.py, it is NOT recreated (i tried all combination in the world of
migrate, fake_migrate, etc!!!).
It could be a mysql permission/users/other problem?
Thanks.
Fabio
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
