Jump to content

Edit History

Jan Utko

Jan Utko

On 12/12/2018 at 3:00 PM, wim vos said:

Hi,

It turned out to be two separate problems 1: the 502 bad gateway nginx error error. This is caused by to strict security in the server. I communicated intensively with the host (Alphamegahosting) They tried to help but in the end they where not prepared to change their server settings. I had to change host and that solver that problem fully!

and problem 2: sometimes one or two random products sometimes 2 with a low ID number are automatically added to my shopping cart. 

Prestashop 1.7 adds unwanted random product(s) to new order and  consequent 502 bad gateway error was caused by an inconsistency between ps_cart_products and ps_cart tables in the database. 

This inconsistency was introduced after import customers. Carts that turned into orders are still coupled to the customer. Error: Cart cannot be loaded or an order has already been placed using this cart.

 Cause: inconsistency between ps_cart_products table and ps_cart table

Solution: Make a note of highest number in id_cart in ps_cart_products database table

In ps_cart set AUTO_INCREMENT value to highest number in id_cart in ps_cart_products  + 1

 Disclaimer: Ofcourse before making any changes to your webshop make a full backup, I am not responsible for any results of applying my writing. It solved my problem but there is no guaranty it solves anything for you.

Hope this helps, I was given the help from someone too.

good luck!

 

 

Yours solution did the job for me. Problem with weird products behavior in cart is gone. Thanks a lot!

My current PS version: 1.7.6.7

Jan Utko

Jan Utko

On 12/12/2018 at 3:00 PM, wim vos said:

Hi,

It turned out to be two separate problems 1: the 502 bad gateway nginx error error. This is caused by to strict security in the server. I communicated intensively with the host (Alphamegahosting) They tried to help but in the end they where not prepared to change their server settings. I had to change host and that solver that problem fully!

and problem 2: sometimes one or two random products sometimes 2 with a low ID number are automatically added to my shopping cart. 

Prestashop 1.7 adds unwanted random product(s) to new order and  consequent 502 bad gateway error was caused by an inconsistency between ps_cart_products and ps_cart tables in the database. 

This inconsistency was introduced after import customers. Carts that turned into orders are still coupled to the customer. Error: Cart cannot be loaded or an order has already been placed using this cart.

 Cause: inconsistency between ps_cart_products table and ps_cart table

Solution: Make a note of highest number in id_cart in ps_cart_products database table

In ps_cart set AUTO_INCREMENT value to highest number in id_cart in ps_cart_products  + 1

 Disclaimer: Ofcourse before making any changes to your webshop make a full backup, I am not responsible for any results of applying my writing. It solved my problem but there is no guaranty it solves anything for you.

Hope this helps, I was given the help from someone too.

good luck!

 

 

Yours solution did the job form me. Problem with weird products behavior in cart is gone. Thanks a lot!

My current PS version: 1.7.6.7

×
×
  • Create New...