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

PostgreSQL 8.4 does not handle well negative integer comparisons

    Details

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

      Description

      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)
      .....

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  8 years, 37 weeks, 4 days ago

                  Packages

                  Version Package
                  --Sprint - SP
                  6.0.6 GA
                  6.1.0 CE RC1