what version of web2py are you using? on what url are you getting the error?
On Tue, Jul 21, 2009 at 19:26, hcvst<[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
