Help : error UPDATE command denied

[tiego]

24h after restoring a website under 1.6.0.8 on a new hosting provider (for tests), the site show a blank page (front and back office), and when in debug mode , it shows the error:

 

[PrestaShopDatabaseException]

UPDATE command denied to user 'xxxxx'@'10.0.62.106' for table 'ps_configuration'
 

UPDATE `ps_configuration` SET `value` = '8e1b63cc71f6af38d6733afee004be8c',`date_upd` = '2015-08-25 15:52:06' WHERE `name` = 'CRONJOBS_ADMIN_DIR' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1

at line 635 in file classes/db/Db.php

629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. 		}631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. 		{633. 			if ($sql)634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. 			throw new PrestaShopDatabaseException($this->getMsgError());636. 		}637. 	}638. 639. 	/**

 

I didn't change anything in the table ps_configuration.

 

Can anyone help me ?

 

thanks

 

[bellini13]

the user does not have the appropriate permissions within mysql database to update records in this table.

[tiego]

thanks.

in fact I just find the reason : my provider changed the rights of the user because database size exceeded the size allowed in my hosting plan. I purge the purge and everything went back to normal.

[MariusTattooSupplies]

On 8/26/2015 at 2:23 AM, tiego said:

thanks.

in fact I just find the reason : my provider changed the rights of the user because database size exceeded the size allowed in my hosting plan. I purge the purge and everything went back to normal.

Hi. Can you help me? I have the same problem. Can you tell me how did you do it? Thank you.