Thanks, I must have got the sequence wrong. On Thursday, August 25, 2016 at 12:05:38 PM UTC-7, Niphlod wrote: > > if you get any error with __tmp is because you didn't drop tables on the > backend AND .table files before hitting the app with migrate=True. > > On Thursday, August 25, 2016 at 6:53:07 PM UTC+2, Ben Lawrence wrote: >> >> 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.