I think my error was due to a reserved name. I had a field called timestamp
that was leading to the error.
Now works well.
On Wed, Nov 27, 2019, 19:01 Maurice Waka <mauricew...@gmail.com> wrote:
> 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 <snidely....@gmail.com> 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" = \'hes...@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 <mauri...@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
>>>> web...@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 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/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 web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CALkNK56QcJjomHqXY6_uh8hhRHEfz6iZ1iwvE29xqrSuTwxO9g%40mail.gmail.com
> <https://groups.google.com/d/msgid/web2py/CALkNK56QcJjomHqXY6_uh8hhRHEfz6iZ1iwvE29xqrSuTwxO9g%40mail.gmail.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/CAAcHJF9PPJ9XS4_4aHGmbh%3DG1jEzBw4EY-wVzj-O8EoQEw%3DfpA%40mail.gmail.com.
