Thanks. Yes, my appadmin seems to not have been compatible. I now created a dummy app under 1.65.5 removed everything I touched in my original app from it and copied it to my old app, overwriting all standard controllers, views etc.
Now it works, Thanks. On Jul 21, 9:25 pm, Yarko Tymciurak <[email protected]> wrote: > also, I remember something about admin app (if I recall) not updating with a > web2py update (since you could have modified it); > > You might try to make a clean web2py installation, and move your app to it - > see what results that yields. > > On Tue, Jul 21, 2009 at 2:21 PM, Hans Donner <[email protected]> wrote: > > > Thanks. > > Pasted into a new db.py and ran appadmin. No issues here, can browse > > around. > > What DB are you using? Have you tried in a clean (db) environment? > > > On Tue, Jul 21, 2009 at 21:14, hcvst<[email protected]> wrote: > > > >http://pastebin.co.za/22355 > > > > On Jul 21, 8:37 pm, Hans Donner <[email protected]> wrote: > > >> can you mail me the complete model as attachment? lot of other table > > >> dependencies in your posting, want to run it here. > > > >> On Tue, Jul 21, 2009 at 20:17, hcvst<[email protected]> wrote: > > > >> > Controller/function are: /appadmin/index > > > >> > On Jul 21, 8:15 pm, hcvst <[email protected]> wrote: > > >> >> I tried now with web2py 1.65.5 (2009-07-15 17:10:40) > > >> >> and get the same error. > > > >> >> The other tables in the model do not use validators. > > > >> >> Thanks, > > >> >> HC > > > >> >> --- > > > >> >> On Jul 21, 7:44 pm, Hans Donner <[email protected]> wrote: > > > >> >> > 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 -~----------~----~----~----~------~----~------~--~---
