tapukatata Posted April 3, 2017 Share Posted April 3, 2017 (edited) I update my prestashop from 1.6.0.9 to 1.6.014 but when I add new specific price it's not visible in product page. After the update, when trying to add a specific price had the following error: Unknown column 'reduction_tax' in 'field list' INSERT INTO `ps_specific_price` (`id_shop_group`, `id_shop`, `id_cart`, `id_product`, `id_product_attribute`, `id_currency`, `id_specific_price_rule`, `id_country`, `id_group`, `id_customer`, `price`, `from_quantity`, `reduction`, `reduction_tax`, `reduction_type`, `from`, `to`) VALUES ('0', '0', '0', '691', '0', '0', '0', '0', '0', '0', '-1', '1', '2', '1', 'amount', '0000-00-00 00:00:00', '0000-00-00 00:00:00') After that in SQL I added that code: ALTER TABLE `ps_specific_price` ADD `reduction_tax` ENUM('amount','percentage') NOT NULL AFTER `reduction`; ALTER TABLE `ps_specific_price_rule` ADD `reduction_tax` ENUM('amount','percentage') NOT NULL AFTER `reduction`; Now I am able to add specific price but when I open the product page I can not see reduction percent and reduction amount. I can see them but only till product page is loading. Here is example: http://iskambg.com/avto-aksesoari/6-ochila-za-shofirane-noshtem-denem.html Edited September 10, 2019 by tapukatata (see edit history) Link to comment Share on other sites More sharing options...
tapukatata Posted April 4, 2017 Author Share Posted April 4, 2017 HELP ! Link to comment Share on other sites More sharing options...
tapukatata Posted April 5, 2017 Author Share Posted April 5, 2017 Please, help me! I can not resolve the problem by myself Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now