Yes I did. Thanks for the help On Sat, Nov 30, 2019, 07:45 Dave S <[email protected]> wrote:
> > > 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]> 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]> 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 >>> <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 > <https://groups.google.com/d/msgid/web2py/c0cb5b6f-9292-4817-b4f2-a6b29827b4be%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/CAAcHJF-xf614C_krRiqkFa0yoiXJkC9B8B67BESzWc-A-HYL1A%40mail.gmail.com.
