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.

Reply via email to