Jump to content
frankyXIII

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

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

Share this post


Link to post
Share on other sites
4 минуты назад, frankyXIII сказал:

Unknown column 'p.product_id' in 'where clause'

раз  "вроде бы не взаимодействует", тогда выясните, какой-такой модуль, это делает.

Share this post


Link to post
Share on other sites

К авторам модулей своих обращайтесь.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

  • Recently Browsing   0 members

    No registered users viewing this page.

×

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.