[xwiki-users] MSSQL Date problem

2010-06-23 Thread Sébastien Touzet
Hi, We are using Tomcat 6.0.18, MSSQL 2005 and XWiki 2.4-MILESTONE-1.29254. When we go to the Stats page this error is displayed in the log : [XXX/xwiki/bin/view/Stats/Visit] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: 22003 [XXX/xwiki/bin/view/Stats/Visit] ERROR

Re: [xwiki-users] MSSQL Date problem

2010-06-23 Thread Marius Dumitru Florea
Hi Sébastien, On 06/23/2010 03:11 PM, Sébastien Touzet wrote: Hi, We are using Tomcat 6.0.18, MSSQL 2005 and XWiki 2.4-MILESTONE-1.29254. When we go to the Stats page this error is displayed in the log : [XXX/xwiki/bin/view/Stats/Visit] WARN util.JDBCExceptionReporter - SQL Error:

Re: [xwiki-users] MSSQL Date problem

2010-06-23 Thread Sébastien Touzet
Hi, All the start/end dates seems OK in the table : 23/06/2010 14:27:11 23/06/2010 14:27:11 17/06/2010 16:58:59 17/06/2010 16:58:59 17/06/2010 16:58:59 17/06/2010 16:58:59 17/06/2010 16:58:59 17/06/2010 16:58:59 17/06/2010 09:49:39 17/06/2010 09:49:39 The panel contains

Re: [xwiki-users] MSSQL Date problem

2010-06-23 Thread Sébastien Touzet
OK, your were right ! The problem came from criteriaService.periodFactory.ALL_TIME Replaced by criteriaService.periodFactory.currentYear and all works fine now ! Thank's a lot ! (ALL_TIME is too far ago for SQLSERVER !) -- View this message in context: