magento2 – The database from 2.2.7 to 2.3 can not be updated. The definition can not be processed to the matrix for the enum type.

Magento 2.2.7 to 2.3

It started in 2.2.3 and was updated incrementally through the command line.

Php 7.2 is enabled. It was not enabled until it was ready to update to 2.3 b / c. Support 7.1 ended in M2.3

SQL version: 10.1.36-MariaDB-cll-lve

Quick story

I tried using the web configuration to go from 2.2.3 to 2.3. Failed without error screen. Try it again. An error occurred (I guess after going through this it was related to php 7.2 and, honestly, the Web Configuration should not have allowed me the option to do it this way, CLI should be the only one) and provided the option to recoil, but at this point, I did not know what would happen, so I did not revert. I think this may be the source of my current database problems because it seems to be stuck between states, as between the structure of 2.2.x and 2.3.

The question:

I updated through CLI to 2.2.7 and everything worked fine, except that, as I noticed during the update, I could not back up the database because the "Area Code already exists". I had a previous backup, so I proceeded anyway. In too deep at this point.

Then I tried to update to 2.3 according to the instructions in Magento Dev Docs. I got to the end to rebuild the database through a command.

php bin / magento setup: update

Failed with the following error:

The definition can not be processed to the matrix for the enum type.

He did this through some of the file system cleanups, and then he launched that error. So, I turned off the maintenance mode to see what was happening. Effectively, the database was not updated. I thought it was because the modules in the report at the end of this message were outdated, so I turned off ALL the modules through CLI. Then I tried to update. Same message "Unable to process the definition to the matrix for the enum type".

At this point, I am perplexed and I really would not like to go back to the oldest db backup and lose some work if possible.

Does anyone have an idea of ​​how I can get this database to complete the update and be able to enjoy the relative happiness that Magento 2.3 should be? : smileylol:

Thanks in advance!

Kory

—– start the error report of the subsequent db update ——–

{"0": "Update your database: Run " bin / magento setup: upgrade "from the root directory of Magento. NThe following modules are outdated: nMSP_ReCaptcha schema: current version – none, required version – 1.5 .0 nMSP_ReCaptcha data: current version – none, required version – 1.5.0 nMSP_TwoFactorAuth schema: current version – none, required version – 2.2.0 nMSP_TwoFactorAuth data: current version – none, required version – 2.2.0 nAmazon_Core schema version – 2.1.2, version required – 3.0.0 nAmazon_Core data: current version – 2.1.2, required version – 3.0.0 nMagento_Inventory schema: current version – none, required version – 1.0.0 nMagento_Inventory data: current version – none, version required – 1.0.0 nMagento_InventoryAdminUi schema: current version – none, required version – 1.0.0 nMagento_InventoryAdminUi data: current version – none, required version – 1.0.0 nMagento_InventoryApi ski ema: current version – none, required version – 1.0.0 nMagento_InventoryApi data: current version – none, required version – 1.0.0 nMagento_InventoryBundleProduct schema: current version – none, required version – 1.0.0 nMagento_InventoryBundleProduct data: current version – none, version required – 1.0.0 nMagento_InventoryBundleProductAdminUi schema: current version – none, required version – 1.0.0 nMagento_InventoryBundleProductAdminUi data: current version – none, required version – 1.0.0 nMagento_InventoryCatalog schema: current version – none, required version – 1.0.0 nMagento_InventoryCatalog data: current version – none, required version – 1.0.0 nMagento_InventorySales team: current version – none, required version – 1.0.0 nMagento_Inventory Data sales: current version – none, required version – 1.0.0 nMagento_InventoryCatalogAdminUi current schema: none, required version – 1.0.0 nMagento _InventoryCatalogAdminUi data: version – none, required version – 1.0.0 nMagento_InventoryCatalogApi schema: current version – none, required version – 1.0.0 nMag ento_InventoryCatalogApi data: current version – none, required version – 1.0.0 nMagento_InventoryCatalogSearch schema: version current – none, required version – 1.0.0 nMagento_InventoryCatalogSearch data: current version – none, required version – 1.0.0 nMagento_InventoryProduct configuration – none, required version – 1.0.0 nMagento_InventoryConfigurableProduct data: current version – none, required version – 1.0.0 nMagento_InventoryConfigurableProductAdminUi schema: current version – none, required version – 1.0.0 nMagento_InventoryConfigurableProductAdminUi data: current version, none, version – 1.0.0 nMagento_InventoryConfigurableProductIndexer schema: current version – none, required version – 1.0.0 nMagento_InventoryConfigurableProductI ndexer data: current version – none, required version – 1.0.0 nMagento_InventoryConfiguration schema: current version – none, required version – 1.0.0 n nMagento_InventoryData configuration: current version – none, r version equired – 1.0.0 nMagento_InventoryConfigurationApi schema : current version – none, required version – 1.0.0 nMagento_InventoryConfigurationApi data: current version – none, required version – 1.0.0 nMagento_InventoryGroupedProduct schema: current version – none, required version – 1.0. 0 nMagento_InventoryGroupedData product: current version – none, required version – 1.0.0 nMagento_InventoryGroupedProductAdminUi scheme: current version – none, required version – 1.0.0 nMagento_InventoryGroupedProductAdminUi data: current version – none, required version – 1.0.0 & # 39; t current version – none, required version – 1.0.0 nMagento_InventoryGroupedProductIndexer data: current version – none, required version – 1.0.0 nMagento_InventoryImportExport schema: current version – none, required version – 1.0.0 nMagento_InventoryImportExport data: current version – none, version required – 1.0.0 nMagento_InventoryIndexer schema: current version – none, required version – 1.0.0 nMagento_InventoryIndexer data: current version – none, required version – 1.0.0 nMagento_InventoryLowQuantityNotification schema: current version – none, required version – 1.0.0 nMagento_InventoryLowQuantityNotification data: current version – none, required version – 1.0. 0 nMagento_InventoryLowQuantityNotificationAdminUi schema: current version – none, required version – 1.0.0 nMagento_InventoryLowQuantityNotificationAdminUiottailla of the person of the week of the person of the week of the person to whom attention is paid. current version – none, required version – 1.0.0 nMagento_InventoryMultiDimensionalIndexerApi schema: current version – none, required version – 1.0.0 nMagento_InventoryMultiDimensionalIndexerApi data: current version – none, required version – 1.0.0 nMagento_InventoryProductAlert schema version required – 1. 0.0 nMagento_InventoryProductAlert data: current version – none, required version – 1.0.0 nMagento_InventoryReservations schema: current version – none, required version – 1.0.0 nMagento_InventoryReservations data: current version – none, required version – 1.0.0 nMagento_InventoryReservationsTeam current version – none, required version – 1.0.0 nMagento_InventoryReservationsApi data: current version – none, required version – 1.0.0 nMagento_InventoryCache schema: current version – none, required version – 1.0.0 nMagento_InventoryCache data: current version – none required version – 1.0 .0 nMagento_InventorySa lesAdminUi schema: current version – none, required version – 1.0.0 nMagento_InventorySalesAdminUi data: current version – none, required version – 1.0.0 nMagento_InventorySalesApi schema: current version – none, required version – 1.0. 0 nMagento_InventorySalesApi data: current version – none, required version – 1.0.0 nMagento_InventoryShipping schema: current version – no, required version – 1.0.0 nMagento_InventoryShipping data: current version – none, required version – 1.0.0 nMagento_InventorySourceDeductionApi schema : current version – none, required version – 1.0.0 nMagento_InventorySourceDeductionApi data: current version – none, required version – 1.0.0 nMagento_InventorySourceSelection schema: current version – none, required version – 1.0.0 nMagento_InventorySourceSelection data: current version – none , version required – 1.0.0 nMagento_InventorySourceSelectionApi schema: current version – none, required version – 1.0.0 nMagento_Inventory_Inventory data: current version – none, required version – 1.0.0 nKlarna_Core schema: current version – 4.5.2, required version – 5.0.0 nKlarna_Core data: current version – 4.5.2, required version – 5.0 .0 nMazon_Login schema: current version – 2.1.1, required version – 3.0.0 nAnimal_Login data: current version – 2.1.1, required version – 3.0.0 n Payment schema_Amazon: current version – 2.1.1, requires d version – 3.0.0 nAnimal_Payment data: current version – 2.1.1, required version – 3.0.0 nKlarna_Ordermanagement schema: current version – 4.4.1, required version – 5.0.2 nKlarna_Ordermanagement data: current version – 4.4.1 , version required – 5.0.2 nMagento_InventoryShippingAdminUi schema: current version – none, required version – 1.0.0 nMagento_InventoryShippingAdminUi data: current version – none, required version – 1.0.0 nKlarna_Kp schema: current version – 5.5.1, required version – 6.0.0 nKlarna_Kp data: current version – 5.5.1, required version – 6.0.0 nDotdigitalgroup_Email schema: current version – 2.6.1, required version – 3.0.1 nDotdigitalgroup_Email data: current version – 2.6.1, required version – 3.0.1 nEsq Shipment of shipments: current version – 1.2.1, version required – 1.4.0 nShipping data: current version – 1.2.1, required version – 1.4.0 "," 1 ":" # 0 / home /stebbins/public_html/vendor/magento/framework/Interception/Interceptor.php(121): Magento Framework Module P lugin DbStatusValidator-> beforeDispatch (Object (Magento Framework App FrontController Interceptor), Object (Magento Framework App Request Http)) n # 1 / home / stebbins / public_html / vendor / magento / module-page-cache / Model / App / FrontController / BuiltinPlugin.php (73): Magento Framework App FrontController Interceptor-> Magento Framework Interception {closing} (Object (Magento Framework App Request Http)) n # 2 /home/stebbins/public_html/vendor/magento/framework/Interception/Interceptor.php (135): Magento PageCache Model App FrontController BuiltinPlugin-> aroundDispatch (Object (Magento Framework App FrontController Int erceptor), Object (Closure), Object (Magento Framework App Request Http)) n # 3 /home/stebbins/public_html/vendor/magento/framework/Interception/Interceptor.php(153): Magento Framework App FrontController Interceptor-> Magento Framework Interception {closing} (Object (Magento Framework App Request Http)) n # 4 / home / stebbins / public_html / generate / code / Magento / Framework / App / FrontController / Interceptor. php (26): Magento Framework App FrontController Interceptor -> ___ callPlugins (& # 39; dispatch & # 39 ;, Array, Array) n # 5 / home / stebbins / public_html / vendor / magento / framework / App /Http.php(135): Magento Framework App FrontController Interceptor-> dispatch (Object (Magento Framework App Request Http)) n # 6 / home / stebbins / public_html / generic / code / Magento / Framework / App / Http /Interceptor.php(24): Magento Framework App Http-> launch () n # 7 /home/stebbins/public_html/vendor/magento/framework/App/Bootstrap.php(258 ): Magento Framework App Http Interceptor-> launch () n # 8 /home/stebbins/public_html/index.php(39): Magento Framework App Bootstrap-> run (Object (Magento Framework App Http Interceptor)) n # 9 {main} "," url ":" / "," script_name ":" / index.php "}