Jump to content

Edit History

garedat

garedat

On 9/12/2022 at 9:31 AM, stennnn said:

If you ever need a solution for this issue, here it is:

I have noticed that I had a wierd Log (Advanced Parameters -> Logs) being generated for the carts that were being attached to the old order IDs. The log was the following: 

Frontcontroller::init - Cart cannot be loaded or an order has already been placed using this cart

I instantly thought this could be a unsynchronization of the tables in DB of the tables - ps_cart and ps_orders

Looked up online and found the solution to my problem on Stackoverflow thanks to Dmitry Sheiko:

In my case I had 286 on the first query and 23758 on the second query so I changed the AUTO_INCREMENT to 30000 instead of 2000 and fixed the issue!

What if I have this?:

SELECT id_cart FROM ps_cart ORDER by id_cart DESC LIMIT 1;

305734

 

And :

 

SELECT id_cart FROM ps_orders ORDER by id_cart DESC LIMIT 1;

305730

 

I have that problem and also that when adding products to the cart a cart of value 0 is generated.

 

Thanks in advance.

garedat

garedat

On 9/12/2022 at 9:31 AM, stennnn said:

If you ever need a solution for this issue, here it is:

I have noticed that I had a wierd Log (Advanced Parameters -> Logs) being generated for the carts that were being attached to the old order IDs. The log was the following: 

Frontcontroller::init - Cart cannot be loaded or an order has already been placed using this cart

I instantly thought this could be a unsynchronization of the tables in DB of the tables - ps_cart and ps_orders

Looked up online and found the solution to my problem on Stackoverflow thanks to Dmitry Sheiko:

In my case I had 286 on the first query and 23758 on the second query so I changed the AUTO_INCREMENT to 30000 instead of 2000 and fixed the issue!

What if I have this?:

SELECT id_cart FROM ps_cart ORDER by id_cart DESC LIMIT 1;

305734

 

And :

 

SELECT id_cart FROM ps_orders ORDER by id_cart DESC LIMIT 1;

305730

 

 

×
×
  • Create New...