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

6.1.2 to 7.0 upgrade throws 'Unknown column 'appimpl0_.title' in 'field list'' errors

    Details

      Description

      Upgrading from 6.1.2 to 7.0 GA1 throws the following errors on startup:

      During upgrade

       [java] INFO - Completed upgrade process com.liferay.marketplace.upgrade.v1_0_0.UpgradeModule in 2ms
           [java] 18:23:10,771 INFO  [main][UpgradeProcess:82] Upgrading com.liferay.marketplace.upgrade.v1_0_0.UpgradeCompanyId
           [java] INFO - Upgrading com.liferay.marketplace.upgrade.v1_0_0.UpgradeCompanyId
           [java] 18:23:10,772 INFO  [pool-13-thread-1][LoggingTimer:70] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Marketplace_Module
           [java] 18:23:10,772 INFO  [pool-13-thread-1][UpgradeCompanyId:103] Adding column companyId to table Marketplace_Module
           [java] 18:23:10,855 INFO  [pool-13-thread-1][LoggingTimer:38] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Marketplace_Module in 83 ms
           [java] 18:23:10,855 INFO  [main][UpgradeProcess:97] Completed upgrade process com.liferay.marketplace.upgrade.v1_0_0.UpgradeCompanyId in 84ms
           [java] INFO - Completed upgrade process com.liferay.marketplace.upgrade.v1_0_0.UpgradeCompanyId in 84ms
           [java] 18:23:11,027 INFO  [main][ServiceComponentLocalServiceImpl:295] Upgrading Marketplace database to build number 5
           [java] 18:23:11,028 INFO  [main][ServiceComponentLocalServiceImpl:302] Upgrading database with tables.sql
           [java] 18:23:11,029 INFO  [main][ServiceComponentLocalServiceImpl:350] No optional file META-INF/portlet-model-hints-ext.xml found
           [java] 18:23:11,030 INFO  [main][ServiceComponentLocalServiceImpl:324] Upgrading database with indexes.sql
           [java] 18:23:11,148 INFO  [main][UpgradeProcess:82] Upgrading com.liferay.wiki.upgrade.v1_0_0.UpgradeSchema
           [java] INFO - Upgrading com.liferay.wiki.upgrade.v1_0_0.UpgradeSchema
           [java] 18:23:11,149 INFO  [main][LoggingTimer:70] Starting com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString
           [java] INFO - Starting com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString
           [java] 18:23:11,176 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [java] 18:23:11,179 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Liferay Forms and Workflow CE_1.3.0 [480]
           [java] 18:23:11,181 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Liferay Forms and Workflow CE_1.3.0 [480]
           [java] 18:23:11,184 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [java] 18:23:11,185 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Liferay Web Experience CE_1.3.0 [479]
           [java] 18:23:11,187 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Liferay Web Experience CE_1.3.0 [479]
           [java] 18:23:11,189 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [java] 18:23:11,191 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Marketplace_4.0.0 [476]
           [java] 18:23:11,192 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Marketplace_4.0.0 [476]
           [java] 18:23:11,195 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [java] 18:23:11,197 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Liferay Foundation CE_1.3.0 [478]
           [java] 18:23:11,199 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Liferay Foundation CE_1.3.0 [478]
           [java] 18:23:11,201 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [java] 18:23:11,203 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Liferay Collaboration CE_1.0.0 [477]
           [java] 18:23:11,204 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Liferay Collaboration CE_1.0.0 [477]
           [java] 18:23:11,215 INFO  [main][LoggingTimer:38] Completed com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString in 66 ms
      

      During startup

         [exec] 
           [exec]     __    ____________________  _____  __
           [exec]    / /   /  _/ ____/ ____/ __ \/   \ \/ /
           [exec]   / /    / // /_  / __/ / /_/ / /| |\  /
           [exec]  / /____/ // __/ / /___/ _, _/ ___ |/ /
           [exec] /_____/___/_/   /_____/_/ |_/_/  |_/_/
           [exec] 
           [exec] Starting Liferay Portal Community Edition 7.0.0 CE GA1 (Wilberforce / Build 7000 / March 31, 2016)
           [exec] 
           [exec] 18:25:14,722 INFO  [localhost-startStop-1][StartupAction:110] There are no patches installed
           [exec] 18:25:14,787 INFO  [localhost-startStop-1][BaseDB:501] Database does not support case sensitive queries
           [exec] 18:25:15,181 INFO  [localhost-startStop-1][ServerDetector:154] Server supports hot deploy
           [exec] 18:25:15,186 INFO  [localhost-startStop-1][PluginPackageUtil:1003] Reading plugin package for the root context
           [exec] 18:25:16,197 INFO  [localhost-startStop-1][AutoDeployDir:183] Auto deploy scanner started for /opt/dev/projects/github/liferay-portal/bundles/deploy
           [exec] 18:25:17,401 INFO  [elasticsearch[Sunstreak][clusterService#updateTask][T#1]][metadata:391] [Sunstreak] [liferay-10154] creating index, cause [api], templates [], shards [1]/[0], mappings [LiferayDocumentType, KeywordQueryDocumentType, SpellCheckDocumentType]
           [exec] 18:25:17,452 INFO  [elasticsearch[Sunstreak][clusterService#updateTask][T#1]][allocation:238] [Sunstreak] Cluster health status changed from [RED] to [GREEN] (reason: [shards started [[liferay-10154][0]] ...]).
           [exec] 18:25:17,462 INFO  [elasticsearch[Sunstreak][clusterService#updateTask][T#1]][metadata:317] [Sunstreak] [liferay-10154] update_mapping [LiferayDocumentType]
           [exec] 18:25:19,656 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [exec] 18:25:19,661 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Liferay Web Experience CE_1.3.0 [484]
           [exec] 18:25:19,664 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Liferay Web Experience CE_1.3.0 [484]
           [exec] 18:25:19,667 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [exec] 18:25:19,669 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Liferay Collaboration CE_1.0.0 [482]
           [exec] 18:25:19,670 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Liferay Collaboration CE_1.0.0 [482]
           [exec] 18:25:19,673 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [exec] 18:25:19,675 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Liferay Forms and Workflow CE_1.3.0 [485]
           [exec] 18:25:19,677 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Liferay Forms and Workflow CE_1.3.0 [485]
           [exec] 18:25:19,679 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [exec] 18:25:19,682 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Marketplace_4.0.0 [481]
           [exec] 18:25:19,683 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Marketplace_4.0.0 [481]
           [exec] 18:25:19,686 ERROR [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][JDBCExceptionReporter:234] Unknown column 'appimpl0_.title' in 'field list'
           [exec] 18:25:19,688 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:38] STOPPED Liferay Foundation CE_1.3.0 [483]
           [exec] 18:25:19,690 INFO  [fileinstall-/opt/dev/projects/github/liferay-portal/bundles/osgi/marketplace][BundleStartStopLogger:35] STARTED Liferay Foundation CE_1.3.0 [483]
           [exec] 18:25:21,491 INFO  [elasticsearch[Sunstreak][clusterService#updateTask][T#1]][metadata:317] [Sunstreak] [liferay-10154] update_mapping [LiferayDocumentType]
           [exec] 18:25:21,538 INFO  [elasticsearch[Sunstreak][clusterService#updateTask][T#1]][metadata:317] [Sunstreak] [liferay-10154] update_mapping [LiferayDocumentType]
           [exec] 18:25:21,565 INFO  [elasticsearch[Sunstreak][clusterService#updateTask][T#1]][metadata:317] 
      

        Attachments

          Activity

            People

            • Assignee:
              albert.lee Albert Lee
              Reporter:
              albert.lee Albert Lee
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

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

                Packages

                Version Package
                7.0.1 CE GA2