Jump to content

Help prestashop 1.7.2 erreurs


libelul

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...