Hello, As a complement here are the tables description (after migration) mysql> desc xwikistatsdoc; +---------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+--------------+------+-----+---------+-------+ | XWS_ID | int(11) | | PRI | 0 | | | XWS_NUMBER | int(11) | YES | | NULL | | | XWS_NAME | varchar(255) | | | | | | XWS_CLASSNAME | varchar(255) | | | | | | XWS_ACTION | varchar(255) | | | | | | XWS_PAGE_VIEWS | int(11) | YES | | NULL | | | XWS_UNIQUE_VISITORS | int(11) | YES | | NULL | | | XWS_PERIOD | int(11) | YES | | NULL | | | XWS_VISITS | int(11) | YES | | NULL | | +---------------------+--------------+------+-----+---------+-------+ mysql> desc xwikistatsreferer; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | XWR_ID | int(11) | | PRI | 0 | | | XWR_NUMBER | int(11) | YES | | NULL | | | XWR_NAME | varchar(255) | | | | | | XWR_CLASSNAME | varchar(255) | | | | | | XWR_REFERER | varchar(255) | | | | | | XWR_PAGE_VIEWS | int(11) | YES | | NULL | | | XWR_PERIOD | int(11) | YES | | NULL | | +----------------+--------------+------+-----+---------+-------+ mysql> desc xwikistatsvisit; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | XWV_ID | int(11) | | PRI | 0 | | | XWV_NUMBER | int(11) | YES | | NULL | | | XWV_NAME | varchar(255) | | | | | | XWV_CLASSNAME | varchar(255) | | | | | | XWV_IP | varchar(32) | | | | | | XWV_USER_AGENT | varchar(255) | | | | | | XWV_COOKIE | varchar(255) | | | | | | XWV_UNIQUE_ID | varchar(255) | | | | | | XWV_PAGE_VIEWS | int(11) | YES | | NULL | | | XWV_PAGE_SAVES | int(11) | YES | | NULL | | | XWV_DOWNLOADS | int(11) | YES | | NULL | | | XWV_START_DATE | datetime | YES | | NULL | | | XWV_END_DATE | datetime | YES | | NULL | | +----------------+--------------+------+-----+---------+-------+ (hope the tables will show correctly ...) Thanks, Jeremie ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of BOUSQUET Jeremie Sent: lundi 18 février 2008 10:26 To: [email protected] Subject: [xwiki-users] MySQL Error "invalid use of group function" inStatistics application Hello, I just migrated from XWiki 1.1 to 1.2.2. Migration was ok and everything works fine, except the Statistics application. It shows unrecorded stats but there are some. There seems to be an error in an SQL request (miss group by ?), either database was not correctly migrated, or MySQL version is not compatible ? Of course, stats are activated in xwiki.cfg. Here's the error log when trying to display the most viewed pages : [.../Stats/MostViewedPages] [http-80-Processor18] WARN util.JDBCExceptionReporter - SQL Error: 1111, SQLState: HY000 [.../Stats/MostViewedPages] [http-80-Processor18] ERROR util.JDBCExceptionReporter - Invalid use of group function (2 times) I use : mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 java version "1.5.0_11" Thanks for help, Jeremie