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:135)
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:51)
 at org.xwiki.rendering.macro.script.AbstractScriptMacro.evaluateBlock(AbstractScriptMacro.java:279)
 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:309)
 at org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183)
 at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.transform(AbstractBlockAsyncRenderer.java:76)
 at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacroRenderer.transform(DefaultWikiMacroRenderer.java:876)
 at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacroRenderer.transform(DefaultWikiMacroRenderer.java:862)
 at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacroRenderer.transform(DefaultWikiMacroRenderer.java:595)
 at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacroRenderer.execute(DefaultWikiMacroRenderer.java:410)
 at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.render(AbstractBlockAsyncRenderer.java:157)
 at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.render(AbstractBlockAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.execute(DefaultBlockAsyncRendererExecutor.java:125)
 at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacro.execute(DefaultWikiMacro.java:110)
 at org.xwiki.rendering.wikimacro.internal.DefaultWikiMacro.execute(DefaultWikiMacro.java:53)
 at org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:309)
 at org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183)
 at org.xwiki.rendering.internal.macro.html.HTMLMacro.renderWikiSyntax(HTMLMacro.java:210)
 at org.xwiki.rendering.internal.macro.html.HTMLMacro.execute(HTMLMacro.java:145)
 at org.xwiki.rendering.internal.macro.html.HTMLMacro.execute(HTMLMacro.java:68)
 at org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:309)
 at org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183)
 at org.xwiki.rendering.internal.transformation.DefaultTransformationManager.performTransformations(DefaultTransformationManager.java:88)
 at org.xwiki.display.internal.DocumentContentAsyncExecutor.executeInCurrentExecutionContext(DocumentContentAsyncExecutor.java:395)
 at org.xwiki.display.internal.DocumentContentAsyncExecutor.execute(DocumentContentAsyncExecutor.java:268)
 at org.xwiki.display.internal.DocumentContentAsyncRenderer.execute(DocumentContentAsyncRenderer.java:112)
 at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.render(AbstractBlockAsyncRenderer.java:157)
 at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.render(AbstractBlockAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:290)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.execute(DefaultBlockAsyncRendererExecutor.java:125)
 at org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:67)
 at org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:43)
 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:1355)
 at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1492)
 at com.xpn.xwiki.doc.XWikiDocument.displayDocument(XWikiDocument.java:1441)
 at com.xpn.xwiki.doc.XWikiDocument.displayDocument(XWikiDocument.java:1410)
 at com.xpn.xwiki.api.Document.displayDocument(Document.java:786)
 at jdk.internal.reflect.GeneratedMethodAccessor396.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:704)
 at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:75)
 at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:242)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:190)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.xwiki.velocity.internal.directive.TryCatchDirective.render(TryCatchDirective.java:86)
 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:321)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:95)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:222)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:177)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:138)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:843)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:805)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:792)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:747)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:739)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:79)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:73)
 at org.xwiki.template.script.TemplateScriptService.render(TemplateScriptService.java:54)
 at jdk.internal.reflect.GeneratedMethodAccessor188.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:492)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)
 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:321)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:95)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:222)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:177)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:138)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:843)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:805)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:792)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:747)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:739)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:79)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:73)
 at org.xwiki.template.script.TemplateScriptService.render(TemplateScriptService.java:54)
 at jdk.internal.reflect.GeneratedMethodAccessor188.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:492)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)
 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:190)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:321)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:95)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:222)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:177)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:138)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:843)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:805)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:785)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:771)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:91)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:85)
 at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:2563)
 at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:180)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:613)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:301)
 at com.xpn.xwiki.web.LegacyActionServlet.service(LegacyActionServlet.java:114)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
 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:122)
 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:61)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
 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:202)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
 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:346)
 at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with namespace [xwiki:Blog.BlogSheet]
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:289)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:321)
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:127)
 ... 212 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 xwiki:Blog.BlogSheet[line 207, column 45]
 at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:308)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:235)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:704)
 at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:75)
 at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:242)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:190)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 ... 214 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:184)
 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:306)
 at org.xwiki.query.internal.ScriptQuery.execute(ScriptQuery.java:276)
 at jdk.internal.reflect.GeneratedMethodAccessor277.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 ... 227 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:835)
 at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:902)
 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:169)
 ... 237 more
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
 at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
 at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626)
 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.lambda$execute$0(HqlQueryExecutor.java:172)
 at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826)
 ... 239 more
Caused by: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
 at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
 at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:111)
 at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:138)
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:50)
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:149)
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176)
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:151)
 at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2122)
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2059)
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2037)
 at org.hibernate.loader.Loader.doQuery(Loader.java:956)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:357)
 at org.hibernate.loader.Loader.doList(Loader.java:2868)
 at org.hibernate.loader.Loader.doList(Loader.java:2850)
 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682)
 at org.hibernate.loader.Loader.list(Loader.java:2677)
 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:540)
 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
 at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
 at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1459)
 at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649)
 at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617)
 ... 241 more
Caused by: java.sql.SQLException: Too many connections
 at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:299)
 at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:370)
 at org.mariadb.jdbc.client.impl.StandardClient.<init>(StandardClient.java:119)
 at org.mariadb.jdbc.Driver.connect(Driver.java:70)
 at org.mariadb.jdbc.Driver.connect(Driver.java:101)
 at org.mariadb.jdbc.Driver.connect(Driver.java:27)
 at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52)
 at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:374)
 at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:571)
 at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:298)
 at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:223)
 at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:141)
 at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:731)
 at com.xpn.xwiki.store.DBCPConnectionProvider.getConnection(DBCPConnectionProvider.java:258)
 at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:38)
 at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:108)
 ... 261 more