libelul Posted July 12, 2022 Share Posted July 12, 2022 Bonjour, Je n'arrive plus à mettre à jour l'état des commandes ni à ajouter des produits au panier !! J'ai vidé le cache sur presta et manuellement voici la liste des erreurs : [PrestaShopDatabaseException] UPDATE command denied to user '_____'@'_____' for table 'ps_employee' UPDATE `ps_employee` SET `last_connection_date` = CURRENT_DATE() WHERE `id_employee` = 1 AND `last_connection_date`< CURRENT_DATE() at line 744 in file classes/db/Db.php 739. if ($webservice_call && $errno) { 740. $dbg = debug_backtrace(); 741. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 742. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 743. if ($sql) { 744. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 745. } 746. 747. throw new PrestaShopDatabaseException($this->getMsgError()); 748. } 749. } DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments] 373. $this->result = $this->_query($sql); 374. } 375. } 376. 377. if (_PS_DEBUG_SQL_) { 378. $this->displayError($sql); 379. } 380. 381. return $this->result; 382. } 383. DbCore->query - [line 554 - classes/db/Db.php] - [1 Arguments] 549. { 550. if ($sql instanceof DbQuery) { 551. $sql = $sql->build(); 552. } 553. 554. $this->result = $this->query($sql); 555. if ($use_cache && $this->is_cache_enabled) { 556. Cache::getInstance()->deleteQuery($sql); 557. } 558. 559. return (bool)$this->result; DbCore->execute - [line 646 - classes/Employee.php] - [1 Arguments] 641. { 642. return Db::getInstance()->execute(' 643. UPDATE `'._DB_PREFIX_.'employee` 644. SET `last_connection_date` = CURRENT_DATE() 645. WHERE `id_employee` = '.(int) $idEmployee.' AND `last_connection_date`< CURRENT_DATE() 646. '); 647. } 648. 649. /** 650. * Fill Reset password unique token with random sha1 and its validity date. For forgot password feature. 651. */ EmployeeCore::setLastConnectionDate - [line 2845 - classes/controller/AdminController.php] - [1 Arguments] 2840. $this->context->smarty->assign(array( 2841. 'displayBackOfficeTop' => Hook::exec('displayBackOfficeTop', array()), 2842. 'submit_form_ajax' => (int)Tools::getValue('submitFormAjax') 2843. )); 2844. 2845. Employee::setLastConnectionDate($this->context->employee->id); 2846. 2847. $this->initProcess(); 2848. $this->initBreadcrumbs(); 2849. $this->initModal(); 2850. $this->initToolbarFlags(); AdminControllerCore->init - [line 186 - classes/controller/Controller.php] 181. /** 182. * Starts the controller process (this method should not be overridden!) 183. */ 184. public function run() 185. { 186. $this->init(); 187. if ($this->checkAccess()) { 188. // setMedia MUST be called before postProcess 189. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) { 190. $this->setMedia(); 191. } ControllerCore->run - [line 379 - classes/Dispatcher.php] 374. if (isset($params_hook_action_dispatcher)) { 375. Hook::exec('actionDispatcher', $params_hook_action_dispatcher); 376. } 377. 378. // Running controller 379. $controller->run(); 380. 381. // Execute hook dispatcher after 382. if (isset($params_hook_action_dispatcher)) { 383. Hook::exec('actionDispatcherAfter', $params_hook_action_dispatcher); 384. } Merci pour votre aide Link to comment Share on other sites More sharing options...
Tom Girou Posted July 13, 2022 Share Posted July 13, 2022 Il semblerait que vous ayez soit un problème d'accès à votre base de données (identifiants / droits) ou bien que vous ayez atteint le maximum de stockage autorisé. 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