Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to delete cart price rule in version 1.8.1 #31

Open
Epo123 opened this issue Sep 27, 2022 · 1 comment
Open

Unable to delete cart price rule in version 1.8.1 #31

Epo123 opened this issue Sep 27, 2022 · 1 comment

Comments

@Epo123
Copy link

Epo123 commented Sep 27, 2022

We've recently upgraded the module to version 1.8.1 from 1.7.4 and we've noticed that since this version the module is inputting values in the table 'mp_catalog_rule_updated_at' and since in the UpgradeSchema you are creating a foreign key relation for which you have not set the 'onDelete' action for this, when trying to delete a cart price rule you get an error saying you cannot delete the rule.
The error generated is as follows (xdebug):
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (magento.mp_catalog_rule_updated_at, CONSTRAINT catalogrule FOREIGN KEY (catalog_rule_id) REFERENCES catalogrule (rule_id)), query was: DELETE FROM catalogrule WHERE (rule_id = '1')

image

Please look into this and resolve the issue in a next version.

@marcoboom
Copy link

This is still an issue. Is anyone working on this issue?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants