agwork Posted July 18, 2015 Share Posted July 18, 2015 questo è l errore: [PrestaShopDatabaseException]Access denied for user 'm143405d1'@'%' to database 'm143405d1' CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 109 AND c.nright <= 414 AND c.active = 1) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = 1) INNER JOIN ps_product p ON (p.id_product=cp.id_product) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")at line 765 in file classes/db/Db.php 760. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);761. }762. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))763. {764. if ($sql)765. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');766.767. throw new PrestaShopDatabaseException($this->getMsgError());768. }769. }770. DbCore->displayError - [line 418 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 578 - classes/db/Db.php] - [1 Arguments] DbCore->execute - [line 2127 - modules/blocklayered/blocklayered.php] - [2 Arguments] BlockLayered->getFilterBlock - [line 687 - modules/blocklayered/blocklayered.php] - [1 Arguments] BlockLayered->hookHeader - [line 569 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 526 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 579 - classes/controller/FrontController.php] - [1 Arguments] FrontControllerCore->initContent - [line 131 - controllers/front/CategoryController.php] CategoryControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
Giorgio M. Posted July 18, 2015 Share Posted July 18, 2015 attiva il debug del negozio, all'interno della cartella config apri il file define.inc.php /* Debug only */ if (!defined('_PS_MODE_DEV_')) define('_PS_MODE_DEV_', false); al posto di false scrivi "true" e vedi se ti segnala degli errori Link to comment Share on other sites More sharing options...
Giancarloweb Posted July 20, 2015 Share Posted July 20, 2015 E' un errore generato dal modulo di navigazione a strati... Prova a disabilitarlo Link to comment Share on other sites More sharing options...
jberezhnoy Posted April 26, 2016 Share Posted April 26, 2016 Hi! The problem is that your mysql has insufficient privileges to create temporary tables and, possibly, some others. You can check this from phpmyadmin by running the following query: SHOW GRANTS; If you have all necessary permissions the output should be like: Grants for yourusername_pshop@% GRANT USAGE ON . TO 'yourusername_pshop'@'%' IDENTIFIED BY PASSWORD 'YOURPASSWORDHASH' GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON yourusername_pshop.* TO 'yourusername_pshop'@'%' In my case I was missing privileges to create temporary tables [!!! if you look at your error you can see that the SQL query tries to create temporary table in memory (ENGINE=MEMORY), but indeed you do not have this permission and get access denied error] Hope it helps 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