172.20.145.208.2020-06-03.00-26-05.a903caa0-1d7d-4612-a5f9-104967995098
web2py™ | Version 2.20.4-stable+timestamp.2020.05.03.05.18.50 |
---|---|
Python | Python 2.7.10: C:\Python27\python.exe (prefix: C:\Python27) |
1. | Traceback (most recent call last): |
<class 'pyodbc.DataError'>(('22007', '[22007] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. (241) (SQLExecDirectW)'))
File C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py in insert at line 539 code arguments variables
(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.')])
534. | self.execute(query) |
e | DataError('22007', '[22007] [Microsoft][ODBC SQL...e from character string. (241) (SQLExecDirectW)') |
---|
I am not sure how to view the query sent to MSSQL.
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.')])
e | DataError('22007', '[22007] [Microsoft][ODBC SQL...e from character string. (241) (SQLExecDirectW)') |
---|
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)> |