Hi, I think I had the same problem, in my case it was a DAL constructor parameter changing its value in new web2py versions. Try to revert entity_quoting parameter to False as per this issue ticket I filed: https://github.com/web2py/web2py/issues/1697
See also here: http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Database-quoting-and-case-settings--entity_quoting--ignore_field- Il giorno lunedì 31 luglio 2017 11:56:56 UTC+2, Oliver Holmes ha scritto: > > Hi, > > just extracted 2.15.2-stable over my 2.14.6-stable, prior to that had > stopped all services related to web2py, and now whenever I try to access > one of my own tables, not web2pys system tables like auth_user or > scheduler_task, I get the following error (same for every attempt to access > tables): > > <class 'psycopg2.ProgrammingError'> column gdt_config.fkEntbindungsdatum > does not exist LINE 1: ...fig"."gdtversion", "gdt_config"."gdtzeichensatz", > "gdt_confi... ^ Version > web2py™ Version 2.15.2-stable+timestamp.2017.07.19.12.18.41 > Python Python 2.7.9: /usr/bin/python (prefix: /usr) Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > 24. > 25. > 26. > 27. > 28. > 29. > 30. > 31. > > Traceback (most recent call last): > File "/home/www-data/web2py/gluon/restricted.py", line 219, in restricted > exec(ccode, environment) > File "<string>", line 173, in <module> > File "/home/www-data/web2py/gluon/sqlhtml.py", line 3435, in __init__ > r = A(represent(field, r, record), _href=str(href)) > File "/home/www-data/web2py/gluon/sqlhtml.py", line 79, in represent > return f(value) > File "/home/www-data/web2py/gluon/packages/dal/pydal/helpers/methods.py", > line 287, in __call__ > return value if value is None else _fieldformat(self.ref, value) > File "/home/www-data/web2py/gluon/packages/dal/pydal/helpers/methods.py", > line 271, in _fieldformat > row = r(id) > File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line 554, > in __call__ > orderby_on_limitby=False).first() > File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line > 2211, in select > return adapter.select(self.query, fields, attributes) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 760, in select > return self._select_aux(sql, fields, attributes, colnames) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 716, in _select_aux > rows = self._select_aux_execute(sql) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 710, in _select_aux_execute > self.execute(sql) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/__init__.py", > line 67, in wrap > return f(*args, **kwargs) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 410, in execute > rv = self.cursor.execute(command, *args[1:], **kwargs) > ProgrammingError: column gdt_config.fkEntbindungsdatum does not exist > LINE 1: ...fig"."gdtversion", "gdt_config"."gdtzeichensatz", "gdt_confi... > ^ > > Error snapshot [image: help] > <https://192.168.110.78/admin/default/ticket/CTGRead/__1.2017-07-31.11-37-20.7e87378e-4a98-4261-8572-c1fa835d357d#> > > > <class 'psycopg2.ProgrammingError'>(column gdt_config.fkEntbindungsdatum > does not exist LINE 1: ...fig"."gdtversion", "gdt_config"."gdtzeichensatz", > "gdt_confi... ^ ) > > Attribute inspizieren > Frames > > - > > *File /home/www-data/web2py/gluon/restricted.py in restricted at line > 219* code arguments Variablen > - > > *File /home/www-data/web2py/<string> in <module> at line 173* code > arguments Variablen > - > > *File /home/www-data/web2py/gluon/sqlhtml.py in __init__ at line 3435* > code arguments Variablen > - > > *File /home/www-data/web2py/gluon/sqlhtml.py in represent at line 79* > code arguments Variablen > - > > *File > /home/www-data/web2py/gluon/packages/dal/pydal/helpers/methods.py in > __call__ at line 287* code arguments Variablen > - > > *File > /home/www-data/web2py/gluon/packages/dal/pydal/helpers/methods.py in > _fieldformat at line 271* code arguments Variablen > - > > *File /home/www-data/web2py/gluon/packages/dal/pydal/objects.py in > __call__ at line 554* code arguments Variablen > - > > *File /home/www-data/web2py/gluon/packages/dal/pydal/objects.py in > select at line 2211* code arguments Variablen > - > > *File /home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py > in select at line 760* code arguments Variablen > - > > *File /home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py > in _select_aux at line 716* code arguments Variablen > - > > *File /home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py > in _select_aux_execute at line 710* code arguments Variablen > - > > *File > /home/www-data/web2py/gluon/packages/dal/pydal/adapters/__init__.py in > wrap > at line 67* code arguments Variablen > - > > *File /home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py > in execute at line 410* code arguments Variablen > Function argument list > > (self=<pydal.adapters.postgres.PostgrePsyco object>, *args=('SELECT > "gdt_config"."id", "gdt_config"."smbserve..." WHERE ("gdt_config"."id" = > 2) > LIMIT 1 OFFSET 0;',), **kwargs={}) > Code listing > > 405. > 406. > 407. > 408. > 409. > 410. > > 411. > 412. > 413. > 414. > > def execute(self, *args, **kwargs): > command = self.filter_sql_command(args[0]) > handlers = self._build_handlers_for_execution() > for handler in handlers: > handler.before_execute(command) > rv = self.cursor.execute(command, *args[1:], **kwargs) > > for handler in handlers: > handler.after_execute(command) > return rv > > Variables > rv undefined > self <pydal.adapters.postgres.PostgrePsyco object> > args ('SELECT "gdt_config"."id", "gdt_config"."smbserve..." WHERE > ("gdt_config"."id" = 2) LIMIT 1 OFFSET 0;',) > self.cursor <cursor object at 0x679e6ad0; closed: 0> > command 'SELECT "gdt_config"."id", "gdt_config"."smbserve..." WHERE > ("gdt_config"."id" = 2) LIMIT 1 OFFSET 0;' > self.cursor.execute <built-in method execute of > psycopg2.extensions.cursor object> > kwargs {} > > The same db.py works perfectly with 2.14.6. > > Not sure what is going on here. > > > Regards, > > Oliver Holmes > -- 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.