Restore database problems












0














I have restored a backup of the DB back into the Akeneo PIM DB but it is now not showing me any products within the system.



The DB is connecting properly ie I can log in and the category tree is available, attribute lists etc but my products (500~) are not available in the Akeneo environment (0 products). The data IS in the DB - I can query and view etc directly through SQL.



Anybody have any ideas? What have I missed?










share|improve this question



























    0














    I have restored a backup of the DB back into the Akeneo PIM DB but it is now not showing me any products within the system.



    The DB is connecting properly ie I can log in and the category tree is available, attribute lists etc but my products (500~) are not available in the Akeneo environment (0 products). The data IS in the DB - I can query and view etc directly through SQL.



    Anybody have any ideas? What have I missed?










    share|improve this question

























      0












      0








      0







      I have restored a backup of the DB back into the Akeneo PIM DB but it is now not showing me any products within the system.



      The DB is connecting properly ie I can log in and the category tree is available, attribute lists etc but my products (500~) are not available in the Akeneo environment (0 products). The data IS in the DB - I can query and view etc directly through SQL.



      Anybody have any ideas? What have I missed?










      share|improve this question













      I have restored a backup of the DB back into the Akeneo PIM DB but it is now not showing me any products within the system.



      The DB is connecting properly ie I can log in and the category tree is available, attribute lists etc but my products (500~) are not available in the Akeneo environment (0 products). The data IS in the DB - I can query and view etc directly through SQL.



      Anybody have any ideas? What have I missed?







      akeneo






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 12 at 17:51









      user3141626

      365




      365
























          1 Answer
          1






          active

          oldest

          votes


















          0














          Just got an answer from @gplanchat on the Akeneo Slack list with the solution.
          I needed to reindex my catalog - something I haven't seen reference to in the documentation. FOr others, this is what is needed:



          bin/console akeneo:elasticsearch:reset-indexes --env=prod
          bin/console pim:product:index --all --env=prod
          bin/console pim:product-model:index --all --env=prod


          Thanks to @gplanchat






          share|improve this answer





















            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            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: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            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%2fstackoverflow.com%2fquestions%2f53267543%2frestore-database-problems%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            Just got an answer from @gplanchat on the Akeneo Slack list with the solution.
            I needed to reindex my catalog - something I haven't seen reference to in the documentation. FOr others, this is what is needed:



            bin/console akeneo:elasticsearch:reset-indexes --env=prod
            bin/console pim:product:index --all --env=prod
            bin/console pim:product-model:index --all --env=prod


            Thanks to @gplanchat






            share|improve this answer


























              0














              Just got an answer from @gplanchat on the Akeneo Slack list with the solution.
              I needed to reindex my catalog - something I haven't seen reference to in the documentation. FOr others, this is what is needed:



              bin/console akeneo:elasticsearch:reset-indexes --env=prod
              bin/console pim:product:index --all --env=prod
              bin/console pim:product-model:index --all --env=prod


              Thanks to @gplanchat






              share|improve this answer
























                0












                0








                0






                Just got an answer from @gplanchat on the Akeneo Slack list with the solution.
                I needed to reindex my catalog - something I haven't seen reference to in the documentation. FOr others, this is what is needed:



                bin/console akeneo:elasticsearch:reset-indexes --env=prod
                bin/console pim:product:index --all --env=prod
                bin/console pim:product-model:index --all --env=prod


                Thanks to @gplanchat






                share|improve this answer












                Just got an answer from @gplanchat on the Akeneo Slack list with the solution.
                I needed to reindex my catalog - something I haven't seen reference to in the documentation. FOr others, this is what is needed:



                bin/console akeneo:elasticsearch:reset-indexes --env=prod
                bin/console pim:product:index --all --env=prod
                bin/console pim:product-model:index --all --env=prod


                Thanks to @gplanchat







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 12 at 17:56









                user3141626

                365




                365






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


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





                    Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                    Please pay close attention to the following guidance:


                    • 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%2fstackoverflow.com%2fquestions%2f53267543%2frestore-database-problems%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

                    Xamarin.iOS Cant Deploy on Iphone

                    Glorious Revolution

                    Dulmage-Mendelsohn matrix decomposition in Python