Bug 752988 - Topics created before and after query generates an error
Summary: Topics created before and after query generates an error
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: PressGang CCMS
Classification: Community
Component: Web-UI
Version: 1.x
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
: ---
Assignee: Matthew Casperson
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-11-10 23:07 UTC by Misha H. Ali
Modified: 2014-08-04 22:26 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-06-07 01:54:58 UTC

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Description Misha H. Ali 2011-11-10 23:07:15 UTC 
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.
Comment 1 Matthew Casperson 2011-11-11 03:08:09 UTC 
Fixed in 20111111-1306
Note You need to log in before you can comment on or make changes to this bug.