Blog

org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [#set ($blogDescriptorParam = $xcontext.macro.params.blog)
#set ($categoryParam = $xcontext.macro.params.category)
#set ($fromDateParam = $xcontext.macro.params.fromDate)
#set ($toDateParam = $xcontext.macro.params.toDate)
#set ($publishedParam = $xcontext.macro.params.published)
#set ($hiddenParam = $xcontext.macro.params.hidden)
#set ($limitParam = $xcontext.macro.params.limit)
#set ($layoutParam = $xcontext.macro.params.layout)
#set ($paginatedParam = $xcontext.macro.params.paginated)
#set ($layoutAdditionalParams = $xcontext.macro.params.layoutParams)
## Passing the blog posts list parameters to the layout macro
#foreach($p in $xcontext.macro.params.getParameterNames())
  #if ($p == 'blog' && "$!blogDescriptorParam" != '')
    #set ($v = $blogDescriptorParam)
    #set ($layoutAdditionalParams = "$!{layoutAdditionalParams}|list-${p}=${v}")
  #elseif($p != 'layoutParams' && "$!xcontext.macro.params.get($p)" != '')
    #set ($v = $xcontext.macro.params.get($p))
    #set ($layoutAdditionalParams = "$!{layoutAdditionalParams}|list-${p}=${v}")
  #end
#end
## If the 'layoutParams' parameter is empty check if there are layout parameters set at Blog level.
#if("$!blogDescriptorParam" != '' && "$!xcontext.macro.params.layoutParams" == '')
  #set ($blogDoc = $xwiki.getDocument($blogDescriptorParam))
  #set ($blogObj = $blogDoc.getObject($blogClassname))
  #set ($blogLayoutParams = $blogObj.getProperty('postsLayoutParameters').value)
  #if ("$!blogLayoutParams" != '')
    #set ($layoutAdditionalParams = "$!{layoutAdditionalParams}|${blogLayoutParams}")
  #end
#end
#if ("$!layoutAdditionalParams" != '' && $layoutAdditionalParams.startsWith('|'))
  #set ($layoutAdditionalParams = $layoutAdditionalParams.replaceFirst('\|', ''))
#end
#set ($blogPostLayoutPrefix = 'blogPostLayout')
#set ($isValidBlog = false)
#set ($isAggregatorBlog = false)
#set ($blogCategoriesLocation = $defaultBlogSpace)
#set ($blogPostsLocation = $defaultBlogSpace)
#set ($resutls = [])

#getAllBlogPostsQuery($hql)
#set ($queryParams = {})
#set ($whereQuery = "")

## blog descriptor parameter
#if ("$!blogDescriptorParam" != '')
  ## Get information from the blog descriptor
  #set ($blogDescriptorDoc = $xwiki.getDocument($blogDescriptorParam))
  #set ($blogDescriptorObj = $blogDescriptorDoc.getObject($blogClassname))
  #if ("$!blogDescriptorObj" != '')
    #set ($isValidBlog = true)
    ## For backwards compatibility the default blog (under 'Blog' space) is considered as an aggregator blog
    #if ($blogDescriptorDoc.space == $defaultBlogSpace)
      #set ($isAggregatorBlog = true)
    #end
    #if ("$!blogDescriptorObj.getProperty('categoriesLocation').value" != '')
      #set ($blogCategoriesLocation = $blogDescriptorObj.getProperty('categoriesLocation').value)
    #end
    #if ("$!blogDescriptorObj.getProperty('postsLocation').value" != '')
      #set ($blogPostsLocation = $blogDescriptorObj.getProperty('postsLocation').value)
    #elseif($blogDescriptorDoc.space != $defaultBlogSpace)
      #set ($blogPostsLocation = $blogDescriptorDoc.space)
    #end
  #end
  #set($sanitizedCategoriesLocation = $blogCategoriesLocation.replaceAll('([%_!])', '!$1').concat('.%'))
  #if ($isAggregatorBlog)
    #getCategoryAllBlogPostsQuery($hql)
    #set ($discard = $queryParams.put('catList', $sanitizedCategoriesLocation))
    #set ($discard = $queryParams.put('space', $blogPostsLocation))
    #set ($whereQuery = " and (doc.space = :space or catList like :catList escape '!')")
  #else
    #set ($discard = $queryParams.put('space', $blogPostsLocation))
    #set ($whereQuery = " and doc.space =:space")
  #end
#end

#if ("$!blogDescriptorParam" != '' && !$isValidBlog)
  #set ($XDOMList = [])
  #set ($toParse = "{{error}}${services.localization.render('blog.blogpostlist.descriptor_not_found', [$blogDescriptorParam])}{{/error}}")
  #set ($xdom = $services.rendering.parse($toParse, $xwiki.getCurrentContentSyntaxId()).getChildren())
  #set ($discard = $XDOMList.addAll($xdom))
  #set($xcontext.macro.result = $XDOMList)
#else
  ## category parameter
  #if("$!categoryParam" != '')
    #getCategoryAllBlogPostsQuery($hql)
    ## Check if it is a category or space
    #set ($isCategoriesSpace = true)
    #set ($categoryDoc = $xwiki.getDocument($categoryParam))
    #if (!$categoryDoc.isNew())
      #set ($categoryObj = $categoryDoc.getObject('Blog.CategoryClass'))
      #if ("$!categoryObj" != '')
        #set ($isCategoriesSpace = false)
      #end
    #end
    #if ($isCategoriesSpace)
      ## Exclude uncetagorized posts
      #set ($exculdedCategory = "${categoryParam}.WebHome")
      #if ($categoryParam == $defaultBlogSpace)
        #set ($exculdedCategory = "${categoryParam}.Categories.WebHome")
      #end
      #set($sanitizedCategoryParam = $categoryParam.replaceAll('([%_!])', '!$1').concat('.%'))
      #set ($whereQuery = "${whereQuery} and catList<>:excludedCategory and catList like :category escape '!'")
      #set ($discard = $queryParams.put('category', $sanitizedCategoryParam))
      #set ($discard = $queryParams.put('excludedCategory', $exculdedCategory))
    #else
      ## Get all posts of the category and its sub categories
      #getCategoriesHierarchy ($categoryDoc.space $catTree)
      #set ($subcategories = [])
      #getSubcategories ($catTree $categoryParam $subcategories)
      #set ($whereQuery = "${whereQuery} and (catList=:category")
      #set ($discard = $queryParams.put('category', $categoryParam))
      #foreach($subCategory in $subcategories)
        #set ($whereQuery = "${whereQuery} or catList=:category${foreach.count}")
        #set ($discard = $queryParams.put("category${foreach.count}", $subCategory))
      #end
      #set ($whereQuery = "${whereQuery} )")
    #end
  #end

  ## fromDate parameter
  #if ("$!fromDateParam" != '' && "$!datetool.toDate('yyyy-M-d', $fromDateParam)" != '')
    #set ($whereQuery = "${whereQuery} and publishDate.value>=:fromDate")
    #set ($discard = $queryParams.put('fromDate', $datetool.toDate("yyyy-M-d", $fromDateParam)))
  #end

  ## toDate parameter
  #if ("$!toDateParam" != '' && "$!datetool.toDate('yyyy-M-d', $toDateParam)" != '')
    #set ($cal = $datetool.getCalendar())
    #set ($discard = $cal.setTime($datetool.toDate("yyyy-M-d", $toDateParam)))
    #set ($discard = $cal.add(5, 1)) ## toDate = toDate + 1 day
    #set ($whereQuery = "${whereQuery} and publishDate.value<:toDate")
    #set ($discard = $queryParams.put('toDate', $datetool.toDate("yyyy-M-d", $cal.getTime())))
  #end

  #if ("$!publishedParam" != '')
    #if ("$!publishedParam" == 'no')
      #set ($whereQuery = "${whereQuery} and isPublished.value=0")
    #elseif("$!publishedParam" == 'yes')
      #set ($whereQuery = "${whereQuery} and isPublished.value=1")
    #end
  #end

  #if ("$!hiddenParam" != '')
    #if ("$!hiddenParam" == 'yes')
      #set ($whereQuery = "${whereQuery} and hidden.value=1")
    #elseif("$!hiddenParam" == 'no')
      #set ($whereQuery = "${whereQuery} and hidden.value=0")
    #end
  #end

  #set ($hql = "${hql} ${whereQuery}")

  ## Exclude pinned posts
  ## Pinned posts are a list of blog posts that are saved in a Blog.PinnedPostsClass object attached to the descriptor of the blog
  ## The pinned posts are displayed in a different way on the blog post layout compared to the other blog posts, FTM the pinned posts are supported on the 'cards' blog post layout
  ## the pinned posts are displayed only if the blog post layout parameter 'forceDisplayPinnedPosts' is equal to 'true'
  #set ($pinnedPosts = [])
  #extractLayoutParametersFromString($layoutAdditionalParams $layoutParamsMap)
  #if ("$!layoutParamsMap.get('forceDisplayPinnedPosts')" == 'true' && "$!blogDescriptorParam" != '')
    #set ($pinnedPostsSourceDoc = $xwiki.getDocument($blogDescriptorParam))
  #end
  #if ("$!pinnedPostsSourceDoc" != '')
    #set ($pinnedPostsObj = $pinnedPostsSourceDoc.getObject('Blog.PinnedPostsClass'))
    #if ("$!pinnedPostsObj" != '')
      #set ($pinnedPosts = $pinnedPostsObj.getProperty('posts').value)
    #end
  #end
  #if ($pinnedPosts.size() > 0)
    #set ($hql = "${hql} and doc.fullName not in :pinnedPosts")
    #set ($discard = $queryParams.put('pinnedPosts', $pinnedPosts))
  #end
  ###

  ## Ordering
  #set ($hql = "${hql} order by publishDate.value desc")
  #set($query = $services.query.hql($hql))
  #set($countQuery = $services.query.hql($hql))
  #bindQueryParameters($query $queryParams)
  #bindQueryParameters($countQuery $queryParams)

  #if ("$!paginatedParam" == 'yes')
    #if ("$!limitParam" == '')
      #if ($isValidBlog) ## Get the blog itemsPerPage parameter
        #getBlogProperty($blogDescriptorDoc 'itemsPerPage' '10' $limitParam)
      #else
        #set ($limitParam = 10)
      #end
    #end
    #set ($totalPosts = $countQuery.addFilter("unique").count())
    ## This macro is defined in the default macros.vm library. It also sets $itemsPerPage and $startAt.
    #set ($itemsPerPage = $numbertool.toNumber($limitParam).intValue())
    #preparePagedViewParams($totalPosts $itemsPerPage)
    #set ($query = $query.setOffset($startAt))
  #end
  #if ("$!limitParam" != '')
    #set ($query = $query.setLimit($numbertool.toNumber($limitParam).intValue()))
  #end

  #if ("$!layoutParam" != '')
    #set ($blogPostLayoutMacro = "${blogPostLayoutPrefix}${layoutParam.substring(0, 1).toUpperCase()}${layoutParam.substring(1)}")
    #set ($blogPostLayoutMacro = $blogPostLayoutMacro.replaceAll('~', '~~').replaceAll('"', '~"'))
  #end

  #set ($results = [])

  #if("$!limitParam" == '' || $numbertool.toNumber($limitParam).intValue() > 0)
    #set ($results = $query.addFilter("unique").execute())
  #end

  ## If all the posts are pinned nothing will be returned by the query because pinned posts are excluded
  ## Note, that the pinned posts are stored in an object attached to the blog descriptor.
  ## The display of pinned posts is managed inside the blog post layout macros.
  ## so, before the display of the first post, the pinned posts are extracted from the blog descriptor and displayed in a custom way (big blocks, ...).
  ## In order to display the pinned posts even if the query don't return results we return the pinned posts as results.

  #if ($pinnedPosts.size() > 0 && $results.size() == 0)
    #set ($results = $pinnedPosts)
  #end

  #set ($layoutAdditionalParams = "$!{layoutAdditionalParams}|list-results-count=${results.size()}")
  #set ($layoutAdditionalParams = $layoutAdditionalParams.replaceAll('~', '~~').replaceAll('"', '~"'))
  #set ($XDOMList = [])
  #set ($previousPostReference = '')
  #foreach($result in $results)
    #if ($services.security.authorization.hasAccess('view', $result))
      #set ($layoutAdditionalParams = "${layoutAdditionalParams}|postIndex=${foreach.index}|previousPostReference=$!{previousPostReference}")
      #set ($escapedPostReference = $result.replaceAll('~', '~~').replaceAll('"', '~"'))
      #set ($toParse = "{{${blogPostLayoutMacro} reference=${escapetool.getQuote()}${escapedPostReference}${escapetool.getQuote()} params=${escapetool.getQuote()}$!layoutAdditionalParams${escapetool.getQuote()}/}}")
      #set ($xdom = $services.rendering.parse($toParse, $xwiki.getCurrentContentSyntaxId()).getChildren())
      #set ($discard = $XDOMList.addAll($xdom))
      #set ($previousPostReference = $escapedPostReference)
    #end
  #end
  ## Pagination
  #if ("$!paginatedParam" == 'yes')
    #set ($xdom = $services.rendering.parse("{{html wiki='true'}}#displayNavigationLinks($NULL){{/html}}", $xwiki.getCurrentContentSyntaxId()).getChildren())
    #set ($discard = $XDOMList.addAll($xdom))
  #end
  #set($xcontext.macro.result = $XDOMList)
#end]
	at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:139)
	at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:52)
	at org.xwiki.rendering.macro.script.AbstractScriptMacro.evaluateBlock(AbstractScriptMacro.java:286)
	at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:182)
	at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:58)
	at org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:297)
	at org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183)
	at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.transform(AbstractBlockAsyncRenderer.java:59)
	at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacroRenderer.transform(DefaultWikiMacroRenderer.java:403)
	at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacroRenderer.transform(DefaultWikiMacroRenderer.java:372)
	at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacroRenderer.render(DefaultWikiMacroRenderer.java:266)
	at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacroRenderer.render(DefaultWikiMacroRenderer.java:67)
	at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:233)
	at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
	at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:233)
	at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:216)
	at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.execute(DefaultBlockAsyncRendererExecutor.java:119)
	at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacro.execute(DefaultWikiMacro.java:109)
	at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacro.execute(DefaultWikiMacro.java:53)
	at org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:297)
	at org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183)
	at org.xwiki.rendering.internal.macro.html.HTMLMacro.renderWikiSyntax(HTMLMacro.java:274)
	at org.xwiki.rendering.internal.macro.html.HTMLMacro.execute(HTMLMacro.java:154)
	at org.xwiki.rendering.internal.macro.html.HTMLMacro.execute(HTMLMacro.java:73)
	at org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:297)
	at org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183)
	at org.xwiki.rendering.internal.transformation.DefaultTransformationManager.performTransformations(DefaultTransformationManager.java:101)
	at org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:263)
	at org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:133)
	at org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:58)
	at org.xwiki.display.internal.DefaultDocumentDisplayer.display(DefaultDocumentDisplayer.java:96)
	at org.xwiki.display.internal.DefaultDocumentDisplayer.display(DefaultDocumentDisplayer.java:39)
	at org.xwiki.sheet.internal.SheetDocumentDisplayer.display(SheetDocumentDisplayer.java:245)
	at org.xwiki.sheet.internal.SheetDocumentDisplayer.applySheet(SheetDocumentDisplayer.java:225)
	at org.xwiki.sheet.internal.SheetDocumentDisplayer.maybeDisplayWithSheet(SheetDocumentDisplayer.java:180)
	at org.xwiki.sheet.internal.SheetDocumentDisplayer.display(SheetDocumentDisplayer.java:111)
	at org.xwiki.sheet.internal.SheetDocumentDisplayer.display(SheetDocumentDisplayer.java:52)
	at org.xwiki.display.internal.ConfiguredDocumentDisplayer.display(ConfiguredDocumentDisplayer.java:68)
	at org.xwiki.display.internal.ConfiguredDocumentDisplayer.display(ConfiguredDocumentDisplayer.java:42)
	at com.xpn.xwiki.doc.XWikiDocument.display(XWikiDocument.java:1202)
	at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1243)
	at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1220)
	at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1251)
	at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:738)
	at sun.reflect.GeneratedMethodAccessor449.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
	at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
	at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
	at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:567)
	at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71)
	at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
	at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.xwiki.velocity.introspection.TryCatchDirective.render(TryCatchDirective.java:87)
	at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:259)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222)
	at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:358)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:847)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:723)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.lambda$renderFromSkin$0(InternalTemplateManager.java:698)
	at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:697)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:676)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:662)
	at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:78)
	at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:2290)
	at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:2268)
	at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:992)
	at sun.reflect.GeneratedMethodAccessor270.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
	at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
	at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
	at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:216)
	at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:311)
	at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:230)
	at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:259)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222)
	at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:358)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:847)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:723)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.lambda$renderFromSkin$0(InternalTemplateManager.java:698)
	at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:697)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:676)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:662)
	at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:78)
	at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:2290)
	at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:2268)
	at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:992)
	at sun.reflect.GeneratedMethodAccessor270.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
	at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
	at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
	at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:216)
	at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:311)
	at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:230)
	at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
	at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106)
	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:259)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222)
	at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:358)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:847)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:723)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.lambda$renderFromSkin$0(InternalTemplateManager.java:698)
	at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:697)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:676)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:662)
	at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:78)
	at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:2290)
	at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:2268)
	at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:992)
	at sun.reflect.GeneratedMethodAccessor270.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
	at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
	at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
	at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:216)
	at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:311)
	at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:230)
	at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:259)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222)
	at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:358)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:847)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:723)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.lambda$renderFromSkin$0(InternalTemplateManager.java:698)
	at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:697)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:676)
	at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:662)
	at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:78)
	at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:2290)
	at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:179)
	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:489)
	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:670)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.xwiki.wysiwyg.filter.ConversionFilter.doFilter(ConversionFilter.java:109)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:132)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [belgenet:Blog.BlogSheet]
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:227)
	at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:358)
	at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:131)
	... 208 more
Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'execute' in  class org.xwiki.query.internal.ScriptQuery threw exception org.xwiki.query.QueryException: Exception while executing query. Query statement = [, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate, DBStringListProperty as category left join category.list catList
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.XWikiGuest' or (isPublished.value = 1 and hidden.value = 0)) and obj.id=category.id.id and category.id.name='category'  and (doc.space = :space or catList like :catList escape '!') order by publishDate.value desc] at 5332:belgenet:Blog.BlogSheet[line 207, column 45]
	at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:243)
	at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:187)
	at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
	at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:567)
	at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71)
	at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
	at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106)
	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:259)
	at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222)
	... 210 more
Caused by: org.xwiki.query.QueryException: Exception while executing query. Query statement = [, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate, DBStringListProperty as category left join category.list catList
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.XWikiGuest' or (isPublished.value = 1 and hidden.value = 0)) and obj.id=category.id.id and category.id.name='category'  and (doc.space = :space or catList like :catList escape '!') order by publishDate.value desc]
	at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:195)
	at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
	at org.xwiki.query.internal.SecureQueryExecutorManager.execute(SecureQueryExecutorManager.java:67)
	at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:296)
	at org.xwiki.query.internal.ScriptQuery.execute(ScriptQuery.java:245)
	at sun.reflect.GeneratedMethodAccessor595.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
	at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
	... 222 more
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:927)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:990)
	at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:177)
	... 232 more
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor$1.doInHibernate(HqlQueryExecutor.java:185)
	at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor$1.doInHibernate(HqlQueryExecutor.java:178)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:921)
	... 234 more
Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:280)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
	at org.postgresql.Driver.makeConnection(Driver.java:454)
	at org.postgresql.Driver.connect(Driver.java:256)
	at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:260)
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889)
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:433)
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:362)
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)
	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1528)
	at com.xpn.xwiki.store.DBCPConnectionProvider.getConnection(DBCPConnectionProvider.java:248)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
	... 250 more
Caused by: java.net.ConnectException: Connection refused (Connection refused)
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:589)
	at org.postgresql.core.PGStream.<init>(PGStream.java:70)
	at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:91)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
	... 263 more