Quote with no items - add to cart error Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?adding attributes to quote items via configPossible Bug - Hidden tax amount on quote and order item but no discount amountproblem unsetting quote (cart), data is not savedProgrammatically add items to cart and assign to guest userMagento 2 Rest API - How to add custom option to Cart Item?Why are quotes not converted to is_active=0 after checkout? M1/M2How to get the order items and quote items whenever create order from admin panel?Convert MagentoQuoteModelQuote to MagentoSalesModelOrder: Magento 2Adding products to cart programmatically with custom price in controller: Magento 2Request for quote and checkout at same time

Circuit to "zoom in" on mV fluctuations of a DC signal?

Using audio cues to encourage good posture

Amount of permutations on an NxNxN Rubik's Cube

Integration Help

Why do the resolve message appear first?

Why are there no cargo aircraft with "flying wing" design?

How come Sam didn't become Lord of Horn Hill?

Should I use a zero-interest credit card for a large one-time purchase?

Why do we bend a book to keep it straight?

Is "Reachable Object" really an NP-complete problem?

When the Haste spell ends on a creature, do attackers have advantage against that creature?

Do I really need recursive chmod to restrict access to a folder?

Is it fair for a professor to grade us on the possession of past papers?

8 Prisoners wearing hats

What do you call the main part of a joke?

How to tell that you are a giant?

Why wasn't DOSKEY integrated with COMMAND.COM?

Do I really need to have a message in a novel to appeal to readers?

What is the meaning of the simile “quick as silk”?

How can I use the Python library networkx from Mathematica?

Can a party unilaterally change candidates in preparation for a General election?

Can you use the Shield Master feat to shove someone before you make an attack by using a Readied action?

For a new assistant professor in CS, how to build/manage a publication pipeline

Dating a Former Employee



Quote with no items - add to cart error



Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?adding attributes to quote items via configPossible Bug - Hidden tax amount on quote and order item but no discount amountproblem unsetting quote (cart), data is not savedProgrammatically add items to cart and assign to guest userMagento 2 Rest API - How to add custom option to Cart Item?Why are quotes not converted to is_active=0 after checkout? M1/M2How to get the order items and quote items whenever create order from admin panel?Convert MagentoQuoteModelQuote to MagentoSalesModelOrder: Magento 2Adding products to cart programmatically with custom price in controller: Magento 2Request for quote and checkout at same time



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








2















I'm facing this strange issue on add to cart action:



sometime after I checkout (with a registered customer) correctly my order, if I try to purchase another item I got the following error:
Call to a member function setFinalPrice() on a non-object in app/code/core/Mage/Sales/Model/Quote/Item/Abstract.php on line 73



I have debugged the code and found out that the issue is created by some old quotes associated to my user that are still active and have not items associated with it.



If I check the problematic quote in the Db it has items_count = 0 any way Mage_Sales_Model_Resource_Quote_Item_Collection::_assignProducts()method try to load an item using null as Id :



 $product = $productCollection->getItemById($item->getProductId());


This trigger the above error.



Now the fast fix it to set to is_active = 0 in all these quote, something like:



 UPDATE `sales_flat_quote` SET `is_active` = 0 WHERE `is_active` = 1 AND `items_count`= 0 and customer_id is not null and customer_id <> 0


Question



Anyway I would like to understand the following points:



  1. Is it normal to have old quotes (also multiple for same user) with 0 items and is_active = 1 ?

  2. Is ok to delete all these quotes ? ( I have 10000+ quotes like this )

Any suggestion is welcome










share|improve this question














bumped to the homepage by Community 14 mins ago


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





















    2















    I'm facing this strange issue on add to cart action:



    sometime after I checkout (with a registered customer) correctly my order, if I try to purchase another item I got the following error:
    Call to a member function setFinalPrice() on a non-object in app/code/core/Mage/Sales/Model/Quote/Item/Abstract.php on line 73



    I have debugged the code and found out that the issue is created by some old quotes associated to my user that are still active and have not items associated with it.



    If I check the problematic quote in the Db it has items_count = 0 any way Mage_Sales_Model_Resource_Quote_Item_Collection::_assignProducts()method try to load an item using null as Id :



     $product = $productCollection->getItemById($item->getProductId());


    This trigger the above error.



    Now the fast fix it to set to is_active = 0 in all these quote, something like:



     UPDATE `sales_flat_quote` SET `is_active` = 0 WHERE `is_active` = 1 AND `items_count`= 0 and customer_id is not null and customer_id <> 0


    Question



    Anyway I would like to understand the following points:



    1. Is it normal to have old quotes (also multiple for same user) with 0 items and is_active = 1 ?

    2. Is ok to delete all these quotes ? ( I have 10000+ quotes like this )

    Any suggestion is welcome










    share|improve this question














    bumped to the homepage by Community 14 mins ago


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

















      2












      2








      2








      I'm facing this strange issue on add to cart action:



      sometime after I checkout (with a registered customer) correctly my order, if I try to purchase another item I got the following error:
      Call to a member function setFinalPrice() on a non-object in app/code/core/Mage/Sales/Model/Quote/Item/Abstract.php on line 73



      I have debugged the code and found out that the issue is created by some old quotes associated to my user that are still active and have not items associated with it.



      If I check the problematic quote in the Db it has items_count = 0 any way Mage_Sales_Model_Resource_Quote_Item_Collection::_assignProducts()method try to load an item using null as Id :



       $product = $productCollection->getItemById($item->getProductId());


      This trigger the above error.



      Now the fast fix it to set to is_active = 0 in all these quote, something like:



       UPDATE `sales_flat_quote` SET `is_active` = 0 WHERE `is_active` = 1 AND `items_count`= 0 and customer_id is not null and customer_id <> 0


      Question



      Anyway I would like to understand the following points:



      1. Is it normal to have old quotes (also multiple for same user) with 0 items and is_active = 1 ?

      2. Is ok to delete all these quotes ? ( I have 10000+ quotes like this )

      Any suggestion is welcome










      share|improve this question














      I'm facing this strange issue on add to cart action:



      sometime after I checkout (with a registered customer) correctly my order, if I try to purchase another item I got the following error:
      Call to a member function setFinalPrice() on a non-object in app/code/core/Mage/Sales/Model/Quote/Item/Abstract.php on line 73



      I have debugged the code and found out that the issue is created by some old quotes associated to my user that are still active and have not items associated with it.



      If I check the problematic quote in the Db it has items_count = 0 any way Mage_Sales_Model_Resource_Quote_Item_Collection::_assignProducts()method try to load an item using null as Id :



       $product = $productCollection->getItemById($item->getProductId());


      This trigger the above error.



      Now the fast fix it to set to is_active = 0 in all these quote, something like:



       UPDATE `sales_flat_quote` SET `is_active` = 0 WHERE `is_active` = 1 AND `items_count`= 0 and customer_id is not null and customer_id <> 0


      Question



      Anyway I would like to understand the following points:



      1. Is it normal to have old quotes (also multiple for same user) with 0 items and is_active = 1 ?

      2. Is ok to delete all these quotes ? ( I have 10000+ quotes like this )

      Any suggestion is welcome







      orders quote debug






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Apr 9 '15 at 5:01









      FraFra

      4,575115194




      4,575115194





      bumped to the homepage by Community 14 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 14 mins ago


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






















          1 Answer
          1






          active

          oldest

          votes


















          0














          If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.



          1. Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.


          Example: SELECT quote_id FROM sales_flat_quote_address where
          customer_id=23423




          1. Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.


          Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535







          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%2f63121%2fquote-with-no-items-add-to-cart-error%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














            If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.



            1. Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.


            Example: SELECT quote_id FROM sales_flat_quote_address where
            customer_id=23423




            1. Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.


            Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535







            share|improve this answer





























              0














              If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.



              1. Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.


              Example: SELECT quote_id FROM sales_flat_quote_address where
              customer_id=23423




              1. Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.


              Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535







              share|improve this answer



























                0












                0








                0







                If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.



                1. Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.


                Example: SELECT quote_id FROM sales_flat_quote_address where
                customer_id=23423




                1. Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.


                Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535







                share|improve this answer















                If it is throwing for all the customers then you can delete sales_flat_quote_item table. If this happens only for particular customer then do the following thing. In this case, all the quotes wont be deleted.



                1. Get the customer id from sales_flat_quote_address(column name: customer_id) table. Here you can get the specific quote id(column name in table is quote_id) which is causing the problem.


                Example: SELECT quote_id FROM sales_flat_quote_address where
                customer_id=23423




                1. Now, go to sales_flat_quote_item then delete the particular records which is causing the problem.


                Example: DELETE FROM sales_flat_quote_item WHERE quote_id=43535








                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited Sep 21 '18 at 9:34









                Ansar Husain

                1,765218




                1,765218










                answered Sep 21 '18 at 9:26









                TS GuhanTS Guhan

                12410




                12410



























                    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%2f63121%2fquote-with-no-items-add-to-cart-error%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

                    Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

                    How to solve knockout JS error in Magento 2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2

                    Nissan Patrol Зміст Перше покоління — 4W60 (1951-1960) | Друге покоління — 60 series (1960-1980) | Третє покоління (1980–2002) | Четверте покоління — Y60 (1987–1998) | П'яте покоління — Y61 (1997–2013) | Шосте покоління — Y62 (2010- ) | Посилання | Зноски | Навігаційне менюОфіційний український сайтТест-драйв Nissan Patrol 2010 7-го поколінняNissan PatrolКак мы тестировали Nissan Patrol 2016рвиправивши або дописавши її