.png.022b5452a8f28f552bc9430097a16da2.png)
ExpandPlease check my problem which might be related to this topic. Note that shop URL might be in maintenance mode.
I tried auto-increment solution but didn't work. I'm not sure if I did it correctly or not.
Example: In ps_orders table, if last (or highest) id_cart is 30, then I have to set auto-increment of id_cart to 31 in ps_cart table. Is it right?
Just setting the operand of AUTOINCREMENT in ps_cart table 1 or 2 numbers higher than the id_cart in ps_orders table did not work for us. We actually set the AUTOINCREMENT in ps_cart table way further ahead. Our imported database was showing something like a cart value of 1015 so we just started new cart ids at 3000 autoincrementing by 1 after that. THAT fixed our problem.
If you are importing data from an older 1.6 store - I challenge your cart number only being at 30. That number sounds really small unless you don't get much traffic on your site. I think you might be looking at a wrong column in the table.
I should also mention, when you're doing testing and having issues, its a good practice to do test carts using a private or incognito tab or page. Especially with Google Chrome browser, we've seen some pretty frustrating issues caused by the browser not letting go of cached pages as well as elements from pages.
Hope this helps.
K