[J4][J3] maximum statement execution time exceeded

[mjmartino]

Hi Jan
I have a problem with searching in phoca product and filter in the administrator.
I have a this error.
Joomla 3
500 Query execution was interrupted, maximum statement execution time exceeded.

I check on two servers, and problem still exist.

Phoca: 3.5.7 on Joomla 3
Phoca: 4.0.11 on Joomla 4

Joomla 4

Code: Select all

 Commands out of sync; you can't run this command now Commands out of sync; you can't run this command now
Call stack
#	Function	Location
1	()	JROOT/administrator/components/com_phocacart/views/phocacartitems/view.html.php:49
2	PhocaCartCpViewPhocaCartItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:660
3	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_phocacart/controller.php:92
4	phocaCartCpController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:693
5	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_phocacart/phocacart.php:28
6	require_once()	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
7	Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
8	Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()	JROOT/libraries/src/Component/ComponentHelper.php:361
9	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/AdministratorApplication.php:143
10	Joomla\CMS\Application\AdministratorApplication->dispatch()	JROOT/libraries/src/Application/AdministratorApplication.php:186
11	Joomla\CMS\Application\AdministratorApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:293
12	Joomla\CMS\Application\CMSApplication->execute()	JROOT/administrator/includes/app.php:61
13	require_once()	JROOT/administrator/index.php:32

I think this is something to do it if products have a lot of Attributes.

Any advice ? how to fix.

[Jan]

Hi, I think, you or your hosting administrator need to increase the limit for max_execution_time parameter in your database settings when this is a problem.

Jan

[mjmartino]

Problem is in DB phocacart_product_stock - 26,674 records. I think this not should any impact on filter in administrator.
Maybe there is a query that checks this table, which can cause filtering in the backend to timeout.

[Jan]

Hi, you should check this table, it is not normal that this table have over 26000 records, how many products do you have?

Jan

[mjmartino]

Sorry for late respond.
Maybe all 50 products + many variants.
I think it happened during the negative magazine setup.

I'm just posting information. Perhaps my predecessor admin built the store from some copy and hence the number.