I got this error after installing psycopg2
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/base.py", line
413, in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
psycopg2.ProgrammingError: column auth_user.gender does not exist
LINE 1: ...set_password_key", "auth_user"."registration_id", "auth_user...
^
On Wed, Nov 27, 2019 at 12:21 AM Dave S <[email protected]> wrote:
>
>
> On Tuesday, November 26, 2019 at 4:48:28 AM UTC-8, Maurice Waka wrote:
>>
>> 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]
>>
>
> You're using pg8000. That has been NOT RECOMMENDED for several years
> now. Please try psycopg2. When I first switched to PostGres, I used
> pg8000 and there were some strange things that occurred from time to time.
> When I figured out how to get psycopg2 going, things worked beautifully.
>
>
>
> 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" = \'[email protected]\') 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 <[email protected]> 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
>>> [email protected].
>>> 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 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
> [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/4a9b609d-bf71-484c-9750-bf3ff6255efa%40googlegroups.com
> <https://groups.google.com/d/msgid/web2py/4a9b609d-bf71-484c-9750-bf3ff6255efa%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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/CALkNK56QcJjomHqXY6_uh8hhRHEfz6iZ1iwvE29xqrSuTwxO9g%40mail.gmail.com.
