Addendum: the original description is incorrect. My (working) production
copy was actually running a previous version of web2py:
*Version 2.14.6-stable+timestamp.2016.05.10.00.21.47*
Once I revered my development version to 2.14.6, the development version
started working correctly again.
So now the question becomes: *are there any known breaking changes in
2.15.4 vs. 2.14.06? *I'd like to upgrade...
On Monday, September 18, 2017 at 7:31:35 AM UTC-7, E T Bear wrote:
>
> 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.
