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.