-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 5.2.3, 6.0.5 GA
-
Fix Version/s: --Sprint - SP, 6.0.6 GA, 6.1.0 CE RC1
-
Component/s: Environments > Databases, Message Boards
-
Labels:None
-
Environment:Postgresql 8.4
-
Branch Version/s:6.0.x, 5.2.x
-
Backported to Branch:Committed
When trying to publish a MB message, portlet becomes temporarily unavailable and log shows:
11:20:04,109 ERROR [JDBCExceptionReporter:234] ERROR: operator does not exist: bigint !=- integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type cast
Position: 144
11:20:04,288 ERROR [render_portlet_jsp:154] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:190)
at com.liferay.portlet.messageboards.service.persistence.MBMessagePersistenceImpl.countByG_U(MBMessagePersistenceImpl.java:9750)
at com.liferay.portlet.messageboards.service.impl.MBStatsUserLocalServiceImpl.updateStatsUser(MBStatsUserLocalServiceImpl.java:133)
.....
- relates
-
LPE-4342 PostgreSQL has problems with negative integer comparisons
-
- Closed
-