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