Jump to content

Product filter stuck, causing "500 Internal server error"


SettleR
 Share

Recommended Posts

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

image.thumb.png.689e7493d1caf5735b79f677b695add2.png

 

image.png.0f5c321c74b5ee894d42bee01dd11ea1.png

 

image.thumb.png.4a6b09cb06732feedc0214107bdbb025.png

Share this post


Link to post
Share on other sites

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"

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

7 minutes ago, PrestaServicePro said:

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

1775319052_Capturedecran2019-12-12a18_47_55.png.632033d73eddc6583632d8398bfe6bb2.png

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]

image.thumb.png.e894efc5ae354afb40f0ad4aa8b6f29d.png

Share this post


Link to post
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
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More