Hey guys! I have added a extra field in auth_user named "account_type" now
I want that field to reference a table in the db called "account_type" and
display the contents of that field in the registration as a dropdown. Here
is what I did so far:
db = DAL('mysql://*******:********@localhost/lion')
from gluon.tools import Auth, Crud
db.define_table('account_type',
Field('type')
)
auth = Auth(db)
auth.settings.extra_fields['auth_user'] = [
Field('account_type', db.account_type)]
auth.define_tables(username=True)
db.auth_user.requires = IS_IN_DB(db, 'account_type.type')
It gives an error:
<class 'gluon.contrib.pymysql.err.InternalError'> (1005, u"Can't create
table 'lion.#sql-678_42' (errno: 150)")
I'm coming from a asp.net MVC and PHP background so this all is still quite
new to me.
Regards
Rujaun
--
