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

Exception occurred when change the order of WC by title

    Details

      Description

      Steps to reproduce:

      1. Start portal and login.
      2. Go to Content > WC > create 2 WCs.
      3. Change All for Recent in the management bar.
      4. Change the order of WC by title.

      Expected result:
      WCs ordered by title.

      Actual result:
      Exception occurred in console, and error message displayed on page.

      05:08:10,814 ERROR [http-nio-8080-exec-13][render_portlet_jsp:131] null
      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'JournalArticle.title' in 'order clause'
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.Util.getInstance(Util.java:386)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hong.zhao Hong Zhao
                Reporter:
                hong.zhao Hong Zhao
                Participants of an Issue:
                Recent user:
                Jason Pince
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 46 weeks, 1 day ago

                  Packages

                  Version Package
                  7.1.X
                  Master