Since yesterday my web2py cannot log events to a mssql database any more.
I'm pretty sure yesterday everything worked fine. Even the welcome app
fails on register now.
I dropped every table, delete the database logs and even recreated the
database itself. I'm always getting a char to datetime conversion error.
web2py™ Version 2.4.4-stable+timestamp.2013.03.11.20.32.00 Python Python
2.7.2: C:\Python27\python.exe (prefix: C:\Python27) Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
Traceback (most recent call last):
File "D:\web2py\gluon\restricted.py", line 212, in restricted
exec ccode in environment
File "D:/web2py/applications/app/controllers/default.py"
<http://192.168.77.4:8000/admin/default/edit/ImageContest/controllers/default.py>,
line 82, in <module>
File "D:\web2py\gluon\globals.py", line 194, in <lambda>
self._caller = lambda f: f()
File "D:/web2py/applications/app/controllers/default.py"
<http://192.168.77.4:8000/admin/default/edit/ImageContest/controllers/default.py>,
line 6, in user
def user(): return dict(form=auth())
File "D:\web2py\gluon\tools.py", line 1245, in __call__
return getattr(self, args[0])()
File "D:\web2py\gluon\tools.py", line 2148, in login
self.log_event(log, user)
File "D:\web2py\gluon\tools.py", line 1707, in log_event
origin=origin, user_id=user_id)
File "D:\web2py\gluon\dal.py", line 8443, in insert
ret = self._db._adapter.insert(self, self._listify(fields))
File "D:\web2py\gluon\dal.py", line 1201, in insert
raise e
DataError: ('22007', '[22007] [Microsoft][ODBC SQL Server Driver][SQL
Server]Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp
liegt der datetime-Wert au\xdferhalb des g\xfcltigen Bereichs. (242)
(SQLExecDirectW); [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Die
Anweisung wurde beendet. (3621)')
--
---
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.
For more options, visit https://groups.google.com/groups/opt_out.
