any ideas ? 2017-03-20 12:54 GMT+00:00 António Ramos <ramstei...@gmail.com>:
> 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.