None of my horizontal menu icon is working ,access denied ?

Avatar
  • Answered
I encounter this error after when i tried to change my default currency to dollar because i was trying to make paypal europe module work but i have changed it back to naira currency. website is as0-iyi.com Whenever i click on one of the horizontal menu icon (e.g african prints) it will display the following line of code below [PrestaShopDatabaseException] Access denied for user 'cl50-x-prest-xxx'@'%' to database 'cl50-x-prest-xxx' 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 >= 10 AND c.nright <= 11 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") throw new PrestaShopDatabaseException($this->getMsgError().'

'.$sql.'
'); 635. throw new PrestaShopDatabaseException($this->getMsgError()); check my website for more proper explanation www-aso-iyi.com click on african prints at the horizontal menu Will appreciate so much
Avatar
Tim S.
Hello,

Thank you for posting a question regarding the database error in Prestashop. It would appear that your DB user does not have full privileges to create a table. I'd suggest checking your database user settings to ensure the user has ALL privileges.

I hope this helps!

Thanks!

Tim S