On Monday, December 5, 2016 at 10:30:37 AM UTC-8, Ramos wrote: > > this is the offending line > > steps=db((db.status.workflow==currentstep["status"]["workflow"])&(db.status.id==db.events.event)&(db.events.relatedto==uuid)&(db.events.doneat!=None)).select(limitby=(0,5),orderby=~db.events.doneat) > > > Where does currentstep get set up at?
/dps > 2016-12-05 18:29 GMT+00:00 António Ramos <[email protected] <javascript:> > >: > >> Hello i have changed my app from sqlite to postgres... >> moved all data from sqlite to postgres and i get this error.. IT WAS >> WORKING ;) >> <class 'psycopg2.ProgrammingError'> operator does not exist: integer = >> text LINE 1: ...nts WHERE ((((status.workflow = 4) AND (status.id = >> events.e... ^ HINT: No operator matches the given name and argument >> type(s). You might need to add explicit type casts.Versão >> web2py™ Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 >> Python Python 2.7.12: /home/ramstein74/webapps/new2py/bin/uwsgi (prefix: >> /usr/local) >> >> >> > -- 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.
