Solved. I asked for help from Webfaction and those guys just know a "litle" about web2y...
Thanks 2017-03-23 8:38 GMT+00:00 Niphlod <[email protected]>: > you didn't let migration happen after dropping both the .table files and > the underlying tables on the database. > > > On Wednesday, March 22, 2017 at 6:20:12 PM UTC+1, Ramos wrote: >> >> I had the same problem this week and did all >> >> >> *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.* >> Now i get the error >> <class 'psycopg2.ProgrammingError'> relation "scheduler_worker" does not >> exist >> >> any help? >> >> >> Em quarta-feira, 8 de março de 2017 14:05:46 UTC, Ben Lawrence escreveu: >>> >>> forget it, I am going back to mysql. >>> >>> On Sunday, March 5, 2017 at 4:48:30 AM UTC-8, Ben Lawrence wrote: >>>> >>>> OK, >>>> I have two machines, one with web2py+nginx (machine A) and the other >>>> with postgresql (machine B) >>>> >>>> On machine A: >>>> I check migrate = 0 >>>> I delete all the scheduler tables >>>> I check that I deleted all the scheduler tables >>>> >>>> On machine B: >>>> I delete all the scheduler tables in postgres >>>> >>>> On machine A: >>>> I check that there are no scheduler tables. >>>> I reboot it >>>> >>>> I check that there are no scheduler tables >>>> I turn on migrate = 1 >>>> There are now scheduler tables. >>>> I go to scheduler tables in web2py admin, scheduler_tasks show new >>>> tasks that have since completed, >>>> scheduler_run show new tasks that have completed, >>>> but scheduler_worker has error: >>>> >>>> Traceback (most recent call last): >>>> File >>>> "/home/www-data/web2py/applications/temperature/controllers/appadmin.py:select", >>>> line 270, in select >>>> File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line >>>> 2045, in select >>>> return adapter.select(self.query, fields, attributes) >>>> File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", >>>> line 746, in select >>>> return self._select_aux(sql, fields, attributes, colnames) >>>> File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", >>>> line 727, in _select_aux >>>> return processor(rows, fields, colnames, cacheable=cacheable) >>>> File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", >>>> line 305, in parse >>>> for row in rows >>>> File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", >>>> line 229, in _parse >>>> value = self.parse_value(value, fit, ft, blob_decode) >>>> File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", >>>> line 196, in parse_value >>>> return self.parser.parse(value, field_itype, field_type) >>>> File >>>> "/home/www-data/web2py/gluon/packages/dal/pydal/parsers/__init__.py", line >>>> 101, in parse >>>> return self.registered[field_itype](value, field_type) >>>> File >>>> "/home/www-data/web2py/gluon/packages/dal/pydal/parsers/__init__.py", line >>>> 76, in __call__ >>>> return self.call(value, field_type) >>>> File >>>> "/home/www-data/web2py/gluon/packages/dal/pydal/parsers/__init__.py", line >>>> 73, in _call >>>> return self.f(self.parser, value) >>>> File "/home/www-data/web2py/gluon/packages/dal/pydal/parsers/base.py", >>>> line 129, in _json >>>> raise RuntimeError('json data not a string') >>>> RuntimeError: json data not a string >>>> >>>> >>>> On Friday, August 26, 2016 at 4:41:38 PM UTC-7, Ben Lawrence wrote: >>>>> >>>>> 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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.
