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.JDBCExceptionReporter -
Only dates between January 1, 1753 and December 31, 9999 are accepted.
[XXX/xwiki/bin/view/Stats/Visit] ERROR xwiki.XWikiStatsReader -
Faild to search for vist statistics
com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while
searching documents with sql select name, sum(pageSaves), sum(pageViews),
sum(downloads) from VisitStats where ? <= startDate and endDate < ? group by
name order by sum(pageSaves) asc
Wrapped Exception: could not execute query
at
com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:2292)
at
com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:2221)
at
com.xpn.xwiki.stats.impl.xwiki.XWikiStatsReader.getVisitStatistics(XWikiStatsReader.java:475)
at
com.xpn.xwiki.stats.impl.XWikiStatsServiceImpl.getVisitStatistics(XWikiStatsServiceImpl.java:248)
at com.xpn.xwiki.api.StatsService.getVisitStatistics(StatsService.java:115)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
....
Any way to correct this ?
Sébastien.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/MSSQL-Date-problem-tp5212940p5212940.html
Sent from the XWiki- Users mailing list archive at
Nabble.com.