email logs SMTP - Base table or view not found





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







0















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?










share|improve this question














bumped to the homepage by Community 10 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
















  • setup:upgrade + cache:clean ?

    – vitoriodachef
    Jan 26 '18 at 10:18




















0















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?










share|improve this question














bumped to the homepage by Community 10 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
















  • setup:upgrade + cache:clean ?

    – vitoriodachef
    Jan 26 '18 at 10:18
















0












0








0








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?










share|improve this 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.
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?







magento-2.1 smtp






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Jan 26 '18 at 9:49









SylvesterSylvester

746316




746316





bumped to the homepage by Community 10 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







bumped to the homepage by Community 10 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.















  • setup:upgrade + cache:clean ?

    – vitoriodachef
    Jan 26 '18 at 10:18





















  • setup:upgrade + cache:clean ?

    – vitoriodachef
    Jan 26 '18 at 10:18



















setup:upgrade + cache:clean ?

– vitoriodachef
Jan 26 '18 at 10:18







setup:upgrade + cache:clean ?

– vitoriodachef
Jan 26 '18 at 10:18












3 Answers
3






active

oldest

votes


















0














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.






share|improve this answer































    0














    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.






    share|improve this answer































      0














      You might want to try



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





      share|improve this answer
























        Your Answer








        StackExchange.ready(function() {
        var channelOptions = {
        tags: "".split(" "),
        id: "479"
        };
        initTagRenderer("".split(" "), "".split(" "), channelOptions);

        StackExchange.using("externalEditor", function() {
        // Have to fire editor after snippets, if snippets enabled
        if (StackExchange.settings.snippets.snippetsEnabled) {
        StackExchange.using("snippets", function() {
        createEditor();
        });
        }
        else {
        createEditor();
        }
        });

        function createEditor() {
        StackExchange.prepareEditor({
        heartbeatType: 'answer',
        autoActivateHeartbeat: false,
        convertImagesToLinks: false,
        noModals: true,
        showLowRepImageUploadWarning: true,
        reputationToPostImages: null,
        bindNavPrevention: true,
        postfix: "",
        imageUploader: {
        brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
        contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
        allowUrls: true
        },
        onDemand: true,
        discardSelector: ".discard-answer"
        ,immediatelyShowMarkdownHelp:true
        });


        }
        });














        draft saved

        draft discarded


















        StackExchange.ready(
        function () {
        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f211100%2femail-logs-smtp-base-table-or-view-not-found%23new-answer', 'question_page');
        }
        );

        Post as a guest















        Required, but never shown

























        3 Answers
        3






        active

        oldest

        votes








        3 Answers
        3






        active

        oldest

        votes









        active

        oldest

        votes






        active

        oldest

        votes









        0














        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.






        share|improve this answer




























          0














          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.






          share|improve this answer


























            0












            0








            0







            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.






            share|improve this answer













            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.







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Jan 26 '18 at 10:39









            Kumar MKumar M

            69946




            69946

























                0














                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.






                share|improve this answer




























                  0














                  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.






                  share|improve this answer


























                    0












                    0








                    0







                    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.






                    share|improve this answer













                    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.







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Jan 26 '18 at 10:41









                    Konrad SiamroKonrad Siamro

                    936622




                    936622























                        0














                        You might want to try



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





                        share|improve this answer




























                          0














                          You might want to try



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





                          share|improve this answer


























                            0












                            0








                            0







                            You might want to try



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





                            share|improve this answer













                            You might want to try



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






                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered Oct 11 '18 at 18:39









                            TheRealJAGTheRealJAG

                            1698




                            1698






























                                draft saved

                                draft discarded




















































                                Thanks for contributing an answer to Magento Stack Exchange!


                                • Please be sure to answer the question. Provide details and share your research!

                                But avoid



                                • Asking for help, clarification, or responding to other answers.

                                • Making statements based on opinion; back them up with references or personal experience.


                                To learn more, see our tips on writing great answers.




                                draft saved


                                draft discarded














                                StackExchange.ready(
                                function () {
                                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f211100%2femail-logs-smtp-base-table-or-view-not-found%23new-answer', 'question_page');
                                }
                                );

                                Post as a guest















                                Required, but never shown





















































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown

































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown







                                Popular posts from this blog

                                What other Star Trek series did the main TNG cast show up in?

                                Berlina muro

                                Berlina aerponto