affutoo Posted October 8, 2015 Share Posted October 8, 2015 Bonjour, voici l'erreur rencontrée lors de la mise à jour de Google Analytics : [PrestaShopDatabaseException]Unknown column 'id_shop' in 'where clause' SELECT * FROM `ps16_ganalytics` WHERE sent = 0 AND id_shop = '1' AND DATE_ADD(date_add, INTERVAL 30 minute) < NOW() at line 646 in file classes/db/Db.php 641. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$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 516 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 716 - modules/ganalytics/ganalytics.php] - [1 Arguments] Ganalytics->hookBackOfficeHeader - [line 512 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 2451 - classes/controller/AdminController.php] - [2 Arguments] AdminControllerCore->init - [line 163 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 54 - admin/index.php] Je ne peux plus accéder aux modules dans le back office. Quel manipulation effectuer s'il vous plait ? Merci, Léo Link to comment Share on other sites More sharing options...
affutoo Posted October 9, 2015 Author Share Posted October 9, 2015 Personne n'a de solutions pour moi ? :/ Link to comment Share on other sites More sharing options...
juda_nanas Posted October 10, 2015 Share Posted October 10, 2015 Meme probleme pour moi! Je deviens fou Link to comment Share on other sites More sharing options...
affutoo Posted October 15, 2015 Author Share Posted October 15, 2015 Personne ne peux nous aider ? Merci ! Link to comment Share on other sites More sharing options...
whatheroeswear Posted October 16, 2015 Share Posted October 16, 2015 Avez vous essayé une désinstallation/réinstallation du module plutôt qu'une mise à jour? Si impossible d'accéder au module dans le BO, peut-être en l'enlevant manuellement directement du FTP? Link to comment Share on other sites More sharing options...
Baba deCode Posted October 16, 2015 Share Posted October 16, 2015 Bonjour, Bonjour, voici l'erreur rencontrée lors de la mise à jour de Google Analytics : [PrestaShopDatabaseException] Unknown column 'id_shop' in 'where clause' Il ne trouve pas la colonne id_shop et id_shop = 1 dans la bdd, es tu en multiboutique ? Link to comment Share on other sites More sharing options...
affutoo Posted October 16, 2015 Author Share Posted October 16, 2015 Je ne suis pas en multiboutique, suppression du module et résultat ... [PrestaShopDatabaseException]Can't DROP 'id_attribute'; check that column/key exists ALTER TABLE `ps16_layered_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, '[SQL Error] '.$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...
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