Hi,
when tying to use the integrated db admin the error below is raised.
Error traceback
Traceback (most recent call last):
File "/home/hcvst/dev/web2py/gluon/restricted.py", line 98, in
restricted
exec ccode in environment
File "/home/hcvst/dev/web2py/applications/openid/views/
appadmin.html", line 30, in <module>
<h2>Rows in table</h2><br/>
ValueError: too many values to unpack
It used to work, but as I did not use it for some time, I am not sure
what
code change might have caused this. The only other post I found here
talked of a possible cause being validators:
My custom auth table makes use of validators as shown below:
---
db.define_table('auth_user',
SQLField('nickname', label='Username', unique=True,
requires=[IS_NOT_EMPTY(), IS_NOT_IN_DB(db,
'auth_user.nickname', error_message='This name is already taken.'),
IS_MATCH(r'^[a-z0-9]+$',
error_message='Usernames have to be alphanumeric and lowercase')]),
SQLField('oid_name', readable=False, writable=False,
unique=True),
SQLField('first_name', required=True, length=128,
default='', requires=IS_NOT_EMPTY()),
SQLField('last_name', required=True, length=128,
default='', requires=IS_NOT_EMPTY()),
SQLField('email', length=128, default='', requires=
[IS_EMAIL(), IS_NOT_IN_DB(db, 'auth_user.email'), IS_NOT_EMPTY()]),
SQLField('password', 'password', default='',
readable=False, requires=[CRYPT(), IS_NOT_EMPTY()]),
SQLField('registration_key', length=128,
writable=False, readable=False, default=''),
SQLField('dob', 'date', label='Date of birth',
required=False, default='', requires=None, comment='optional ex:
1975-09-20'),
SQLField('postcode', comment='optional'),
SQLField('gender',requires=IS_IN_SET(['', 'M', 'F']),
comment='optional'),
SQLField('country', default=DEFAULT_COUNTRY,
requires=IS_IN_DB
(db,'oid_country_codes.code','oid_country_codes.country')),
SQLField('language', default=DEFAULT_LANG,
requires=IS_IN_DB
(db,'oid_lang_codes.code','oid_lang_codes.language')),
SQLField('timezone', default=DEFAULT_TIMEZONE,
requires=IS_IN_DB(db,'oid_timezones.timezone'))
)
What might be the reason for this error please?
Regards,
HC
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
