PatrickRQ Posted October 27, 2022 Share 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. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted October 27, 2022 Share 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 Link to comment Share on other sites More sharing options...
PatrickRQ Posted October 27, 2022 Author Share 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. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted October 28, 2022 Share Posted October 28, 2022 I was not actually able to replicate that part, but have added the information there for our developers in case. Link to comment Share on other sites More sharing options...
Solution Marc Stridgen Posted November 30, 2022 Solution Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts