Sergi0 Posted July 13, 2015 Share Posted July 13, 2015 Prestashop 1.6.0.14 updated all modules in one row and faced a bug: Can somebody help with advices? [PrestaShopDatabaseException]Duplicate entry '67-1' for key 'PRIMARY' ALTER TABLE `ps_mgflxlayered_product_attribute` ADD PRIMARY KEY (`id_attribute`, `id_product`), DROP KEY `id_attribute`, ADD UNIQUE KEY `id_attribute_group` (`id_attribute_group`,`id_attribute`,`id_product`)at line 646 in file classes/db/Db.php 641. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);642. }643. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))644. {645. if ($sql)646. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');647. throw new PrestaShopDatabaseException($this->getMsgError());648. }649. }650.651. /** DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 480 - classes/db/Db.php] - [1 Arguments] DbCore->execute - [line 22 - modules/blocklayered/upgrade/install-2.0.8.php] - [1 Arguments] upgrade_module_2_0_8 - [line 442 - classes/module/Module.php] - [1 Arguments] ModuleCore->runUpgradeModule - [line 1443 - controllers/admin/AdminModulesController.php] AdminModulesControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 54 - admin/index.php] Link to comment Share on other sites More sharing options...
SOFTD Posted July 30, 2015 Share Posted July 30, 2015 Hi Man i had the same problem, but I read thsi post: https://www.prestashop.com/forums/topic/450340-solucionado-prestashopdatabaseexception-duplicate-entry-56-8265-for-key-primary/ but probably is for a bad installation or bad upgrade, then you only have to change the name blocklayered to blocklayered_ in modules files I Hope help You 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