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: 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.
Solved! Go to Solution.
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.
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.