email logs SMTP - Base table or view not foundSMTP & Email Sending ErrorsINSERT ON DUPLICATE KEY UPDATE...

Why is the 'in' operator throwing an error with a string literal instead of logging false?

In Romance of the Three Kingdoms why do people still use bamboo sticks when paper had already been invented?

Why "Having chlorophyll without photosynthesis is actually very dangerous" and "like living with a bomb"?

Where does SFDX store details about scratch orgs?

Fully-Firstable Anagram Sets

Western buddy movie with a supernatural twist where a woman turns into an eagle at the end

Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?

Can one be a co-translator of a book, if he does not know the language that the book is translated into?

Today is the Center

Were any external disk drives stacked vertically?

Is the Joker left-handed?

How can I tell someone that I want to be his or her friend?

How could indestructible materials be used in power generation?

Reserved de-dupe rules

AES: Why is it a good practice to use only the first 16bytes of a hash for encryption?

Is "remove commented out code" correct English?

Has there ever been an airliner design involving reducing generator load by installing solar panels?

How can I fix/modify my tub/shower combo so the water comes out of the showerhead?

Forgetting the musical notes while performing in concert

How can I make my BBEG immortal short of making them a Lich or Vampire?

Why can't we play rap on piano?

When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?

Why do I get two different answers for this counting problem?

Is there a hemisphere-neutral way of specifying a season?



email logs SMTP - Base table or view not found


SMTP & Email Sending ErrorsINSERT ON DUPLICATE KEY UPDATE Magento2 ErrorError when creating category programmaticallyMagento 2 Integration test can't run - store_website doesn't existMagento 2:SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguousSQLSTATE[42S02]: Base table or view not found: design_config_grid_flatMagento 2 smtp could not open socketError during SMTP installationno extension after installationBase table or view not found: 1146 Table 'demo.ves_brand_group' doesn't exist, query was: TRUNCATE `ves_brand_group`






.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 5 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 5 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 5 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 5 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

                                “%fieldName is a required field.”, in Magento2 REST API Call for GET Method Type The Next...

                                How to change City field to a dropdown in Checkout step Magento 2Magento 2 : How to change UI field(s)...

                                夢乃愛華...