seems a casting error: what is the definition on the database of your auth_events table as stored in the database ? what is your connection string ?
On Wednesday, March 13, 2013 1:46:43 PM UTC+1, Marian wrote: > > Somehow my web2py is not working with my mssql database anymore. I am > pretty sure it worked yesterday. Today it seems every log_event in auth > fails. Even the welcome app fails on register an user. > > I dropped all tables and even recreated the database. Nothing works > anymore. > > > 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/ImageContest/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/ImageContest/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.