The commit «PCF: removing grouped price» from 2015-10-02 breaks Magento schema upgrading with the exception: «there can be only one auto column and it must be defined as a key»

dmitrii_fediuk · October 2, 2015, 4:54pm

The exception after bin/magento setup:upgrade:

SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

The problem commit is MAGETWO-42501: PCF: removing grouped price · magento/magento2@da6d8a7 · GitHub

The problem line is:

github.com

magento/magento2/blob/12955b1c7e43c560dc1060c136858531d403c682/app/code/Magento/Catalog/Setup/UpgradeSchema.php#L197


      
          );
          $setup->getConnection()->dropForeignKey(
              $setup->getTable(Media::GALLERY_VALUE_TABLE),
              $setup->getFkName(
                  Media::GALLERY_VALUE_TABLE,
                  'store_id',
                  'store',
                  'store_id'
              )
          );
          $setup->getConnection()->dropIndex($setup->getTable(Media::GALLERY_VALUE_TABLE), 'primary');
          $setup->getConnection()->addColumn(
              $setup->getTable(Media::GALLERY_VALUE_TABLE),
              'record_id',
              [
                  'type' => \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
                  'primary' => true,
                  'auto_increment' => true,
                  'unsigned' => true,
                  'nullable' => false,
                  'comment' => 'Record Id'

GitHub issue 2007

dmitrii_fediuk · October 2, 2015, 5:08pm

My fix is to add the following code just before the problem line:

$setup->getConnection()->dropColumn($setup->getTable(Media::GALLERY_VALUE_TABLE), 'record_id');