Hi,
Has anyone found a solution for this? We are experiencing the same issue
with 2.22.5 and storing the session in the db.
As a work-around, we have removed the ".isoformat" from the line 1247 of
the gluon\globals.py:
modified_datetime=request.now, #.isoformat(),
What would be the impact of our work-around? If we put isoformat in
comment, the modified_datetime will be a string instead of a datetime
object.
On Thursday, June 4, 2020 at 6:30:30 AM UTC+2 Seth J wrote:
> Thanks for pointing the function. But it looks like the error is
> happening on the Session insert. See below *query* block:
>
>
>
> - Variables
> e DataError('22007', '[22007] [Microsoft][ODBC SQL...e from character
> string. (241) (SQLExecDirectW)')
>
> Context
>
> locals request session response
> locals
> e : DataError('22007', '[22007] [Microsoft][ODBC SQL...e from character
> string. (241) (SQLExecDirectW)')
> fields : [(<pydal.objects.Field object>, '172.20.252.61'),
> (<pydal.objects.Field object>, 0), (<pydal.objects.Field object>,
> '2020-06-04T00:21:23.665000'), (<pydal.objects.Field object>,
> '5258b356-2b72-4a24-8868-710222ac0784'), (<pydal.objects.Field object>,
> datetime.datetime(2020, 6, 4, 0, 21, 23, 665000)), (<pydal.objects.Field
> object>,
> '\x80\x02cgluon.globals\nSession\nq\x01}q\x02U\x05flashq\x03U\x00s\x85Rq\x04.')]
> query : 'INSERT INTO
> "web2py_session_PubView"("client_ip"...FscwpTZXNzaW9uCnEBfXECVQVmbGFzaHEDVQBzhVJxBC4=\');'
> self : <pydal.adapters.mssql.MSSQL4 object>
> table :
> <Table web2py_session_PubView (id, locked, clien...me, modified_datetime,
> unique_key, session_data)>
>
> On Wednesday, June 3, 2020 at 11:09:28 PM UTC-4, Dave S wrote:
>>
>>
>>
>> On Wednesday, June 3, 2020 at 2:04:02 PM UTC-7, Seth J wrote:
>>>
>>> I am not sure how to view the query sent to MSSQL.
>>>
>>
>> Does this help/?
>> <URL:
>> https://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#_lastsql
>> >
>>
>>
>>
>>
>>> Here's a little more from the error record:
>>>
>>>
>>> -
>>>
>>> *File C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py
>>> in insert at line 539* code arguments variables
>>> Function argument list
>>>
>>> (self=<pydal.adapters.mssql.MSSQL4 object>, table=<Table
>>> web2py_session_PubView (id, locked, clien...me, modified_datetime,
>>> unique_key, session_data)>, fields=[(<pydal.objects.Field object>,
>>> '172.20.145.208'), (<pydal.objects.Field object>, 0),
>>> (<pydal.objects.Field
>>> object>, '2020-06-03T00:26:05.296000'), (<pydal.objects.Field object>,
>>> 'affc9c47-0085-45dc-8352-12549c7f93dc'), (<pydal.objects.Field object>,
>>> datetime.datetime(2020, 6, 3, 0, 26, 5, 296000)), (<pydal.objects.Field
>>> object>,
>>>
>>> '\x80\x02cgluon.globals\nSession\nq\x01}q\x02U\x05flashq\x03U\x00s\x85Rq\x04.')])
>>>
>>>
>> You've got a date conversion error. Do you need to specify a format
>> string? Is the ISO 'T' causing problems with a format that expects a
>> space? How have you defined the field?
>>
>> /dps
>>
>>
>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/a7015f02-3e03-407e-be45-cf05320e2012n%40googlegroups.com.
