Uploaded image for project: 'Hippo CMS'
  1. Hippo CMS
  2. CMS-7433

Error when searching users in the user screen in the cms configuration

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Top
    • Resolution: Duplicate
    • Affects Version/s: 2.24.06
    • Fix Version/s: 2.24.07
    • Component/s: cms7-release
    • Labels:
      None
    • Environment:
      Archetype 7.8.5
    • Similar issues:

      Description

      Unable to search for users in the cms administration panel. When trying to search for a user an invalid query excetion error occurs.

      Repoduction path:

      • go in the cms to administration screen
      • go to the users tab
      • type a search term in the search box ('admin')
      • Press 'search user'

      Then the following error occurs:
      21.10.2013 09:28:42 ERROR [org.hippoecm.frontend.plugins.cms.admin.SearchableDataProvider.populateList():174] Error while executing query: SELECT * FROM hipposys:user WHERE (hipposys:system <> 'true' OR hipposys:system IS NULL) AND ( fn:name() = 'mtolkamp' OR jcr:contains(hipposys:firstname, 'mtolkamp') OR jcr:contains(hipposys:lastname, 'mtolkamp') OR jcr:contains(hipposys:email, 'mtolkamp') )

      javax.jcr.query.InvalidQueryException: Encountered "hipposys:firstname" at line 1, column 140.

      Full stacktrace is attached.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jsheriff Junaidh Kadhar Sheriff
                Reporter:
                mtolkamp Matthijs Tolkamp (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: