On Friday, November 29, 2019 at 1:06:01 AM UTC-8, Lovedie JC wrote: > > 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. >
Ah! Did you use r_name to fix things, or a more thorough change? /dps > > On Wed, Nov 27, 2019, 19:01 Maurice Waka <[email protected] <javascript:>> > 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 <[email protected] <javascript:>> >> 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] <javascript:>. >>> 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] <javascript:>. >> 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/c0cb5b6f-9292-4817-b4f2-a6b29827b4be%40googlegroups.com.
