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

Upgrade to 7.0.1 column appimpl0_.title does not exist

    Details

    • OS:
      Windows 10
    • JDK:
      Oracle Sun JDK 8
    • Application Servers:
      Apache Tomcat 8.0.x
    • Databases:
      PostgreSQL 9.4

      Description

      Upgrading database from 6.1.1 to 7.0.1

      00:41:19,934 INFO  [main][ServiceComponentLocalServiceImpl:355] Upgrading database with indexes.sql
      00:41:20,094 ERROR [main][JDBCExceptionReporter:234] ERROR: column appimpl0_.title does not exist_  Position: 298 [Sanitized]
      00:41:20,131 ERROR [main][com_liferay_marketplace_service:97] [com.liferay.marketplace.lpkg.deployer.LPKGDeployerRegistrar(2333)] The activate method has thrown an exception 
      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.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:267)
      

      Full details in attached log.

      When starting instance after migration receive

      14:51:34,894 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ERROR: column appimpl0_.title does not exist_  Position: 298 [Sanitized]
      14:51:34,927 ERROR [localhost-startStop-1][com_liferay_marketplace_service:97] [com.liferay.marketplace.lpkg.deployer.LPKGDeployerRegistrar(2333)] The activate method has thrown an exception 
      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.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:267){
          return foo;
      }
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                brian.lee Brian Lee
                Reporter:
                phancox Peter Hancox
                Participants of an Issue:
                Recent user:
                Brian Wulbern
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 27 weeks, 3 days ago

                  Packages

                  Version Package
                  7.0.X EE
                  Master