Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-1944

Cannot search for a concept using a search term with spaces

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: OpenMRS 1.9.0
    • Fix Version/s: OpenMRS 1.8.0
    • Component/s: None
    • Labels:
      None
    • Complexity:
      Medium

      Description

      I was trying to add an Obs to an Encounter (via http://localhost:8080/openmrs/admin/observations/obs.form?encounterId=135645) and I noticed that if I search for "cd4" then I get results, but if I search for "cd4 facs" I get an error.

      [I found this error in trunk (1.9.x) but I don't have 1.8.x running to test against. I'm going to mark the ticket as fixVersion = 1.8 because I suspect it's there too, but if someone tests this and can't replicate it, then they can bump it to 1.9.]

      Relevant log output is:

      ERROR - JDBCExceptionReporter.logExceptions(78) |2011-01-12 22:42:58,987| Unknown column 'y0_' in 'where clause'
      ERROR - DWRConceptService.findBatchOfConcepts(205) |2011-01-12 22:42:58,991| Error while finding concepts + could not execute query
      org.hibernate.exception.SQLGrammarException: could not execute query
      	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
      	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      	at org.hibernate.loader.Loader.doList(Loader.java:2223)
      	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
      	at org.hibernate.loader.Loader.list(Loader.java:2099)
      	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
      	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
      	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
      	at org.openmrs.api.db.hibernate.HibernateConceptDAO.getConcepts(HibernateConceptDAO.java:1546)
      	at org.openmrs.api.impl.ConceptServiceImpl.getConcepts(ConceptServiceImpl.java:1717)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              darius Darius Jazayeri
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: