I am running on Windows 7 Ent. 64, with Python 2.7.2 x64 as you also can
see in the log. It seems it fails even if I do not insert a timestamp.
Created by Massimo Di Pierro, Copyright 2007-2013
Version 2.4.4-stable+timestamp.2013.03.11.20.32.00
Database drivers available: SQLite(sqlite3), MySQL(pymysql),
PostgreSQL(pg8000),
MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc), Ingres(pyodbc), IMAP(imaplib)
WARNING:web2py:import IPython error; use default python shell
Python 2.7.2 (default, Jun 24 2011, 12:22:14) [MSC v.1500 64 bit (AMD64)]
on win
32
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> auth.log_event('something')
Traceback (most recent call last):
File "<console>", line 1, in <module>
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)')
>>> db.commit()
>>> db.auth_event.insert(client_ip='bogus', user_id=1, origin='tests',
description='trial1')
Traceback (most recent call last):
File "<console>", line 1, in <module>
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)')
>>> db.commit()
>>> request.now
datetime.datetime(2013, 3, 13, 15, 2, 9, 442000)
>>> db.auth_event.insert(client_ip='bogus', time_stamp=request.now)
Traceback (most recent call last):
File "<console>", line 1, in <module>
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
