Uploaded image for project: 'Document Accordion Macro'
  1. Document Accordion Macro
  2. DOCACCORDI-7

Query error on postgresql database and jndi connector

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 1.0
    • None
    • Awaiting Committer feedback

    Description

      Hello,
      on my tomcat server the macro

      {{docaccordion xclass="XWiki.XWikiUsers"/}}
      

      failed with this error:

      Failed to execute the [docaccordion] macro. Cause: [An error appears when trying to get accordions for the parameters [space: null, xclass: xwiki:XWiki.XWikiUsers, sort: CHRONO, limit: 100], reason: Exception while executing query. Query statement = [, BaseObject AS obj WHERE obj.name=doc.fullName AND obj.className=:xclass AND doc.name NOT LIKE '%Template' AND doc.hidden=0 ORDER BY doc.date DESC]]. Click on this message for details.
      

      catalina.out show this:

      2017-07-06 17:17:45,368 [https://xwiki-dev.dom.cp2i.i2/bin/view/BacASable/testb/] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 0, SQLState: 42883 
      2017-07-06 17:17:45,369 [https://xwiki-dev.dom.cp2i.i2/bin/view/BacASable/testb/] ERROR o.h.u.JDBCExceptionReporter    - ERREUR: l'opérateur n'existe pas : boolean = integer
        Indice : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
      Vous devez ajouter des conversions explicites de type.
        Position : 274 
      

      I manage to fix it (quote missing)

      Pascal

      Attachments

        Activity

          People

            Unassigned Unassigned
            Pbas Pascal BASTIEN
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: