hel-o wrote:
... Displaying Groups in XWikiPreferences seems not to work. I get the following error in the logs:
2008-09-12 13:08:50,444 [http://localhost:8080/xwiki16m2/bin/admin/XWiki/XWikiPreferences?xpage=getgr...] [http-8080-2] WARN util.JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000 2008-09-12 13:08:50,444 [http://localhost:8080/xwiki16m2/bin/admin/XWiki/XWikiPreferences?xpage=getgr...] [http-8080-2] ERROR util.JDBCExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from stringprop2_.XWS_VALUE)<>''' at line 1
This is a bug: http://jira.xwiki.org/jira/browse/XWIKI-2665 MySql and probably others dbs except hsqldb are affected. Will be fixed in RC1. Thanks for report. -- Artem Melentyev