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

VerifyLayout fails on PostgreSQL and portal unable to start

    Details

      Description

      Start the portal with an empty PostgreSQL database and you'll experience the following error. (See the attached log for more details).

      Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer_  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts._  Position: 112 [Sanitized]
      	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
      	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
      	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
      	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:208)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:288)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:310)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:302)
      	at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:36)
      	at com.liferay.portal.verify.VerifyLayout.verifyLayoutPrototypeLinkEnabled(VerifyLayout.java:101)
      	at com.liferay.portal.verify.VerifyLayout.doVerify(VerifyLayout.java:77)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:58)
      	... 30 more
      Stopping the server due to unexpected startup errors
      

        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:
                  5 years, 18 weeks, 4 days ago

                  Packages

                  Version Package
                  7.0.0 M1