Hi -
I created a custom auth_user table with a new field ('company') and am
having trouble accessing it in my controller:
db.py
db.define_table(
auth.settings.table_user_name,
Field('first_name', length=128, default=''),
Field('last_name', length=128, default=''),
Field('email', length=128, default='', unique=True,
label='Company Email'),
Field('password', 'password', length=512, readable=False),
Field('company', length=128, label='Company Name'),
Field('registration_key', length=512, default='',
writable=False, readable=False),
Field('reset_password_key', length=512, default='',
writable=False, readable=False),
Field('first_name', length=128, default=''),
Field('registration_id', length=512, writable=False,
readable=False, default=''), format='%(first_name)s %(last_name)s',
)
default.py
db.tokens.insert(token = token,
first_name = request.post_vars.first,
last_name = request.post_vars.last,
email = request.post_vars.email,
company = db.auth_user.company)
Produces an error:
Traceback (most recent call last):
File "/media/sf_VBoxWeb2py/web2py/gluon/restricted.py", line 227, in
restricted
exec ccode in environment
File
"/media/sf_VBoxWeb2py/web2py/applications/nolabills/controllers/default.py"
<https://192.168.56.101:8000/admin/default/edit/nolabills/controllers/default.py>,
line 239, in <module>
File "/media/sf_VBoxWeb2py/web2py/gluon/globals.py", line 417, in <lambda>
self._caller = lambda f: f()
File "/media/sf_VBoxWeb2py/web2py/gluon/tools.py", line 4250, in f
return action(*a, **b)
File
"/media/sf_VBoxWeb2py/web2py/applications/nolabills/controllers/default.py"
<https://192.168.56.101:8000/admin/default/edit/nolabills/controllers/default.py>,
line 119, in dashboard
company = db.auth_user.company)
File "/media/sf_VBoxWeb2py/web2py/gluon/packages/dal/pydal/objects.py", line
726, in insert
ret = self._db._adapter.insert(self, self._listify(fields))
File "/media/sf_VBoxWeb2py/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 746, in insert
raise e
OperationalError: no such column: auth_user.company
I'm new to web2py and struggling to understand how to remedy it. I gather
it's something to do with migrations, but simply setting migrate = True in
define_table is not solving the issue.
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
