email logs SMTP - Base table or view not found

Question

I have installed extension SMTP from Mageplaza https://www.mageplaza.com/magento-2-smtp/

In the "logs" panel I should have all messages sent as in the screenshot below.

But in my magento I have error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'b2b_style.mageplaza_smtp_log' doesn't exist, query was: SELECT COUNT(*) FROM `mageplaza_smtp_log` AS `main_table`

Anyone know how to solve it?

Answer 1

This issue might be because of something happens wrong while installing this extension. Or setup script has something wrong. So Open table setup_resource and find module for Mageplaza_Smtp, delete that row and try running commands:

PHP bin/magento setup:upgrade

It will create table. Please put die Inside setup script to debug.

Answer 2

Do setup:upgrade and cache clean / flush.
If that wont work check version of module in module and check module version in database (table setup_resource and look for Mageplaza_Smtp module).
If version is the same and mageplaza_smtp_log table is not exist in DB, then try to uninstall module (using Uninstall Script).

Otherwise try to recognize where exactly in Setup/Install.php or Upgrade.php file in module is script creating this table and revert module version id DB to this version - then use again setup:upgrade and clear cache or just run script creating table manually.

Answer 3

You might want to try

composer update
bin/magento setup:upgrade
bin/magento cache:clean