[Done v155] PHP Fatal error: 1062uplicate entry '0' for key 'PRIMARY'

also ran the query again this is all i could get out of it

ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

Quote:

---

Originally Posted by mydakota

magically i get home and start playing and it is fixed hmmmm seems someone has fixed it very strange must have been the hosting company i will try find out what they did to fix it but i guess you guys probably know what they did anyhow but I would like to confirm it .

---

Quote:

---

Originally Posted by mydakota

also ran the query again this is all i could get out of it

ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

---

Ya, it looks like they turned off the NO_AUTO_VALUE_ON_ZERO setting.


FWIW Zen Cart v1.5.5 will include changes to minimize the risk of triggering problems if NO_AUTO_VALUE_ON_ZERO is enabled. (I can't guarantee plugins won't try to use 0-value inserts, but ZC core code should be less likely to trigger that starting with v155).

Thank you guys for all your help really appreciate it

Quote:

---

Originally Posted by mydakota

magically i get home and start playing and it is fixed hmmmm seems someone has fixed it very strange must have been the hosting company i will try find out what they did to fix it but i guess you guys probably know what they did anyhow but I would like to confirm it .

---

Darn... I was really looking forward to seeing DrByte's proposed solution of how to tell the server to "ignore" this setting.. :) Ohh well, maybe the issue was addressed for webmanstudios as well??? If not, @webmanstudios, suggest having a similar discussion with the host to see if this can be resolved for you as well... No sense in working with ZC in a disabled state when so much more could be possible...

Quote:

---

Originally Posted by mc12345678

Darn... I was really looking forward to seeing DrByte's proposed solution of how to tell the server to "ignore" this setting.. :)

---

See: https://github.com/zencart/zencart/c...63400b2c42f4ac