Hi Anthony,
I am printing this to console - The query is trying to fetch
records that have an ETA in next 15 days
print db(((db.issues.eta_date > today) & (db.issues.eta_date <=
fifteen_days_ahead)) & (db.issues.workspace == user_workspace) &
(db.issues.created_by
== logged_in_user))._select()
Here is the query output (Just removed a few fields only in between as
there were many) - If needed I will send the entire query.
SELECT "issues"."id", "issues"."ticket_no", "issues"."project_name",
"issues"."sub_project", "issues"."team", "issues"."date_today", "issues".
"category", "issues"."created_by", "issues"."workspace", "issues"."eta_date"
, "issues"."notify" FROM "issues" WHERE (((("issues"."eta_date" >
'2018-07-31') AND ("issues"."eta_date" <= '2018-08-14')) AND ("issues".
"workspace" = 'WS1')) AND ("issues"."created_by" = 'rahul'));
Let me know if anything else is needed -
Thank you
Rahul
On Monday, July 30, 2018 at 11:23:05 PM UTC+5:30, Anthony wrote:
>
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
