Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-136048

Duplicate ordering options appear when the "Recent" filter is applied in the DM management toolbar

    Details

      Description

      Steps to reproduce:

      1. Add some documents in DM to enable the Filter/Order toggle
      2. Select "Recent" (this bug cannot be reproduced by selecting other options)
      3. Click on the toggle again
      4. View the ordering options

      Expected result:
      The Order By options is listed once.

      Actual result:
      The Order By options are listed twice.

      If Downloads is selected, the widget crashes (Downloads works fine if the Recent filter is not selected)

      2021-07-22 07:13:40.000 ERROR [http-nio-8080-exec-6][JDBCExceptionReporter:234] user lacks privilege or object not found: READCOUNT
      2021-07-22 07:13:40.004 ERROR [http-nio-8080-exec-6][render_portlet_jsp:131] null
      org.hsqldb.HsqlException: user lacks privilege or object not found: READCOUNT
              at org.hsqldb.error.Error.error(Error.java:83) ~[hsql.jar:2.3.3]
              at org.hsqldb.error.Error.error(Error.java:72) ~[hsql.jar:2.3.3]
              at org.hsqldb.ExpressionColumn.checkColumnsResolved(ExpressionColumn.java:919) ~[hsql.jar:2.3.3]
              at org.hsqldb.QueryExpression.resolve(QueryExpression.java:216) ~[hsql.jar:2.3.3]
              at org.hsqldb.ParserDQL.compileCursorSpecification(ParserDQL.java:6261) ~[hsql.jar:2.3.3]
              at org.hsqldb.ParserCommand.compilePart(ParserCommand.java:147) ~[hsql.jar:2.3.3]
              at org.hsqldb.ParserCommand.compileStatement(ParserCommand.java:64) ~[hsql.jar:2.3.3]
              at org.hsqldb.Session.compileStatement(Session.java:933) ~[hsql.jar:2.3.3]
              at org.hsqldb.StatementManager.compile(StatementManager.java:375) ~[hsql.jar:2.3.3]
              at org.hsqldb.Session.execute(Session.java:1037) ~[hsql.jar:2.3.3]
              at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3885) ~[hsql.jar:2.3.3]
              at org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:641) ~[hsql.jar:2.3.3]
              at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:312) ~[hikaricp.jar:?]
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doQuery(Loader.java:801) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doList(Loader.java:2542) ~[hibernate-core.jar:3.6.10.Final]
      2021-07-22 07:14:19.822 ERROR [http-nio-8080-exec-1][JDBCExceptionReporter:234] user lacks privilege or object not found: READCOUNT
      2021-07-22 07:14:19.824 ERROR [http-nio-8080-exec-1][render_portlet_jsp:131] null
      org.hsqldb.HsqlException: user lacks privilege or object not found: READCOUNT
              at org.hsqldb.error.Error.error(Error.java:83) ~[hsql.jar:2.3.3]
              at org.hsqldb.error.Error.error(Error.java:72) ~[hsql.jar:2.3.3]
              at org.hsqldb.ExpressionColumn.checkColumnsResolved(ExpressionColumn.java:919) ~[hsql.jar:2.3.3]
              at org.hsqldb.QueryExpression.resolve(QueryExpression.java:216) ~[hsql.jar:2.3.3]
              at org.hsqldb.ParserDQL.compileCursorSpecification(ParserDQL.java:6261) ~[hsql.jar:2.3.3]
              at org.hsqldb.ParserCommand.compilePart(ParserCommand.java:147) ~[hsql.jar:2.3.3]
              at org.hsqldb.ParserCommand.compileStatement(ParserCommand.java:64) ~[hsql.jar:2.3.3]
              at org.hsqldb.Session.compileStatement(Session.java:933) ~[hsql.jar:2.3.3]
              at org.hsqldb.StatementManager.compile(StatementManager.java:375) ~[hsql.jar:2.3.3]
              at org.hsqldb.Session.execute(Session.java:1037) ~[hsql.jar:2.3.3]
              at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3885) ~[hsql.jar:2.3.3]
              at org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:641) ~[hsql.jar:2.3.3]
              at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:312) ~[hikaricp.jar:?]
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doQuery(Loader.java:801) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doList(Loader.java:2542) ~[hibernate-core.jar:3.6.10.Final]
      2021-07-22 07:19:44.238 ERROR [http-nio-8080-exec-8][JDBCExceptionReporter:234] user lacks privilege or object not found: READCOUNT
      2021-07-22 07:19:44.239 ERROR [http-nio-8080-exec-8][render_portlet_jsp:131] null
      org.hsqldb.HsqlException: user lacks privilege or object not found: READCOUNT
              at org.hsqldb.error.Error.error(Error.java:83) ~[hsql.jar:2.3.3]
              at org.hsqldb.error.Error.error(Error.java:72) ~[hsql.jar:2.3.3]
              at org.hsqldb.ExpressionColumn.checkColumnsResolved(ExpressionColumn.java:919) ~[hsql.jar:2.3.3]
              at org.hsqldb.QueryExpression.resolve(QueryExpression.java:216) ~[hsql.jar:2.3.3]
              at org.hsqldb.ParserDQL.compileCursorSpecification(ParserDQL.java:6261) ~[hsql.jar:2.3.3]
              at org.hsqldb.ParserCommand.compilePart(ParserCommand.java:147) ~[hsql.jar:2.3.3]
              at org.hsqldb.ParserCommand.compileStatement(ParserCommand.java:64) ~[hsql.jar:2.3.3]
              at org.hsqldb.Session.compileStatement(Session.java:933) ~[hsql.jar:2.3.3]
              at org.hsqldb.StatementManager.compile(StatementManager.java:375) ~[hsql.jar:2.3.3]
              at org.hsqldb.Session.execute(Session.java:1037) ~[hsql.jar:2.3.3]
              at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3885) ~[hsql.jar:2.3.3]
              at org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:641) ~[hsql.jar:2.3.3]
              at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:312) ~[hikaricp.jar:?]
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doQuery(Loader.java:801) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doList(Loader.java:2542) ~[hibernate-core.jar:3.6.10.Final]
      

      Reproduced on:
      Tomcat 9.0.43 + HSQL 2.3.
      Portal master c0ff0fb7e91a9253de87626ba13ca486d108daf2
      Portal 7.4 CE GA1

      Unable to reproduce on:
      7.3 CE GA5 (the Recent option is not available in this version)

        Attachments

        1. 2.png
          2.png
          218 kB
        2. dm.PNG
          dm.PNG
          14 kB

          Issue Links

            Activity

              People

              Assignee:
              beck.liu Beck Liu
              Reporter:
              austin.chiang Austin Chiang
              Participants of an Issue:
              Recent user:
              Rafaela Nascimento
              Engineering Assignee:
              Jorge González
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                12 weeks, 5 days ago

                  Packages

                  Version Package
                  7.4.2 CE GA3 DXP 7,4
                  Master