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 [email protected].
For more options, visit https://groups.google.com/d/optout.
