Jump to content

Error while upgrading 1.6.0.14 to 1.6.1.0 Key 'id_product_2' doesn't exist in table 'nmkz_specific_p


Recommended Posts

Please help, as getting error while updating from 1.6.0.14 to 1.6.1.0

__________________________

[PrestaShopDatabaseException]
Key 'id_product_2' doesn't exist in table 'nmkz_specific_price'

SELECT *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `nmkz_specific_price` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 1983)
AND `id_product_attribute` IN (0, 1286)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2015-07-21 00:41:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2015-07-21 00:41:00' <= `to`)
)
AND id_cart IN (0, 0)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
at line 765 in file classes/db/Db.php

760. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
761. }
762. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
763. {
764. if ($sql)
765. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
766.
767. throw new PrestaShopDatabaseException($this->getMsgError());
768. }
769. }
770.
DbCore->displayError - [line 418 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 669 - classes/db/Db.php] - [1 Arguments]
DbCore->getRow - [line 236 - classes/SpecificPrice.php] - [1 Arguments]
SpecificPriceCore::getSpecificPrice - [line 2808 - classes/Product.php] - [10 Arguments]
2803. $quantity,
2804. $id_product_attribute,
2805. $id_customer,
2806. $id_cart,
2807. $real_quantity
2808. );
2809.
2810. if (isset(self::$_prices[$cache_id]))
2811. return self::$_prices[$cache_id];
2812.
2813. // fetch price & attribute price
ProductCore::priceCalculation - [line 2738 - classes/Product.php] - [20 Arguments]
ProductCore::getPriceStatic - [line 5402 - modules/iqitmegamenu/iqitmegamenu.php] - [3 Arguments]
IqitMegaMenu->getProducts - [line 1952 - modules/iqitmegamenu/iqitmegamenu.php] - [1 Arguments]
IqitMegaMenu->buildSubmenuTree - [line 4884 - modules/iqitmegamenu/iqitmegamenu.php] - [2 Arguments]
IqitMegaMenu->makeMegaMenu - [line 4275 - modules/iqitmegamenu/iqitmegamenu.php] - [1 Arguments]
IqitMegaMenu->_prepareHook - [line 4201 - modules/iqitmegamenu/iqitmegamenu.php] - [1 Arguments]
IqitMegaMenu->hookDisplayTop - [line 569 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 524 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 580 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php]
IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]
  • Like 1
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...