BeltoPrint Posted March 15, 2016 Share Posted March 15, 2016 Hi dears, I'm a new one for Prestashop and I haven't any good experience. Today I've a problem with my webshop!!! This is message: [PrestaShopDatabaseException]Access denied for user 'cl17-a-prest-d8p'@'%' to database 'cl17-a-prest-d8p'CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORYSELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category_product cpINNER JOIN ps_category c ON (c.id_category = cp.id_category ANDc.nleft >= 13AND c.nright <= 30AND c.active = 1)INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_productAND 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 791 in file classes/db/Db.php786. if ($webservice_call && $errno) {787. $dbg = debug_backtrace();788. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {790. if ($sql) {791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');792. }793.794. throw new PrestaShopDatabaseException($this->getMsgError());795. }796. } Can you help me how can I resolve this problem? Kind regards Nader Link to comment Share on other sites More sharing options...
coeos.pro Posted March 15, 2016 Share Posted March 15, 2016 I think the problem come from the module blocklayered Link to comment Share on other sites More sharing options...
BeltoPrint Posted March 15, 2016 Author Share Posted March 15, 2016 The problem is, I'm a new one and how can I resolve it? Link to comment Share on other sites More sharing options...
bellini13 Posted March 15, 2016 Share Posted March 15, 2016 you need to confirm that your database user has permissions to create temporary tables. according to the error, it does not. I would suggest you contact your hosting support for this type of issue Access denied for user 'cl17-a-prest-d8p'@'%' to database 'cl17-a-prest-d8p' CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY 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