Details
-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
1.6
-
None
-
Windows 10 Pro 64 bit, Chrome v.60, Firefox v.55, IE v.11, using a local instance XWiki 8.4.5 with ORACLE 11.2
Description
Prerequisites: The instance of XWiki must be configured with Oracle Database.
STEPS TO REPRODUCE
- Install Meetings Application
- Create several meeting entries (with different titles, leaders, places, start dates and statuses)
- Go to Meetings Home and sort the meeting entries (ascending/descending) by Meeting, Leader, Place, Start, Status
- Then, also filter the meeting entries by the fields mentioned at Step 3
EXPECTED RESULTS
The sorting and filtering actions work properly without any errors.
ACTUAL RESULTS
When sorting by Leader, sorting doesn't work and the following error appears in the console:
2017-08-14 12:26:47,165 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] WARN o.h.u.JDBCExceptionReporter - SQL Error: 932, SQLState: 42000 2017-08-14 12:26:47,165 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] ERROR o.h.u.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expected - got CLOB 2017-08-14 12:26:47,167 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #gridresult_buildRowsJSON called at 74:xwiki:XWiki.LiveTableResults[line 381, column 1] 2017-08-14 12:26:47,168 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #gridresultwithfilter_buildJSON called at 74:xwiki:XWiki.LiveTableResults[line 405, column 1] 2017-08-14 12:26:47,168 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #gridresultwithfilter called at 74:xwiki:XWiki.LiveTableResults[line 36, column 1]
Also, the a.m. sorting error affects filtering, which stops working afterwards.
Attachments
Issue Links
- is duplicated by
-
-
- Open
-