When I try and do an update_record() I get an exception.
Is there something wrong with my table definition?
Can anyone help?
>From db.py:
auth.settings.table_user = db.define_table(
auth.settings.table_user_name,
db.Field('email', 'string', length=254, unique=True, notnull=True,
required=True, requires = [IS_LOWER(), IS_EMAIL(),
IS_NOT_IN_DB(db,'%s.email'%auth.settings.table_user_name)]),
db.Field('password', 'password', length=512, readable=False,
label='Password', requires = [CRYPT(key='***')]),
db.Field('registration_id', length=512, writable=False,
readable=False, default=''),
db.Field('registration_key', length=512, writable=False,
readable=False, default=''),
db.Field('first_name', 'string', length=128),
db.Field('last_name', 'string', length=128))
The rest is in default.py:
registerAgent(form)
def registerLinkedInAgent():
if auth.user.registration_key and
len(auth.user.registration_key):
# one-off calls
auth.add_membership(auth.id_group( 'agent'), auth.user.id)
# find current user's record and update registration key to an
empty string so this code isn't called again
users =
db(db.auth_user.id==auth.user.id).select(db.auth_user.ALL)
if users and len(users):
users[0].update_record({'registration_key''})
redirect(URL('account'))
The problem is I get "ValueError: need more than 1 value to unpack"
when I call update_record()
Full trackback is below:
Traceback (most recent call last):
File "E:\projects\workspace\TestEnvoy\web2py\gluon\restricted.py",
line 188, in restricted
exec ccode in environment
File "E:/projects/workspace/TestEnvoy/web2py/applications/init/
controllers/default.py", line 1528, in <module>
File "E:\projects\workspace\TestEnvoy\web2py\gluon\globals.py", line
96, in <lambda>
self._caller = lambda f: f()
File "E:/projects/workspace/TestEnvoy/web2py/applications/init/
controllers/default.py", line 1132, in registerLinkedInAgent
users[0].update_record({'registration_key' : ''})
File "E:\projects\workspace\TestEnvoy\web2py\gluon\sql.py", line
3381, in <lambda>
colset.update_record = lambda _ = (colset, table, id), **a:
update_record(_, a)
File "E:\projects\workspace\TestEnvoy\web2py\gluon\sql.py", line
3508, in update_record
(colset, table, id) = pack
ValueError: need more than 1 value to unpack
