Details

    • Branch Version/s:
      6.0.x
    • Backported to Branch:
      Committed

      Description

      when we try to use com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.search() in web content templates(using velocity) or in plugin portlet. It gives error in console:

      ERROR [JDBCExceptionReporter:234] Unknown column 'id' in 'order clause'

        Issue Links

          Activity

          Hide
          nasirhussain nasir hussain added a comment -

          The problem is in custom sql i.e journal.xml

          com.liferay.portlet.journal.service.persistence.JournalArticleFinder.findByC_G_A_V_T_D_C_T_S_T_D_S_R

          in this, you will find "ORDER BY id ASC" but in place of "id" there should be "id_" as in JournalArticle table "id" field doesn't exist.

          Show
          nasirhussain nasir hussain added a comment - The problem is in custom sql i.e journal.xml com.liferay.portlet.journal.service.persistence.JournalArticleFinder.findByC_G_A_V_T_D_C_T_S_T_D_S_R in this, you will find "ORDER BY id ASC" but in place of "id" there should be "id_" as in JournalArticle table "id" field doesn't exist.
          Hide
          corné Corne added a comment -

          This issue is a backlog candidate for the 100 PaperCuts program. Please consider participating! See http://liferay.com/community/100-papercuts

          Show
          corné Corne added a comment - This issue is a backlog candidate for the 100 PaperCuts program. Please consider participating! See http://liferay.com/community/100-papercuts
          Hide
          corné Corne added a comment -

          This issue is currently being addressed in Sprint 4 of the 100 PaperCuts program. Please see http://liferay.com/community/100-papercuts

          Show
          corné Corne added a comment - This issue is currently being addressed in Sprint 4 of the 100 PaperCuts program. Please see http://liferay.com/community/100-papercuts
          Hide
          corné Corne added a comment -

          changed the SQL Order

          Show
          corné Corne added a comment - changed the SQL Order
          Hide
          igor.spasic Igor Spasic added a comment -

          Thank you! Fixed in 6.x and 6.0.x.

          Show
          igor.spasic Igor Spasic added a comment - Thank you! Fixed in 6.x and 6.0.x.
          Hide
          paul.piao Paul Piao (Inactive) added a comment -

          This issue has been resolved

          I can not reproduce on Trunk Revision:79750.

          If you are still experiencing an issue, please open another ticket or please visit our Community Message Boards.

          Thanks.

          Show
          paul.piao Paul Piao (Inactive) added a comment - This issue has been resolved I can not reproduce on Trunk Revision:79750. If you are still experiencing an issue, please open another ticket or please visit our Community Message Boards. Thanks.

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 43 weeks, 5 days ago

                Development

                  Subcomponents