Jump to content

Error 500 Backoffice>Produkty>


matthew.k

Recommended Posts

Witam :)
Ostatnimi czasy przeniosłem sklep internetowy na nowy hosting pracujący na tej samej konfiguracji (VPS).
Po przeniesieniu wszystko elegancko zadziałało, jednak jest jeden drobny problem...
Po zalogowaniu do backoffice nie mogę przejść do Katalogu produktów, wszystkie inne zakładki działają.
Otrzymuję błąd 500. Moja pierwsza myśl to edycja config/defines.inc.php, znana wszystkim zamiana false na true i test. 
I tutaj moje zaskoczenie, wszytko działa!
Jedyny znaleziony błąd:

filemtime(): stat failed for ŚCIEŻKASERWERA/themes/new-theme/css/admin-theme.cssContext: { "name": "E_WARNING", "type":2,"file": "ŚCIEŻKASERWERA/classes/controller/AdminController.php", "line":439,"level":28928,"scream":true}

Ponowna zmiana  config/defines.inc.php true na false, zapis, odświeżenie strony.
Strona wyświetla błąd 500.


Ktoś spotkał się z takim problemem ? 

Informacje techniczne serwera i wersji oprogramowania:
 

Informacje o serwerze: Linux #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64

Wersja oprogramowania serwera: Apache/2.4.10 (Debian) mod_fcgid/2.3.9 OpenSSL/1.0.1t

Wersja PHP: 5.6.30-0+deb8u1

Limit pamięci: 1024M

Maksymalny czas wykonywania: 30

Maksymalny rozmiar pliku do przesłania: 10M

Wersja MySQL: 5.5.58-0+deb8u1

Silnik MySQL: InnoDB

Wersja PrestaShop: 1.7.0.6

Edited by matthew.k (see edit history)
Link to comment
Share on other sites

Wszystkie pliki są na serwerze, wszystkie pliki posiadają uprawnienia.

Po próbie ponownego przeniesienia sklepu występują następujące błędy:

Wygląda to tak jakby próbował łączyć się do starej bazy danych, pomimo że reszta sklepu działa z nowej bazy danych.
Sprawdzałem pliki php które są podane w błędach jednak nie ma tam zapisanych danych do logowania do bazy żeby je zmienić i kompletnie nie wiem gdzie one są. 

ConnectionException in AbstractMySQLDriver.php line 103:An exception occured in driver: SQLSTATE[28000] [1045] Access denied for user 'admin_materaceps'@'localhost' (using password: YES)

  1. in AbstractMySQLDriver.php line 103
  2. at AbstractMySQLDriver->convertException('An exception occured in driver: SQLSTATE[28000] [1045] Access denied for user 'admin_materaceps'@'localhost' (using password: YES)', object(PDOException)) in DBALException.php line 145
  3. at DBALException::driverException(object(Driver), object(PDOException)) in Driver.php line 47
  4. at Driver->connect(array('driver' => 'pdo_mysql', 'host' => '127.0.0.1', 'port' => '', 'dbname' => 'admin_materaceps', 'user' => 'admin_materaceps', 'password' => 'XXXXXX', 'charset' => 'UTF8', 'driverOptions' => array(), 'serverVersion' => '5.1'), 'admin_materaceps', 'XXXXXX', array()) in Connection.php line 360
  5. at Connection->connect() in Connection.php line 833
  6. 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 ps_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
  7. at BasicEntityPersister->load(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, '1', null) in EntityRepository.php line 196
  8. at EntityRepository->findOneBy(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 80
  9. at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 134
  10. at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'last')
  11. at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'last')) in bootstrap.php.cache line 3238
  12. at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3197
  13. at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3351
  14. at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2536
  15. at Kernel->handle(object(Request), '1', false) in index.php line 86

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

  1. in PDOConnection.php line 47
  2. at PDOConnection::__construct('mysql:host=127.0.0.1;port=;dbname=admin_materaceps;charset=UTF8;', 'admin_materaceps', 'XXXXXX', array()) in Driver.php line 45
  3. at Driver->connect(array('driver' => 'pdo_mysql', 'host' => '127.0.0.1', 'port' => '', 'dbname' => 'admin_materaceps', 'user' => 'admin_materaceps', 'password' => 'XXXXXX', 'charset' => 'UTF8', 'driverOptions' => array(), 'serverVersion' => '5.1'), 'admin_materaceps', 'XXXXXX', array()) in Connection.php line 360
  4. at Connection->connect() in Connection.php line 833
  5. 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 ps_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
  6. at BasicEntityPersister->load(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, '1', null) in EntityRepository.php line 196
  7. at EntityRepository->findOneBy(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 80
  8. at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 134
  9. at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'last')
  10. at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'last')) in bootstrap.php.cache line 3238
  11. at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3197
  12. at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3351
  13. at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2536
  14. at Kernel->handle(object(Request), '1', false) in index.php line 86

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

  1. in PDOConnection.php line 43
  2. at PDO->__construct('mysql:host=127.0.0.1;port=;dbname=admin_materaceps;charset=UTF8;', 'admin_materaceps', 'XXXXXX', array()) in PDOConnection.php line 43
  3. at PDOConnection->__construct('mysql:host=127.0.0.1;port=;dbname=admin_materaceps;charset=UTF8;', 'admin_materaceps', 'XXXXXX', array()) in Driver.php line 45
  4. at Driver->connect(array('driver' => 'pdo_mysql', 'host' => '127.0.0.1', 'port' => '', 'dbname' => 'admin_materaceps', 'user' => 'admin_materaceps', 'password' => 'XXXXXX', 'charset' => 'UTF8', 'driverOptions' => array(), 'serverVersion' => '5.1'), 'admin_materaceps', 'XXXXXX', array()) in Connection.php line 360
  5. at Connection->connect() in Connection.php line 833
  6. 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 ps_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
  7. at BasicEntityPersister->load(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction'), null, null, array(), null, '1', null) in EntityRepository.php line 196
  8. at EntityRepository->findOneBy(array('employee' => '1', 'shop' => '1', 'controller' => 'ProductController', 'action' => 'catalogAction')) in AdminProductDataProvider.php line 80
  9. at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 134
  10. at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'last')
  11. at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'last')) in bootstrap.php.cache line 3238
  12. at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3197
  13. at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3351
  14. at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2536
  15. at Kernel->handle(object(Request), '1', false) in index.php line 86
Link to comment
Share on other sites

  • 2 months later...
  • 1 year later...

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