Re: [xwiki-users] SQL Error after upgrade to 7.4

Hi, After upgrading to 7.4 from 7.2, the ‘Pages in <spacename>’ on the Dashboard page never finish loading. This error only appears on new spaces. Existing spaces load fine. postgres syslog Jan 22 05:46:54 perch postgres[13210]: [1487-3] DETAIL: parameters: $1 = 'test4', $2 = 'test4.%', $3 = 'dummy', $4 = 'xwiki', $5 = 'xwiki:XWiki.mfarrell', $6 = 'xwiki:XWiki.mfarrell^XWiki.XWikiUsers', $7 = 'xwiki:Main.LDAPFrigoff^XWiki.XWikiGroups', $8 = 'xwiki:Main.LDAPUsers^XWiki.XWikiGroups', $9 = 'xwiki:Main.LDAPAdmin^XWiki.XWikiGroups', $10 = '20' Jan 22 05:46:56 perch postgres[13210]: [1488-1] ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list at character 505 Jan 22 05:46:56 perch postgres[13210]: [1488-2] STATEMENT: select distinct case when xwikispace1_.XWS_PARENT='test4' then xwikispace1_.XWS_NAME else xwikidocum0_.XWD_NAME end as col_0_0_, case when xwikispace1_.XWS_PARENT='test4' then 0 else 1 end as col_1_0_ from xwikidoc xwikidocum0_ cross join xwikispace xwikispace1_ where xwikispace1_.XWS_HIDDEN<>true and (xwikidocum0_.XWD_HIDDEN<>true or xwikidocum0_.XWD_HIDDEN is null) and (xwikispace1_.XWS_PARENT=$1 or xwikidocum0_.XWD_WEB=$2 and xwikidocum0_.XWD_TRANSLATION=0 and xwikidocum0_.XWD_NAME<>$3) order by lower(case when xwikispace1_.XWS_PARENT='test4' then xwikispace1_.XWS_NAME else xwikidocum0_.XWD_NAME end), case when xwikispace1_.XWS_PARENT='test4' then xwikispace1_.XWS_NAME else xwikidocum0_.XWD_NAME end limit $4 catalina.out 2016-01-22 05:46:56,315 [ https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… < https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…] WARN o.h.u.JDBCExceptionReporter - SQL Error: 0, SQLState: 42P10 2016-01-22 05:46:56,327 [ https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… < https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…] ERROR o.h.u.JDBCExceptionReporter - ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list Position: 505 2016-01-22 05:46:56,328 [ https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… < https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #addNestedChildDocuments called at 63:xwiki:XWiki.DocumentTree[line 440, column 1] 2016-01-22 05:46:56,328 [ https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… < https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #addChildDocuments called at 63:xwiki:XWiki.DocumentTree[line 626, column 1] 2016-01-22 05:46:56,328 [ https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… < https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #addDocumentChildren called at 63:xwiki:XWiki.DocumentTree[line 1, column 1] 2016-01-22 05:46:56,328 [ https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… < https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #getChildren called at 63:xwiki:XWiki.DocumentTree[line 39, column 1] 2016-01-22 05:46:56,328 [ https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… < https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #handleDocumentTreeRequest called at 63:xwiki:XWiki.DocumentTree[line 3, column 1] _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users