yamamoto Posted January 21, 2014 Share Posted January 21, 2014 Hola a tod@s no puedo entrar en el backofice de mi tienda prestashop. Tod a venido a causa de actualizar modulos. Me sale esto: Me podéis ayudar por favor? Gracias de antemano Unknown column 'a.hide' in 'where clause' SELECT a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`FROM `ps_advice` a LEFT JOIN `ps_advice_lang` al ON al.`id_advice` = a.`id_advice` LEFT JOIN `ps_tab_advice` at ON at.`id_advice` = a.`id_advice`WHERE ( a.`validated` = 1 AND a.`hide` = 0 AND al.`id_lang` = 1 AND at.`id_tab` = 1 AND ((a.`start_day` = 0 AND a.`stop_day` = 0) OR (21 >= a.`start_day` AND 21 <= a.`stop_day`)))at line 607 in file classes/db/Db.php 601. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);602. }603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))604. {605. if ($sql)606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');607. throw new PrestaShopDatabaseException($this->getMsgError());608. }609. }610.611. /** DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 96 - modules/gamification/classes/Advice.php] - [1 Arguments] Advice::getValidatedByIdTab - [line 145 - modules/gamification/gamification.php] - [1 Arguments] Gamification->hookDisplayBackOfficeHeader - [line 421 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 1791 - classes/controller/AdminController.php] - [2 Arguments] AdminControllerCore->init - [line 150 - classes/controller/Controller.php] - [0 Argument] ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 50 - administrador/index.php] - [0 Argument] Link to comment Share on other sites More sharing options...
vekia Posted January 21, 2014 Share Posted January 21, 2014 http://www.prestashop.com/forums/topic/302960-problem-unknown-column-ahide-in-where-clause/?do=findComment&comment=1532524 Link to comment Share on other sites More sharing options...
yamamoto Posted January 21, 2014 Author Share Posted January 21, 2014 Muchas gracias por contestar tan rápido. No se como se hace, me lo podrías explicar por favor? Link to comment Share on other sites More sharing options...
Recommended Posts