[SOLVED] Messed up shopping cart ID's

[dsf]

Hi!

 

I have setup and been running a store for several months without too many major problems, however i am now constantly getting errors when trying to add items to the cart.

Front office - when i go to a cart it shows as empty.

Back Office - When i manuall add an order i get the error message: An order has already been placed with this cart.
This product cannot be added to the cart.

 

Months ago i used a module to clean up the database - both the built in prestashop one and Database Optimization v1.1 - by MyPresta.eu

 

I think it deleted all the cart_id info? And the carts started again from the begginging.

 

But... it has been working ok upto now when suddenly i am getting problems with the "order has already been placed with this cart" messages and looking at the shopping cart list it is showing matches to the incorrect older orders.

 

How can i get the cart_id field to stop reusing old id's and start say from 900 or 1000 onwards to avaid reusing old id's?

 

Thank you for any help!!!

 

 

PrestaShop version 1.6.0.9

PHP version 5.4.31

 

 

[dsf]

Also, I am using the Order reference change mod v1.5.3 - by PrestadevNL

 

This is configured to modify the order reference only - not to use any of the cart ID info.

 

Thanks.

[vekia]

go to ps_cart table in your database

open table settings page

check value of AUTO INCREMENT param

 

compare it with last cart id in ps_orders

 

then setup AUTO INCREMENT to last cart id from ps_orders +1

[dsf]

Thanks Vekia,

 

Thats sorted that problem out.

 

[vekia]

you're welcome ;-)

glad ot hear that i could help

i marked topic title as [solved]

with regards,

Milos

[leozao]

Hello,

I had the same problem and seems to be solved with this solution...

Tks, Vekia!