Can you print out the raw SQL via ._select() so we can see exactly what is being sent to the database when the error occurs?
On Monday, July 30, 2018 at 5:39:35 AM UTC-4, Rahul wrote: > > Okay I followed everyones instructions > I installed psycopg2 and the application is using this by default. However > it is giving me the same errors I got before. I did not earlier use "%s" % > but in the example I provided I just gave it a try as somewhere I think it > referred to a string issue. > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > > Traceback (most recent call last): > File "D:\web2py\web2py\gluon\restricted.py", line 219, in restricted > exec(ccode, environment) > File "D:/web2py/web2py/applications/Target/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/Target/controllers/default.py>, > line 15360, in <module> > File "D:\web2py\web2py\gluon\globals.py", line 409, in <lambda> > self._caller = lambda f: f() > File "D:/web2py/web2py/applications/Target/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/Target/controllers/default.py>, > line 714, in dashboard > alertRows=s.select() > File "D:\web2py\web2py\gluon\packages\dal\pydal\objects.py", line 2211, in > select > return adapter.select(self.query, fields, attributes) > File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line > 762, in select > return self._select_aux(sql, fields, attributes, colnames) > File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line > 718, in _select_aux > rows = self._select_aux_execute(sql) > File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line > 712, in _select_aux_execute > self.execute(sql) > File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\__init__.py", line > 67, in wrap > return f(*args, **kwargs) > File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line > 412, in execute > rv = self.cursor.execute(command, *args[1:], **kwargs) > InternalError: current transaction is aborted, commands ignored until end of > transaction block > > > <class 'psycopg2.InternalError'> current transaction is aborted, commands > ignored until end of transaction block > > Any suggestions? > > Rahul > > On Sunday, July 29, 2018 at 10:24:07 PM UTC+5:30, Joe Barnhart wrote: >> >> I’d get rid of the idiom: >> >> db.colname==“%s”%pythonvar >> >> Just replace it with: >> >> db.colname==pythonvar >> >> — Joe > > -- 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.
