I have upgrade magento version from 2.1.14 to 2.2.0.
First time when i run run php bin/magento setup:upgrade
command it gives this error:
Module 'Magento_TaxImportExport':
Module 'Magento_BundleStaging':
Upgrading schema.. SQLSTATE[HY000]: General error: 1025 Error on rename of './databasem2/#sql-3b4_94f' to './databasem2/catalog_product_bundle_selection' (errno: 150 - Foreign key constraint is incorrectly formed)
Now every time upgrade command gives this error:
Module 'Magento_TaxImportExport':
Module 'Magento_BundleStaging':
Upgrading schema.. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sequence_product_bundle_option' already exists, query was: CREATE TABLE sequence_product_bundle_option (
sequence_value integer UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (sequence_value)
) AUTO_INCREMENT = 0 ENGINE = INNODB
I have try to remove tables but it gives same error.
I have read this link1 and link2 but still not working for me.
Any help will be appreciated, Thanks in advanced.