Skip to content

Issue with foreign key constraint on expired quotes #3

@pawel989

Description

@pawel989

Error message:
Unable to delete expired quote (ID: 517019): PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (db.getresponse_cart_map, CONSTRAINT GETRESPONSE_CART_MAP_CART_ID_QUOTE_ENTITY_ID FOREIGN KEY (cart_id) REFERENCES quote (entity_id))

Steps to reproduce:

  1. Login to the Magento 2 platform as a customer
  2. Add few items to the basket
  3. Log out and leave the basket "abandoned"

Final result:
Magento 2 is going to produce the error during the attempt to clean up the expired quotes.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions