Problem with price (zero to all product)
-
Good evening, when I try to change the exchange rate, I get such error messages in the database:
WordPress database error: [DOUBLE value is out of range in ‘((funkyd_ricardo
._price_meta_key
.meta_value
+ 0) * 58.000000)’]
UPDATE wp_postmeta _zone_price_meta_key INNER JOIN wp_posts posts on posts.ID = _zone_price_meta_key.post_id INNER JOIN wp_postmeta _price_meta_key on posts.ID = _price_meta_key.post_id AND _price_meta_key.meta_key = ‘_regular_price’ LEFT JOIN wp_postmeta _price_method on posts.ID = _price_method.post_id AND _price_method.meta_key = ‘_d180d0bed181d181d0b8d18f_price_method’ SET _zone_price_meta_key.meta_value = CASE ifnull(_price_meta_key.meta_value, ”) when ” THEN ” ELSE (_price_meta_key.meta_value + 0) * 58.000000 END WHERE _zone_price_meta_key.meta_key = ‘_d180d0bed181d181d0b8d18f_regular_price’ AND ifnull(_price_method.meta_value, ‘exchange_rate’) = ‘exchange_rate’ AND _zone_price_meta_key.meta_value <> CASE ifnull(_price_meta_key.meta_value, ”) when ” THEN ” ELSE (_price_meta_key.meta_value + 0) * 58.000000 ENDWordPress database error: [DOUBLE value is out of range in ‘((
funkyd_ricardo
._price_meta_key
.meta_value
+ 0) * 58.000000)’]
UPDATE wp_postmeta _zone_price_meta_key INNER JOIN wp_posts posts on posts.ID = _zone_price_meta_key.post_id INNER JOIN wp_postmeta _price_meta_key on posts.ID = _price_meta_key.post_id AND _price_meta_key.meta_key = ‘_sale_price’ LEFT JOIN wp_postmeta _price_method on posts.ID = _price_method.post_id AND _price_method.meta_key = ‘_d180d0bed181d181d0b8d18f_price_method’ SET _zone_price_meta_key.meta_value = CASE ifnull(_price_meta_key.meta_value, ”) when ” THEN ” ELSE (_price_meta_key.meta_value + 0) * 58.000000 END WHERE _zone_price_meta_key.meta_key = ‘_d180d0bed181d181d0b8d18f_sale_price’ AND ifnull(_price_method.meta_value, ‘exchange_rate’) = ‘exchange_rate’ AND _zone_price_meta_key.meta_value <> CASE ifnull(_price_meta_key.meta_value, ”) when ” THEN ” ELSE (_price_meta_key.meta_value + 0) * 58.000000 ENDPlus, all right prices is crossed out, instead of the price put 0, or simply 0 and the word “sale” is written. When I turn off the plug-in, then everything works, but not in the currency I need. Can you tell what this problem is related to? Because this morning the plugin worked fine and at some point just began to show nonsense.
Thank you!
- The topic ‘Problem with price (zero to all product)’ is closed to new replies.