Jump to content

Prestashop backoffice - (catalogus/products) not working - error 500

Naturel Deluxe

Recommended Posts

Since a short time I'm getting a error500 on the prestashop products page in our backoffice. 

When I enable debug, I can see this: 

ConnectionException in AbstractMySQLDriver.php line 103:
An exception occured in driver: SQLSTATE[28000] [1045] Access denied for user 'dbasename'@'localhost' (using password: YES)
in AbstractMySQLDriver.php line 103
at AbstractMySQLDriver->convertException('An exception occured in driver: SQLSTATE[28000] [1045] Access denied for user 'dbasename'@'localhost' (using password: YES)', object(PDOException)) in DBALException.php line 145
at DBALException::driverException(object(Driver), object(PDOException)) in Driver.php line 47
at Driver->connect(array('driver' => 'pdo_mysql', 'host' => 'localhost', 'port' => '', 'dbname' => 'dbname', 'user' => 'username', 'password' => 'XXXXXXXXXXX', 'charset' => 'UTF8', 'driverOptions' => array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))'), 'serverVersion' => '5.1'), 'dbname', 'XXXXXXXXX', array('SET sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))')) in Connection.php line 360
at Connection->connect() in Connection.php line 833
at Connection->executeQuery('SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6 FROM psc5_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1', array('1', '1', 'ProductController', 'catalogAction'), array('integer', 'integer', 'string', 'string')) in BasicEntityPersister.php line 712
at BasicEntityPersister->load(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, '1', null) in EntityRepository.php line 196
at EntityRepository->findOneBy(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 88
at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 137
at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'desc')
at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'desc')) in bootstrap.php.cache line 3246
at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3205
at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3359
at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2562
at Kernel->handle(object(Request), '1', false) in index.php line 86

The problem is quite simple: the password is incorrect (the file is using an old one. But in defines.inc.php our password is changed & correct. 


The same issue is happening with this files: 

PDOException in PDOConnection.php line 47:
SQLSTATE[28000] [1045] Access denied for user 'dbname'@'localhost' (using password: YES)
PDOException in PDOConnection.php line 43:
SQLSTATE[28000] [1045] Access denied for user 'dbname'@'localhost' (using password: YES)


How can I solve this? 


Thanks in advance!

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