Details

    • Branch Version/s:
      6.0.x
    • Backported to Branch:
      Committed
    • Similar Issues:
      Show 4 results 

      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'

        Activity

        Hide
        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
        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
        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
        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
        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
        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
        Corne added a comment -

        changed the SQL Order

        Show
        Corne added a comment - changed the SQL Order
        Hide
        Igor Spasic added a comment -

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

        Show
        Igor Spasic added a comment - Thank you! Fixed in 6.x and 6.0.x.
        Hide
        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 (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:
              4 years, 9 weeks, 2 days ago

              Development

                Structure Helper Panel