sagenterprises Posted July 20, 2015 Share Posted July 20, 2015 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 1at line 765 in file classes/db/Db.php760. 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_quantity2808. );2809.2810. if (isset(self::$_prices[$cache_id]))2811. return self::$_prices[$cache_id];2812.2813. // fetch price & attribute priceProductCore::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] 1 Link to comment Share on other sites More sharing options...
sagenterprises Posted July 21, 2015 Author Share Posted July 21, 2015 El Patron Please help.... 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