PatrickRQ Posted October 27, 2022 Posted October 27, 2022 Hi, When you go to Commerce > Customer > Field and try to copy any of existing ones it will throw error. This is probably because at the same time of copying the field it tries to insert column for that in nexus_customers table using original field name of table that is being copied. Result? SQL Error - Cannot insert duplicate. That is actually pretty ancient Commerce error from times of IPB3.
Marc Posted October 27, 2022 Posted October 27, 2022 Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release. PatrickRQ 1
PatrickRQ Posted October 27, 2022 Author Posted October 27, 2022 FYI, worst part of that issue is that when you delete that "copied" field, the system will drop the column name of field name of the field that was copied = data loss.
Marc Posted October 28, 2022 Posted October 28, 2022 I was not actually able to replicate that part, but have added the information there for our developers in case.
Solution Marc Posted November 30, 2022 Solution Posted November 30, 2022 This item has now been resolved on the latest 4.7.5 release of the platform. If you are experiencing issues once you have upgraded, please let us know.
Recommended Posts