When you upgrade Magento version 2.2.2 to 2.3.3, once upgrade is finish and you are trying to run the setup upgrade command, You faced the error at a time of upgrade command,
Upgrading schema.. SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mage222ce.email_abandoned_cart’ doesn’t exist, query was: DESCRIBE `email_abandoned_cart`
Without Resolved above error, You can’t able to access your front or backend panel.
The cause of the error is that, When you have installed Magento 2.2.2 Version, the Dotdigitalgroup_Email extension version was 2.3.8 and in the latest version of Magento 2.3.3, Dotdigitalgroup module version is 3.3.0.
Version conflict the upgrade error when you run command,
php bin/magento setup:upgrade
Solution:
First Approach:
1) If you haven’t use Dotdigitalgroup module, just disable it from the config.php file with, ‘Dotdigitalgroup_Email’ => 0 and ‘Dotdigitalgroup_Chat’ => 0
Second Approach:
2) You can manually upgrade the database table, setup_module
with a record, Dotdigitalgroup_Email change schema_version and data_version to 3.3.0 Or run SQL query to upgrade entry.
You can check the latest version of the Dotdigitalgroup_Email from the vendor/dotmailer/dotmailer-magento2-extension/etc/module.xml
Get The setup_version name from the XML file, <module name=”Dotdigitalgroup_Email” setup_version=”3.3.0″>
Use setup_version and replace it with setup_module table entry.