[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 util.JDB

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: http://xwiki.475771.n2.nabble.com/MS