Product filter stuck, causing "500 Internal server error"

[SettleR]

I have a problem with my website crashing. This problem occour when i have use the filter on the product page. When i try do deselect my filter again (see picture 2) the website crash (see picture 3).

How to i solve this? Before i did this filter on the product page, everything worked fine. After i did this filter most of my actions lead to a error message (picture 3).

Is there any way to go back or reset the filter in some way? Or is this a mysql problem?

Thanks in advance

 

 

[PrestaServicePro]

Hello. Please, enable DEBUG MODE and try again to deselect filters, then you will be able to see the error. Share this error ss here.

[SettleR]

1 hour ago, PrestaServicePro said:

Hello. Please, enable DEBUG MODE and try again to deselect filters, then you will be able to see the error. Share this error ss here.

I can't do that since i get "500 Internal server error" on every function when i press "save"

[PrestaServicePro]

If you can't access you dashboard you can also enable it through FTP by accessing config/defines.inc.php and usually @line  29 you will find :

define('_PS_MODE_DEV_', false);

change it to:

define('_PS_MODE_DEV_', true);

[SettleR]

1 minute ago, PrestaServicePro said:

If you can't access you dashboard you can also enable it through FTP by accessing config/defines.inc.php and usually @line  29 you will find :

define('_PS_MODE_DEV_', false);

change it to:

define('_PS_MODE_DEV_', true);

(1/1) ContextErrorException

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

in UnitOfWork.php line 2636

at ErrorHandler->handleError(2, '"continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?', '/var/www/vhosts/agnesmode.se/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php', 2636, array('class' => 'Doctrine\\ORM\\UnitOfWork', 'e' => 32767, 'file' => '/var/www/vhosts/agnesmode.se/httpdocs/vendor/composer/../doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php'))in DebugClassLoader.php line 156

at require()in DebugClassLoader.php line 156

at DebugClassLoader->loadClass('Doctrine\\ORM\\UnitOfWork')

at spl_autoload_call('Doctrine\\ORM\\UnitOfWork')in EntityManager.php line 160

at EntityManager->__construct(object(Connection), object(Configuration), object(ContainerAwareEventManager))in EntityManager.php line 850

at EntityManager::create(object(Connection), object(Configuration))in appDevDebugProjectContainer.php line 1315

at appDevDebugProjectContainer->getDoctrine_Orm_DefaultEntityManagerService()in Container.php line 306

at Container->get('doctrine.orm.default_entity_manager')in ManagerRegistry.php line 48

at ManagerRegistry->getService('doctrine.orm.default_entity_manager')in AbstractManagerRegistry.php line 231

at AbstractManagerRegistry->getManagers()in ProxyCacheWarmer.php line 49

at ProxyCacheWarmer->warmUp('/var/www/vhosts/agnesmode.se/httpdocs/var/cache/dev')in CacheWarmerAggregate.php line 52

at CacheWarmerAggregate->warmUp('/var/www/vhosts/agnesmode.se/httpdocs/var/cache/dev')in Kernel.php line 680

at Kernel->initializeContainer()in Kernel.php line 135

at Kernel->boot()in Kernel.php line 195

at Kernel->handle(object(Request), 1, false)in index.php line 88

[PrestaServicePro]

What is the your PHP and PS version?

[SettleR]

24 minutes ago, PrestaServicePro said:

What is the your PHP and PS version?

PS version 1.7.5.2

PHP version 7.3.7

I have tried to update PS but since this error starting to occour i cant install the "auto update" module.

I have also got a new server host with a updated PHP version, but i have no idea how to transfer the site over to the new one since i cant do any decent backups or anything due to the error message.

I just find it strange that it worked until i did this filter thing on the product page....

[PrestaServicePro]

Check the image please, and set right PHP version depending on your PS. And try again to access shop.

[SettleR]

7 minutes ago, PrestaServicePro said:

Check the image please, and set right PHP version depending on your PS. And try again to access shop.

I changed the php version to 7.2. Got the same error when trying to edit something (505 internal...) ..

 

i changed config again to "true", got this message now,

 

[PrestaShopDatabaseException]

UPDATE command denied to user 'prestashop_09'@'shwl-0055.s.thehostingplatform.com' for table 'ps_employee'
 

UPDATE `ps_employee` SET `last_connection_date` = CURRENT_DATE() WHERE `id_employee` = 1 AND `last_connection_date`< CURRENT_DATE()

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

764. if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, '

 ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. }

DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments]

DbCore->query - [line 566 - classes/db/Db.php] - [1 Arguments]

DbCore->execute - [line 649 - classes/Employee.php] - [1 Arguments]

EmployeeCore::setLastConnectionDate - [line 2812 - classes/controller/AdminController.php] - [1 Arguments]

AdminControllerCore->init - [line 262 - classes/controller/Controller.php]

ControllerCore->run - [line 511 - classes/Dispatcher.php]

DispatcherCore->dispatch - [line 99 - admin/index.php]

[PrestaServicePro]

Hmm, it seems, there is now "Privileges problem on MySQL User Account".  Contact host provider (or do it by yourself) set all grant accesses to current user, then check again.

[musicmaster]

Don't forget to clear the cache after changing the php version.