satrick

Apply my fix and everything will be alright

thank you guys

Ok I fixed it. I hope this will help somebody someday: You have to rollback function in classes/controllers/AdminController.php and remove there lines 893 - 895: if (isset($_POST) && count($_POST) && (int)Tools::getValue('submitFilter'.$this->list_id) || Tools::isSubmit('submitReset'.$this->list_id)) { $this->setRedirectAfter(self::$currentIndex.'&token='.$this->token.(Tools::isSubmit('submitFilter'.$this->list_id) ? '&submitFilter'.$this->list_id.'='.(int)Tools::getValue('submitFilter'.$this->list_id) : '')); } That function is new in 1.6.1.2 and it didn't work at all for me.

Hi, i have recently upgraded my e-shop from 1.6.1.1 to 1.6.1.2 and after that upgrade i have problem in back office in Catalog - Categories. I got many subcategories (80+) under 3 main categories and my listing in back office is by 50 categories. So that mean that i have page one and page two. But when I try to go to page 2 it doesn't work. It redirect me to main categories. Also.. searching by name, active state... just all searching.. in subcategories doesn't working as well. Any try to search something redirects me to main categories and doesn't stay in subcategories. Do you have any ideas how to fix this?

Ok I have discovered that problem is in getSpecificPrice function in classes/specificprice.php You have to replace SQL select. So: Not working select: $query = ' SELECT *, '.SpecificPrice::_getScoreQuery($id_product, $id_shop, $id_currency, $id_country, $id_group, $id_customer).' FROM `'._DB_PREFIX_.'specific_price` WHERE `id_shop` '.self::formatIntInQuery(0, $id_shop).' AND `id_currency` '.self::formatIntInQuery(0, $id_currency).' AND `id_country` '.self::formatIntInQuery(0, $id_country).' AND `id_group` '.self::formatIntInQuery(0, $id_group).' '.$query_extra.' AND IF(`from_quantity` > 1, `from_quantity`, 0) <= '; working select: $now = date('Y-m-d H:i:00'); $query = ' SELECT *, '.SpecificPrice::_getScoreQuery($id_product, $id_shop, $id_currency, $id_country, $id_group, $id_customer).' FROM `'._DB_PREFIX_.'specific_price` USE INDEX (id_product_2) WHERE `id_product` IN (0, '.(int)$id_product.') AND `id_product_attribute` IN (0, '.(int)$id_product_attribute.') AND `id_shop` IN (0, '.(int)$id_shop.') AND `id_currency` IN (0, '.(int)$id_currency.') AND `id_country` IN (0, '.(int)$id_country.') AND `id_group` IN (0, '.(int)$id_group.') AND `id_customer` IN (0, '.(int)$id_customer.') AND ( (`from` = \'0000-00-00 00:00:00\' OR \''.$now.'\' >= `from`) AND (`to` = \'0000-00-00 00:00:00\' OR \''.$now.'\' <= `to`) ) AND id_cart IN (0, '.(int)$id_cart.') AND IF(`from_quantity` > 1, `from_quantity`, 0) <= ';

That is misunderstanding. Update 1.6.1.2 already gave me id_product_2 key so I successfully deleted it and created it once again. There was no problem with deleting key id_product_2. But if you are really desperate as me, you can simply rollback old version of specificprice.php from classes and then everything is working

ok i compared all major files (folders: core, classes,...) in problematic eshop on 1.6.1.2 with fresh instalation of 1.6.1.2 where discounts are working and there are no difference. So problem has to be in database somewhere

Tried, no progress btw.. to avoid unnecessary questions.. i am always erasing my cache, removing product specific price (discount) and then creating it once again

I know, already did that, but with same result after creating it after that again

I totaly agree with cobrax13. I upgrated from 1.6.1.1 to 1.6.1.2 and that sql solution doesn't work at all. It say, that id_product_2 unique key already exist.