| Summary: | Topics created before and after query generates an error | ||
|---|---|---|---|
| Product: | [Community] PressGang CCMS | Reporter: | Misha H. Ali <mhusnain> |
| Component: | Web-UI | Assignee: | Matthew Casperson <mcaspers> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 1.x | CC: | cbredesen, lnewson, topic-tool-list |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2013-06-07 01:54:58 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
Fixed in 20111111-1306 |
Description of problem: When searching for topics tagged with the release EDG 6 and created after Monday, 7 Nov and before Friday, 11 Nov result in the below error message: An Error Occurred: javax.el.ELException: /CustomSearchTopicList.xhtml @314,199 value="Topic Search Results (#{empty topicTagsList.resultList ? 0 : (topicTagsList.paginated ? topicTagsList.resultCount : topicTagsList.resultList.size)}) #{topicTagsList.searchTagHeading}": java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: T12 near line 1, column 104 [select topic from com.redhat.topicindex.entity.Topic as Topic where topic.topicTimeStamp >= 2011-11-07T12:00:00.000+10:00 and topic.topicTimeStamp <= 2011-11-11T12:00:00.000+10:00((exists (select 1 from com.redhat.topicindex.entity.TopicToTag topicToTag where topicToTag.topic = topic and topicToTag.tag.tagId = 168) ))] Additional info: FWIW, this error appeared yesterday when I was searching for topics tagged for EDG 6 and created after 7 Nov and before 10 Nov.