Jump to content

Edit History

Paul C

Paul C

7 minutes ago, Studio1one said:

No that will not be right because 0 shows on two different Languages and it shows the same in ps_cart

If id_lang can be linked to the currency that should be used, then you could use that field in your query. e.g. if people who use the language with id = 5 use currency with id = 5 then you could do: 

UPDATE `ps_orders` SET `id_currency` = 5 WHERE `id_lang` = 5 AND id_currency = 0;

You would need to check the relationship between language and currency and then run the above for each language until all of the records with id_currency = 0 are gone.

It would appear that there are going to be other tables with id_currency incorrectly set though if both ps_orders and ps_cart are like that.

Paul C

Paul C

2 minutes ago, Studio1one said:

No that will not be right because 0 shows on two different Languages and it shows the same in ps_cart

If id_lang can be linked to the currency that should be used, then you could use that field in your query. e.g. if people who use the language with id = 5 use currency with id = 5 then you could do: 

UPDATE `ps_orders` SET `id_currency` = 5 WHERE `id_lang` = 5 AND id_currency = 0;

You would need to check the relationship between language and currency and then run the above for each language until all of the records with id_currency = 0 are gone.

×
×
  • Create New...