Wheat Wrote WHAT?!

Whatever Is On My Mind – Links for things I use: InMySmall Kitchen to EnjoyTheMaking

Get Email Delivery

Log in
March 29th, 2008 at 09:58 am

ZenCart! A What Not To Do

in: ZenCart
Spread the love

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

 

RSS feed for comments on this post | TrackBack URI

  • Non-Standard Disclaimer

    Wheat Wrote WHAT !?! Beginning in January 2020 we may include product links. If you choose to buy thru these links, Wheat may receive some form of compensation. Wheat assumes no responsibility if you are not happy with a product not sold thru our own website ItsAllJustString.com and expects smart shoppers will also do a bit of due diligence to form your own opinion if that item "works for you"
    Wheat Wrote WHAT !?!Assumes ONLY YOU can properly and completely perform the necessary due diligence to determine your course of action in life or business - ALL article, like all on this blog, are a starting point, not the last word by any means. While I hope it is worth more, its value is exactly the same as what you paid for it – no dollars.
    Wheat Wrote WHAT !?! began as a place to express opinions strongly held or silly without everyone getting their panties in a twist assuming those opinions to be a personal attack because they lack the ability to discern between discussing the point and flaming a person.
    Wheat Wrote WHAT !?! is also where Wheat writes about products she uses and occasionally mentions ones best avoided. These may also but not always and not surprisingly are sold at ItsAllJustString,com
    Wheat Wrote WHAT !?! is also where she expresses sometimes controversial opinions about just about anthing so please expect the occastion rant.
    Wheat Wrote WHAT !?! welcome your comments - just remember - we want ot discuss the point not the person unless they are public usually political person.
    Wheat Wrote WHAT !?! is where Wheat writes primarily about things she uses and sells thru ItsAllJustString,com
    Wheat Wrote WHAT !?! blogamentries are based on personal experience and opinon. Your experience and opinion may differ. "what works for wheat may not work for you"
    © 2002-Infinity Wheat Wrote WHAT !?! WheatCarr.com

  • Recent Posts

  • Recent Comments

  • Categories

  • Pages

>/font>