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.

Sign up for GitHub

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

Jump to bottom

Integrity constraint violation after deleting order in CP and then customer attempts to add to cart #700

Closed
johndwells opened this issue Feb 8, 2019 · 2 comments
Closed

Integrity constraint violation after deleting order in CP and then customer attempts to add to cart #700

johndwells opened this issue Feb 8, 2019 · 2 comments
Labels
🔎 status: investigating Trying to reproduce

Comments

@johndwells
Copy link

Description

If a visitor's cart is deleted from the CP, and then the visitor attempts to add an item to their cart, An Integrity constraint violation is thrown, with a duplicate entry for key commerce_orders_number_unq_idx.

This is happening just after having updated from:

Craft: 3.0.40
Commerce: 2.0.0-beta.15

Steps to reproduce

  1. Visit front-end, add item to cart
  2. Visit back-end, delete cart
  3. Visit front-end, attempt to add item to cart
  4. Exception is thrown

Additional info

  • Craft version: 3.1.8
  • PHP version: 7.2.14
  • Database driver & version: MySQL 5.5.5
  • Commerce version: 3.0.4
@lukeholder lukeholder added the 🔎 status: investigating Trying to reproduce label Feb 18, 2019
@lukeholder
Copy link
Member

Thanks, fixed for the next release.

@portnull
Copy link

portnull commented May 9, 2019

I have the same bug just now…

@portnull portnull mentioned this issue May 9, 2019
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
🔎 status: investigating Trying to reproduce
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@lukeholder @johndwells @portnull