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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/295393b8-2f66-4554-9bd3-3e1529e5dc1c%40googlegroups.com.
