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.
