More on this
Traceback
Traceback (most recent call last):
File "/home/mauricewaka/web2py/gluon/contrib/pg8000/core.py", line 1891,
in execute
ps = cache['ps'][key]
KeyError: ('SELECT "auth_user"."id", "auth_user"."first_name",
"auth_user"."last_name", "auth_user"."email", "auth_user"."password",
"auth_user"."registration_key", "auth_user"."reset_password_key",
"auth_user"."registration_id", "auth_user"."gender", "auth_user"."city",
"auth_user"."country", "auth_user"."phoneNo", "auth_user"."pic",
"auth_user"."spams", "auth_user"."premium" FROM "auth_user" WHERE
("auth_user"."email" = \'hest...@gmail.com\') LIMIT 1 OFFSET 0;', ())
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mauricewaka/web2py/gluon/restricted.py", line 219, in
restricted
exec(ccode, environment)
File
"/home/mauricewaka/web2py/applications/myappname/controllers/default.py",
line 219, in <module>
File "/home/mauricewaka/web2py/gluon/globals.py", line 421, in <lambda>
self._caller = lambda f: f()
File
"/home/mauricewaka/web2py/applications/myappname/controllers/default.py",
line 84, in user
return dict(form=auth())
File "/home/mauricewaka/web2py/gluon/tools.py", line 1801, in __call__
return getattr(self, args[0])()
File "/home/mauricewaka/web2py/gluon/tools.py", line 2586, in login
user = table_user(**{username: entered_username})
File "/home/mauricewaka/web2py/gluon/packages/dal/pydal/objects.py", line
596, in __call__
orderby_on_limitby=False).first()
File "/home/mauricewaka/web2py/gluon/packages/dal/pydal/objects.py", line
2395, in select
return adapter.select(self.query, fields, attributes)
File
"/home/mauricewaka/web2py/gluon/packages/dal/pydal/adapters/base.py", line
763, in select
return self._select_aux(sql, fields, attributes, colnames)
File
"/home/mauricewaka/web2py/gluon/packages/dal/pydal/adapters/base.py", line
719, in _select_aux
rows = self._select_aux_execute(sql)
File
"/home/mauricewaka/web2py/gluon/packages/dal/pydal/adapters/base.py", line
713, in _select_aux_execute
self.execute(sql)
File
"/home/mauricewaka/web2py/gluon/packages/dal/pydal/adapters/__init__.py",
line 67, in wrap
return f(*args, **kwargs)
File
"/home/mauricewaka/web2py/gluon/packages/dal/pydal/adapters/postgres.py",
line 203, in execute
return super(PostgrePG8000, self).execute(*args, **kwargs)
File
"/home/mauricewaka/web2py/gluon/packages/dal/pydal/adapters/__init__.py",
line 67, in wrap
return f(*args, **kwargs)
File
"/home/mauricewaka/web2py/gluon/packages/dal/pydal/adapters/base.py", line
413, in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
File "/home/mauricewaka/web2py/gluon/contrib/pg8000/core.py", line 906,
in execute
self._c.execute(self, operation, args)
File "/home/mauricewaka/web2py/gluon/contrib/pg8000/core.py", line 1940,
in execute
self.handle_messages(cursor)
File "/home/mauricewaka/web2py/gluon/contrib/pg8000/core.py", line 2088,
in handle_messages
raise self.error
gluon.contrib.pg8000.core.ProgrammingError: ('ERROR', 'ERROR', '42703',
'column auth_user.gender does not exist', '219', 'parse_relation.c',
'3293', 'errorMissingColumn', '', '')
On Tue, Nov 26, 2019 at 12:47 PM Maurice Waka <mauricew...@gmail.com> wrote:
> Using python3,
> I added the extra fields on auth_user using this code:
>
> auth.settings.extra_fields['auth_user']=[
> Field('gender',requires=IS_IN_SET(('Male','Female'))),
> Field('city',requires=IS_NOT_EMPTY()),
> Field('country',requires=IS_NOT_EMPTY()),
> Field('phoneNo',requires=IS_NOT_EMPTY()),
> Field('pic','upload',requires=IS_NOT_EMPTY()),
> Field('spams','integer',readable=False,writable=False,default=0),
> Field('premium',requires=IS_IN_SET(('0','1')),readable=False,writable=
> False,default='0')
> ]
>
>
> But I keep getting this errors on sqlite and postgresql:
>
> <class 'sqlite3.OperationalError'> no such column: auth_user.gender
>
>
>
> What could be the problem as this was working few days ago till I updated
> ubuntu yesterday but didn't change any code on web2py
> Regards
>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/iuaK65yJjR4/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/41dc920e-60a3-423a-834c-3b34a801e391%40googlegroups.com
> <https://groups.google.com/d/msgid/web2py/41dc920e-60a3-423a-834c-3b34a801e391%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/CALkNK57vRqrJU23ZHxcT-DXhaHQ3BuzwnP9jX0-AXx8H9WPicw%40mail.gmail.com.
