-
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
-
Fix Priority:4
-
Databases:PostgreSQL 9.3
Steps to reproduce:
- Start portal
- 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