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)
2016-12-05 18:29 GMT+00:00 António Ramos <[email protected]>: > 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.
