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 [email protected].
For more options, visit https://groups.google.com/d/optout.
