Can you pinpoint the line in your code that is causing the error?
Can you see the SQL statement that is being sent to the server?
-Jim
On Tuesday, June 2, 2020 at 11:29:27 PM UTC-5, Seth J wrote:
>
> Yes, same error. 🤷🏼♂️
>
> Error ticket for "PubView"Ticket ID
>
> 172.20.145.208.2020-06-03.00-26-05.a903caa0-1d7d-4612-a5f9-104967995098
> Version
> 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)
> Traceback
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
>
> Traceback (most recent call last):
> File ".\gluon\main.py", line 456, in wsgibase
> session._try_store_in_db(request, response)
> File ".\gluon\globals.py", line 1254, in _try_store_in_db
> record_id = table.insert(**dd)
> File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\objects.py", line 888, in
> insert
> ret = self._db._adapter.insert(self, row.op_values())
> File "C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py", line
> 539, in insert
> raise e
> DataError: ('22007', '[22007] [Microsoft][ODBC SQL Server Driver][SQL
> Server]Conversion failed when converting date and/or time from character
> string. (241) (SQLExecDirectW)')
>
> Error snapshot [image: help]
> <https://vmweb2pysql02.gpo.gov/admin/default/ticket/PubView/172.20.145.208.2020-06-03.00-26-05.a903caa0-1d7d-4612-a5f9-104967995098#>
>
> <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)'))
>
> On Tuesday, June 2, 2020 at 1:53:37 AM UTC-4, Clemens wrote:
>>
>> Have you already tried the latest version
>> 2.20.4-stable+timestamp.2020.05.03.05.18.50
>> <http://www.web2py.com/init/default/download>?
>>
>>
>> On Monday, June 1, 2020 at 8:12:08 PM UTC+2, Seth J wrote:
>>>
>>> I am running IIS connecting to SQL Server. Upgrade seems to have
>>> introduced an error to an otherwise functioning app. Any ideas???
>>>
>>> [image: error_web2py.png]
>>>
>>>
--
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/cba0643c-0b9e-4a4f-9e61-457d322fb352%40googlegroups.com.
