Jump to content

Prestashop Database Exception


BeltoPrint

Recommended Posts

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=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 >= 13
AND c.nright <= 30
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 791 in file classes/db/Db.php

786.         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

 

 

post-1216885-0-50313700-1458066313_thumb.jpg

Link to comment
Share on other sites

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

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...