Upgrade to 4.1.0 from 4.0.2 fails for deployments using MySQL

XMLWordPrintable

      When upgrading a 4.0.2 deployment of Registry using MySQL 5.7.12 to version 4.1.0 the upgradeVersion command fails with

      Adding default duplicate_mode for EnvSource
      Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'EnvSource.duplicate_mode' in 'field list'
      #0 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(502): PDOStatement->execute()
      #1 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(468): DboSource->_execute()
      #2 /srv/comanage-registry/lib/Cake/Model/Datasource/Database/Mysql.php(425): DboSource->execute()
      #3 /srv/comanage-registry/lib/Cake/Model/Model.php(2672): Mysql->update()
      #4 /srv/comanage-registry/app/Console/Command/UpgradeVersionShell.php(615): Model->updateAll()
      #5 /srv/comanage-registry/app/Console/Command/UpgradeVersionShell.php(296): UpgradeVersionShell->post410()
      #6 /srv/comanage-registry/lib/Cake/Console/Shell.php(464): UpgradeVersionShell->main()
      #7 /srv/comanage-registry/lib/Cake/Console/ShellDispatcher.php(222): Shell->runCommand()
      #8 /srv/comanage-registry/lib/Cake/Console/ShellDispatcher.php(66): ShellDispatcher->dispatch()
      #9 /srv/comanage-registry/app/Console/cake.php(41): ShellDispatcher::run()
      #10 {main} 

      Inspecting the table cm_env_sources shows that despite the equivalent of ./Console/cake database being run and it logging that the EnvSource plugin has been processed, the column duplicate_mode has not been added to the table.

      Subsequent runs of ./Console/cake database that also log that the EnvSource plugin has been processed do NOT add the column to the database.

            Assignee:
            Arlen Johnson
            Reporter:
            Scott Koranda
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: