Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

Опции: не изменяется цена


frankyXIII
 Share

Recommended Posts

Всем хорошего дня!

Возникла проблема, сам решить не смог, буду благодарен за любую помощь:

Тестовый товар http://mebelempire.ru/for-baby/test

опции +10 и -20р., при включении их не работает пересчет цены.

ocStore 2.1.0.2.1, тема Fastor

Из того, что затрагивает цену, установлен Multi Currency PRO, но он, вроде бы, с клиентской частью не взаимодействует

В консоли браузера сопутствующих ошибок нет, в error.log вот что (сам понять ошибку не могу):

Quote

PHP Notice:  Error: Unknown column 'p.product_id' in 'where clause'<br />Error No: 1054<br />SELECT COUNT(DISTINCT `product_id`) AS `total`, `field` FROM( 
                    SELECT
                        ROUND( `p`.`width` / ( SELECT `value` FROM `oc_length_class` WHERE `length_class_id` = `p`.`length_class_id` LIMIT 1 ), 10 ) AS `field`,`p`.`product_id`
                    FROM (SELECT `product_id` AS `product_id`, `model` AS `model`, `sku` AS `sku`, `upc` AS `upc`, `ean` AS `ean`, `jan` AS `jan`, `isbn` AS `isbn`, `mpn` AS `mpn`, `location` AS `location`, `quantity` AS `quantity`, `q` AS `q`, `stock_status_id` AS `stock_status_id`, `image` AS `image`, `manufacturer_id` AS `manufacturer_id`, `shipping` AS `shipping`, (`price_rub`) AS `price`, `price_eur` AS `price_eur`, `price_usd` AS `price_usd`, `price_rub` AS `price_rub`, `overheads_currency` AS `overheads_currency`, `overheads` AS `overheads`, `margin` AS `margin`, `currency` AS `currency`, `points` AS `points`, `tax_class_id` AS `tax_class_id`, `date_available` AS `date_available`, `weight` AS `weight`, `weight_class_id` AS `weight_class_id`, `length` AS `length`, `width` AS `width`, `height` AS `height`, `size` AS `size`, `length_class_id` AS `length_class_id`, `subtract` AS `subtract`, `minimum` AS `minimum`, `sort_order` AS `sort_order`, `status` AS `status`, `viewed` AS `viewed`, `date_added` AS `date_added`, `date_modified` AS `date_modified`, `smp_related_products` AS `smp_related_products`, `smp_url_category_id` AS `smp_url_category_id`, `refresh` AS `refresh` FROM `oc_product`) AS `p`
                    INNER JOIN
                        `oc_product_description` AS `pd`
                    ON
                        `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 1
                    
                INNER JOIN
                    `oc_product_to_store` AS `p2s`
                ON
                    `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
            
                    
                    WHERE
                        `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p`.`width` > 0
                    
                 ) AS `tmp`  WHERE (
            SELECT 
                `price`
            FROM (SELECT `product_special_id` AS `product_special_id`, `product_id` AS `product_id`, `customer_group_id` AS `customer_group_id`, `priority` AS `priority`, (`price_rub`) AS `price`, `price_eur` AS `price_eur`, `price_usd` AS `price_usd`, `price_rub` AS `price_rub`, `date_start` AS `date_start`, `date_end` AS `date_end`, `text` AS `text` FROM `oc_product_special`) AS `ps` 
            WHERE 
                `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW()))
            ORDER BY 
                `ps`.`priority` ASC, `ps`.`price` ASC
            LIMIT 1
        ) IS NOT NULL GROUP BY `field` in .../system/library/db/mysqli.php on line 41

 

Заранее спасибо всем откликнувшимся!

Edited by frankyXIII
Link to comment
Share on other sites


  • Tom locked this topic
Guest
This topic is now closed to further replies.
 Share

×
×
  • Create New...

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.