Thank you Dave S.
Adding '*ignore_field_case=True, entity_quoting=False,* ' to the DAL
constructor call seems to have solved the problem. That, plus the ritual
invocation of '*find ~/web2py -name "*.pyc" -delete*'.
On Monday, September 18, 2017 at 7:31:35 AM UTC-7, E T Bear wrote:
>
> *SOLVED (more or less) - see Addendum in the following message.*
>
> My application, which uses postgresql, is getting the following error for
> all of my own tables, i.e. all tables other than the "auth_" set. For
> example, if the table is UserEvent, the error is:
>
>
> *<class 'psycopg2.ProgrammingError'> relation "UserEvent" does not exist
> LINE 1: ...ype", "UserEvent"."Description" FROM "auth_user", "UserEvent...
> ^*
> This is happening only when running from my local pycharm development
> installation, using arg "-a admin" for a straight or debug run. The
> production copy of the exact same code on the same machine using the same
> postgresql database, running under Lighttpd, works fine. So I know that
> the database itself is good and all the tables are present in the database.
>
> I have tried deleting the application/databases files from the development
> tree, and recreating them with fake_migrate_all=True in the DAL
> constructor. The meta files get re-created by the error persists. I've
> also tried copying the working application/databases/* files over from the
> production to the development tree, but the same error remains.
>
> This is with:
>
> *Version 2.15.4-stable+timestamp.2017.09.02.04.02.22*
>
> Any suggestion of what else to try will be appreciated. A matching trace
> from appadmin is included below.
>
> Traceback (most recent call last):
> File
> "/home/bear/Development/dkdemo/dkaccess/web2py/applications/dkaccess/controllers/appadmin.py",
> line 245, in select
> nrows = db(query, ignore_common_filters=True).count()
> File
> "/home/bear/Development/dkdemo/dkaccess/web2py/gluon/packages/dal/pydal/objects.py",
> line 2201, in count
> return db._adapter.count(self.query, distinct)
> File
> "/home/bear/Development/dkdemo/dkaccess/web2py/gluon/packages/dal/pydal/adapters/base.py",
> line 790, in count
> self.execute(self._count(query, distinct))
> File
> "/home/bear/Development/dkdemo/dkaccess/web2py/gluon/packages/dal/pydal/adapters/__init__.py",
> line 67, in wrap
> return f(*args, **kwargs)
> File
> "/home/bear/Development/dkdemo/dkaccess/web2py/gluon/packages/dal/pydal/adapters/base.py",
> line 412, in execute
> rv = self.cursor.execute(command, *args[1:], **kwargs)
> ProgrammingError: relation "UserEvent" does not exist
> LINE 1: SELECT count(*) FROM "UserEvent" WHERE ("UserEvent"."id" > 0...
> ^
>
>
>
>
>
>
>
--
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.
For more options, visit https://groups.google.com/d/optout.
