Jump to content

Edit History

FranckR

FranckR


typo

Hi,

I had the same problem 

The issue was the column "convertion_rate" in the ps_orders table

I guess in prestashop prior to 1.7.6.0 if you had only one currency the conversion rate wasn't mandatory but now it is and should be > 0.000000

So I updated the column convertion_rate in table ps_orders with '1.000000' by using the following SQL request :

DO A BACKUP OF YOUR DATABASE BEFORE !!! 

AND IF YOUR USING MULTI CURRENCIES ON YOUR SHOP IT MIGHT MESS THINGS UP AND YOU SHOULD MAYBE ONLY UPDATE THE LINES WHERE IT'S 0,000000

UPDATE ps_orders SET conversion_rate = '1.000000'

Hope this can help

FranckR

FranckR

Hi,

I had the same problem 

The issue was the column "convertion_rate" in the ps_orders table

I guess in prestashop prior to 1.7.6.0 if you had only one currency the conversion rate wasn't mandatory but now it is and should be > 0.000000

So I updated the column convertion_rate in table ps_orders with '1.000000' by using the following SQL request :

DO A BACK YOUR DATABASE BEFORE !!! 

AND IF YOUR USING MULTI CURRENCIES ON YOUR SHOP IT MIGHT MESS THINGS UP AND YOU SHOULD MAYBE ONLY UPDATE THE LINES WHERE IT'S 0,000000

UPDATE ps_orders SET conversion_rate = '1.000000'

Hope this can help

×
×
  • Create New...