matthew.k Posted March 26, 2018 Share Posted March 26, 2018 (edited) 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 March 26, 2018 by matthew.k (see edit history) Link to comment Share on other sites More sharing options...
Przemysław Suszek Posted March 27, 2018 Share Posted March 27, 2018 Rozumiem żę dwa ww pliki znajdują się na serwerze ? Uprawnienia do plików są poprawne ? Logi z serwera mówią coś więcej ? Link to comment Share on other sites More sharing options...
matthew.k Posted March 30, 2018 Author Share Posted March 30, 2018 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) in AbstractMySQLDriver.php line 103 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 at DBALException::driverException(object(Driver), object(PDOException)) in Driver.php line 47 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 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 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 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 80 at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 134 at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'last') at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'last')) in bootstrap.php.cache line 3238 at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3197 at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3351 at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2536 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) in PDOConnection.php line 47 at PDOConnection::__construct('mysql:host=127.0.0.1;port=;dbname=admin_materaceps;charset=UTF8;', 'admin_materaceps', 'XXXXXX', array()) in Driver.php line 45 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 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 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 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 80 at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 134 at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'last') at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'last')) in bootstrap.php.cache line 3238 at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3197 at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3351 at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2536 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) in PDOConnection.php line 43 at PDO->__construct('mysql:host=127.0.0.1;port=;dbname=admin_materaceps;charset=UTF8;', 'admin_materaceps', 'XXXXXX', array()) in PDOConnection.php line 43 at PDOConnection->__construct('mysql:host=127.0.0.1;port=;dbname=admin_materaceps;charset=UTF8;', 'admin_materaceps', 'XXXXXX', array()) in Driver.php line 45 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 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 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 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 80 at AdminProductDataProvider->getPersistedFilterParameters() in ProductController.php line 134 at ProductController->catalogAction(object(Request), 'last', '0', 'last', 'last') at call_user_func_array(array(object(ProductController), 'catalogAction'), array(object(Request), 'last', '0', 'last', 'last')) in bootstrap.php.cache line 3238 at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3197 at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3351 at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2536 at Kernel->handle(object(Request), '1', false) in index.php line 86 Link to comment Share on other sites More sharing options...
nillo23 Posted June 7, 2018 Share Posted June 7, 2018 Witam udało się koledze rozwiązać ten problem? Mam podobnie tylko w trybie debugu działa lista produktów i dodatkowo to samo z listą modułów zauważyłem Link to comment Share on other sites More sharing options...
Cawe Posted August 1, 2019 Share Posted August 1, 2019 Witam serdecznie. Po przywróceniu kopii sklepu posiadam dokładnie ten sam błąd ? Udało może dojść się do rozwiązania ? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now