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.

Reply via email to