Hi community. I'm new to the web2py, but have a passion to learn it. I'm a little stuck when start to define my models, I use MySQL engine, and have following models:
db = DAL('mysql://login:password@localhost/mydb') > #db = DAL('sqlite://sqlite.sqlite') > db.define_table('aphorizm', > Field('body', 'text'), > Field('author_id', db.author), > Field('created_at'), > Field('tags'), > Field('like_count'), > Field('slug'), > Field('view_count')) > db.define_table('author', > Field('name'), > Field('slug'), > Field('created_at'), > Field('user_id')) but after successful saving I try the controller and have following ticket's details: Traceback (most recent call last): File "/var/www/web2py.catchword.mobi/gluon/restricted.py", line 194, in restricted exec ccode in environment File "/var/www/web2py.catchword.mobi/applications/catchword/models/db.py" <http://serv1.smetanin-online.name:8081/admin/default/edit/catchword/models/db.py>, line 8, in <module> Field('author_id', db.author), File "/var/www/web2py.catchword.mobi/gluon/dal.py", line 4511, in __getattr__ return self[key] File "/var/www/web2py.catchword.mobi/gluon/dal.py", line 4505, in __getitem__ return dict.__getitem__(self, str(key)) KeyError: 'author' so i can't figure out what's the problem in the relation between 'aphorizm' and 'author' models... I've defined the models according to the official reference. Please notice, when I change the engine from MySQL to SQLite all goes fine, without any errors..