cancel
Showing results for 
Search instead for 
Did you mean: 

Will removing a row from Quote Table cause issues?

SOLVED

Will removing a row from Quote Table cause issues?

I have one row in the quote table that is causing an error with cron_schedule related to a third party extension. Am I safe to remove the row from the Quote table or will this cause other issues? The message in the cron_schedule is:

 

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`quote`, CONSTRAINT `QUOTE_ENTITY_ID_QUOTATION_QUOTE_QUOTE_ID` FOREIGN KEY (`linked_quotation_id`) REFERENCES `quotation_quote` (`quote_id`) ON DELETE NO ACTION), query was: DELETE FROM `quote` WHERE (entity_id='117')

 

The Foreign key is NULL.

 

2 REPLIES

Re: Will removing a row from Quote Table cause issues?

Generally - quote table stores the data of Sales Quote - it means a customer who has added few products in cart but doesn't have checkout yet. or sometimes when order gets failed as well.

 

so if you are going to delete this value - so might be it will clear customer 's cart

 

apart from that there is no  issue will occurs. so you can delete this entry for the same.

if issue solved,Click Kudos & Accept as Solution

Re: Will removing a row from Quote Table cause issues?

By Default, Quote table contain shopping cart related stuff  and those record is held until the customer decides to finish placing the order from site. For Completed quotes that have been converted to Sales-Order when placed order successfully, Magento automatically clears them with a cron job.

So Quote row is used only Shopping cart to Sales order conversion process. If you delete those row your current quote for Cart will be removed and after add new product new row will be generated.

 

If your Row with field value is_active equal to 0 means your quote will be not used next time, that record will be useless. 

 

You can remove your quote row without any worry.

If Issue Solved, Click Kudos/Accept As solutions.