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

The widget crashes when changing the filter with "downloads" in DM management toolbar

    Details

      Description

      Steps to reproduce:

      1. Add some documents in DM to enable the Filter and Order
      2. Attempt to change the filter (In this case, Select "Recent" > "Downloads")

      Expected result:
      The widget displays as normal.

      Actual result:
      The widget crashes.

      2021-07-28 08:06:20.944 ERROR [http-nio-8080-exec-8][render_portlet_jsp:131] null
      java.sql.SQLSyntaxErrorException: Unknown column 'readCount' in 'order clause'
              at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql.jar:8.0.21]
              at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql.jar:8.0.21]
              at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql.jar:8.0.21]
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql.jar:8.0.21]
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql.jar:8.0.21]
              at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[hikaricp.jar:?]
              at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.doQuery(Loader.java:802) ~[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]
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.Loader.list(Loader.java:2271) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) ~[hibernate-core.jar:3.6.10.Final]
              at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) ~[hibernate-core.jar:3.6.10.Final]
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:176) ~[portal-impl.jar:?]
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:168) ~[portal-impl.jar:?]
              at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:84) ~[portal-kernel.jar:?]
      

      Note: This only occurs when changing the filter with "Downloads".

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              beck.liu Beck Liu
              Reporter:
              beck.liu Beck Liu
              Participants of an Issue:
              Recent user:
              Sophia Zhang
              Engineering Assignee:
              Samuel Tran
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                6 weeks, 4 days ago

                  Packages

                  Version Package
                  7.4.3.5 CE GA5
                  7.4.13 DXP U1
                  Master