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. enter image description here

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`

enter image description here

Anyone know how to solve it?

  • setup:upgrade + cache:clean ? – vitoriodachef Jan 26 '18 at 10:18

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.


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.


You might want to try

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.