- Issue created by @Madhu Kumar M E
- 🇮🇱Israel jsacksick
I never experienced this... Are you on MYSQL? Which version? Any extra information would be helpful.
- Status changed to Closed: cannot reproduce
about 1 year ago 7:17pm 3 February 2024 - 🇮🇳India Madhu Kumar M E
Hi @jsacksick ,
Please find attached screenshot where we can see mysql version and other details. - Status changed to Needs work
about 1 year ago 4:50am 13 February 2024 - Status changed to Active
about 1 year ago 6:42am 13 February 2024 - 🇮🇱Israel jsacksick
"Needs work" is for issues with patches... There's no patch here..
Do you need sequential order numbers? Otherwise just disable this feature from the order type settings. - 🇮🇳India Madhu Kumar M E
Hi @jsacksick,
The root cause of this issue has been identified. The commerce module utilizes the 'commerce_number_pattern_sequence' table to manage this process.
Within this table, there is a field named 'generated' where we update the timestamp.
During the payment process completion, our code selects the last record from this table and attempts to update the value. However, the query fails due to the 'generated' field.
- Status changed to Closed: cannot reproduce
11 months ago 9:09am 13 May 2024 - 🇮🇱Israel jsacksick
During the payment process completion, our code selects the last record from this table and attempts to update the value. However, the query fails due to the 'generated' field.
So is this due to your custom code? Can we close this?