On Monday, September 18, 2017 at 10:52:47 AM UTC-7, E T Bear wrote:
>
> 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 reverted 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...
>
>
There's a short bug list.  One of the differences has to do with some field 
naming changes.   Is this post from the 2.15.0b1 thread relevant?
<URL:https://groups.google.com/d/msg/web2py/ooZKk5i8zew/g6CqzIfzBgAJ>


You can see the bug list at
<URL:https://github.com/web2py/pydal/issues>
(roughly bugs after #470 are 2.15.x issues).

Issues also have some additional discussion in the contributors and core 
team forum,
<URL:https://groups.google.com/forum/#!forum/web2py-developers>

/dps


> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to