Hi Niphlod, I deleted all the scheduler tables , created a new database and then rebooted with DAL(..migrate=True..) yet still get this error column "worker_stats__tmp" is of type json but expression is of type text'
using postgresql 9.4 on raspberry pi. In http://stackoverflow.com/questions/32501027/casting-text-type-column-to-json-type-in-postgresql there is a mention of recasting. If this is a solution, would you know how I can incorporate this into web2py? thanks, Ben On Wednesday, May 27, 2015 at 12:53:40 PM UTC-7, Niphlod wrote: > > Please drop the scheduler_worker table from the database and remove the > file *_scheduler_worker.table from the databases/ folder of your > application, then set migrate to True (a single request with migrate=True > will suffice). The table will be recreated properly and the error will go > away. > > The error comes from the fact that the adapter chooses "at connection > time" the "nicest" column type to play with based on the backend version. > The definition of the scheduler_worker table has a "json" Field, that on > postgresql 9.3 maps to a "json" column, while on 9.1 was a "text" column, > hence the misbehaviour if you don't drop and re-create the table. > > -- 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.