any help? I´m hosting with webfaction and they moved my app to another
server
<class 'psycopg2.ProgrammingError'> column "worker_stats__tmp" is of type
json but expression is of type text LINE 1: UPDATE scheduler_worker SET
worker_stats__tmp=worker_stats; ^ HINT: You will need to rewrite or cast
the expression.Versão
web2py™ Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
Python Python 2.7.5: /home/ramstein74/webapps/new2py/bin/uwsgi (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.
Traceback (most recent call last):
File "/home/ramstein74/webapps/new2py/web2py/gluon/restricted.py",
line 227, in restricted
exec ccode in environment
File
"/home/ramstein74/webapps/new2py/web2py/applications/fileit/models/db1.py"
<https://docs.cires.pt/admin/default/edit/fileit/models/db1.py>, line
127, in <module>
scheduler=Scheduler(db)
File "/home/ramstein74/webapps/new2py/web2py/gluon/scheduler.py",
line 567, in __init__
self.define_tables(db, migrate=migrate)
File "/home/ramstein74/webapps/new2py/web2py/gluon/scheduler.py",
line 659, in define_tables
migrate=self.__get_migrate('scheduler_worker', migrate)
File
"/home/ramstein74/webapps/new2py/web2py/gluon/packages/dal/pydal/base.py",
line 834, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File
"/home/ramstein74/webapps/new2py/web2py/gluon/packages/dal/pydal/base.py",
line 873, in lazy_define_table
polymodel=polymodel)
File
"/home/ramstein74/webapps/new2py/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 510, in create_table
fake_migrate=fake_migrate
File
"/home/ramstein74/webapps/new2py/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 623, in migrate_table
self.execute(sub_query)
File
"/home/ramstein74/webapps/new2py/web2py/gluon/packages/dal/pydal/adapters/postgres.py",
line 362, in execute
return BaseAdapter.execute(self, *a, **b)
File
"/home/ramstein74/webapps/new2py/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1388, in execute
return self.log_execute(*a, **b)
File
"/home/ramstein74/webapps/new2py/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1382, in log_execute
ret = self.get_cursor().execute(command, *a[1:], **b)
ProgrammingError: column "worker_stats__tmp" is of type json but
expression is of type text
LINE 1: UPDATE scheduler_worker SET worker_stats__tmp=worker_stats;
^
HINT: You will need to rewrite or cast the expression.
--
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.
