Magento 2 Upgrade Error SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘magento2.email_abandoned_cart’ doesn’t exist.

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.