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

Shopping portlet does not render properly in PostgreSQL

    Details

    • Type: Regression Bug
    • Status: Verified
    • Resolution: Unresolved
    • Affects Version/s: 7.0.1 CE GA2, 7.0.0 DXP SP1, 7.0.X
    • Fix Version/s: None
    • Component/s: Util, Util > Shopping
    • Labels:
    • Fix Priority:
      4
    • Databases:
      PostgreSQL 9.3

      Description

      Steps to reproduce:

      1. Start portal
      2. Navigate to Content > Shopping

      Expected results:
      Shopping portlet appears with all of its buttons and nav tabs.

      Actual results:
      Nothing appears. Errors are thrown into the console:

      20:02:11,448 ERROR [http-nio-8080-exec-10][JDBCExceptionReporter:234] ERROR: UNION types bigint and text cannot be matched_  Position: 348 [Sanitized]
      20:02:11,464 ERROR [http-nio-8080-exec-10][IncludeTag:128] Current URL /group/guest/~/control_panel/manage?p_p_id=com_liferay_shopping_web_portlet_ShoppingAdminPortlet&p_p_lifecycle=0&p_p_state=maximized&p_p_auth=kfSFicB8 generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      org.postgresql.util.PSQLException: ERROR: UNION types bigint and text cannot be matched_  Position: 348 [Sanitized]
              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
              at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305)
              at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
              at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
              at org.hibernate.loader.Loader.doQuery(Loader.java:802)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
              at org.hibernate.loader.Loader.doList(Loader.java:2542)
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
              at org.hibernate.loader.Loader.list(Loader.java:2271)
              at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
              at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
              at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
              at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:181)
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:172)
              at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:83)
      

      Reproduced on:
      Tomcat 8.0.32 + PostgreSQL 9.3.
      Portal ee-7.0.x GIT ID: aab533f621b448478dd3bea89165ce1ed4f56e7c
      Master GIT ID: 949ba040ae159219c998308c8fc772074b9d11a3

      Cannot be reproduced on:
      Tomcat 8.0.32 + MySQL 5.6.
      Master GIT ID: 949ba040ae159219c998308c8fc772074b9d11a3

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Days since last comment:
                2 years, 27 weeks, 5 days ago

                Packages

                Version Package