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

    • Type: Bug
    • Status: Closed
    • Resolution: Won't Fix
    • Affects Version/s: 6.1.10 EE GA1
    • Fix Version/s: 6.1.X EE
    • Component/s: Core Infrastructure
    • Labels:
    • Environment:
      Win7, Tomcat 7.0.25, Mysql 5.5.20, Liferay 6.1.10 EE with liferay-fix-pack-upgrade-3-6110

      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:
            Marta Elicegui
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              9 years, 23 weeks, 4 days ago

                Packages

                Version Package
                6.1.X EE