Quote Originally Posted by wheat View Post
Thank you, I do understand what you are saying. However the issue is that ZenCart has a "hard coded" maximum number. For some reason buried back in about 2008 - my system "thought" it had reached that number.

The first line of the error report mention that number -

Fortunately I had a copy of the "other" EZ Pop and was able to find determine what the highest Prod ID really was. Once I knew that, the DB had to be manually edited (cannot be done thru any of the ZenCart Admin Pages) Equally. Fortunately once I realized what the problem - my other half was able to resolve the issue.

I had to delete one product and then change the product number to be incremented as products are added and it is all good until I do something else terminally stupid on purpose or accidentally.

Meanwhile because I am sometimes more adventurous than I should be, my SO wrote something so that the entire DB is backed up daily, zipped and sent via email so I always have a copy no older than 24 hours available.

Thank you for your thoughts, they make help with some other occasional issues.

Enjoy The Making

Wheat
Okay, a couple of things, I can't imagine that the maximum number of products in your store can be 218 or whatever low number showed in this thread. After that, I find it difficult to have perhaps millions of products that are active in a single store.

As for the auto_number. As you said if you are able to find the "actual" next number, then you should go into your mySQLadmin panel and reset the auto_number to "that" number. Thing is, if not mistaken, the total number of items is limited by the server not so much Zen-Cart. If you are unable to use the standard Zen-Cart add product functionality, then this version of EP is most likely also not going to work.