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

Upgrade from 5.1.7 to 6.1.10 fails due to missing update-5.1.7-5.2.7.sql

    Details

      Description

      The UpgradeSchema process fails as it can't find the required update sql file.

      06:41:47,263 INFO  [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_5_1_7_to_5_2_7
      06:41:47,265 INFO  [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v5_1_7_to_5_2_7.UpgradeSchema
      06:41:47,267 ERROR [BaseDB:270] Invalid path update-5.1.7-5.2.7.sql
      06:41:47,269 INFO  [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v5_2_0.UpgradeExpando
      06:41:47,281 ERROR [MainServlet:201] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.ke
      rnel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'companyId' in 'field list'
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.my
      sql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'companyId' in 'field list'
      ...
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'companyId' in 'field list'
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.Util.getInstance(Util.java:386)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1749)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1666)
              at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
              at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:222)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:242)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:235)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.runSQL(UpgradeProcess.java:117)
              at com.liferay.portal.upgrade.v5_2_0.UpgradeExpando.doUpgrade(UpgradeExpando.java:35)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
              ... 32 more
      

        Attachments

          Activity

            People

            • Assignee:
              michael.saechang Michael Saechang
              Reporter:
              cbrien Chris Brien (Inactive)
              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:
                7 years, 16 weeks ago

                Packages

                Version Package
                6.1.X EE