Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
By default, the First name and Last name property aliases in the 'Order' tab in TeaCommerce are set to 'firstName' and 'lastName'.
For convention reasons, we have changed these to 'firstname' and 'lastname'
After this update, we get the following error when changing the orderstatus:
Violation of PRIMARY KEY constraint 'PK_TeaCommerce_CustomProperty'. Cannot insert duplicate key in object 'dbo.TeaCommerce_CustomOrderProperty'. The duplicate key value is (cea06e67-6e78-4730-a1a1-7818af119b5a, lastName)
Please note that we have changed all settings in our code/js etc.
We have even changed the aliases in the database to check if that resolves the issue, but unfortunately this did not help.
We have changed everything back to the camelcase variant, but we still would like some feedback on this issue.
Kind regards,Peter Rombouts
The reason is that the OrderId and the Alias of the property is the DB key - so no keys can have the same alias. If you use MS SQL - then the key might not be case sensitive and that is why this would fail. If you change the settings for the store - you properly also have to change all the ones that are already in the DB.
Hope this helps a bit. Else write me a bit more of details of how to reproduce :)
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted