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.