Duplicate entry '29' for key 'PRIMARY'
I thought I would put this under a new thread although I still have a few other questions.
Now if I go through the checkout process if I have one item in the cart the only issue is the email not getting through. However if I have more than one item in the cart I get an error "Duplicate entry '29' for key 'PRIMARY'"
Now I have look through several threads I have confirmed that the ID columns are "int" and set to auto increment. I think I just about exhausted all teh other suggestions. Do you have any ideas as to why this is now happened?
I should mention that this wasn't happening before we did our session. However another issue popped up that wasn't happening before probably because I chose a different product for the test. This one had a SKU which is not just numbers as many of my clients products have. I went into eStore Details Database and changed "DetailProdID" to text. This fixed the issue of accepting the "mixed" product code or SKU.
But then I tried a test with multiple items and the Duplicate entry '29' for key 'PRIMARY' started showing up. Any ideas on this one?
I added some clips from the database. please let me know if you need anything else.