Every day it seems I find yet another reason why sooner or later I am going to have get a LOT smarter about DataBases.
Today’s hard lesson was taught in the process of getting zenned.
Apparently when selecting PRODUCT Numbers there is a limitation in how you decide on product numbers.
Let me just say that I have now learned the hard way TWICE, that use of ISBN’s and UPC as Product Numbers in conjunction with EZ Populate is NOT a good idea.
So if you get an error message that starts.
1062 Duplicate entry ‘2147483647′ for key…
There is a very good possibility you will soon be erasing your store and starting over “from scratch”
Talk about undocumented unintended consequences.
If I find out an easy solution, I promise to share -
For now, well, time to go try the dangerous solutions, and if they don’t work “start over”
Happy Spring
