Hello, we have a client with a Joomla 5.4.5 site with Templaza templates (Astroid Version: 3.4.0, Jollyany Version: 3.5.43) that also includes SP Page Builder Current Version: 6.4.0 and SP Page Builder Addons Current Version: 3.5.20.
Apache hosting with PHP 8.3.
We updated the Builder about 10 days ago to 6.4.0, and the site occasionally slows down, throwing a 500 error and a 1615 database error for a few minutes. There are no CPU, memory, or process spikes in the server dashboard at that time.
The following log appears in the PHP errors file:
CRITICAL (IP address) error Uncaught Throwable of type Joomla\Database\Exception\ExecutionFailureException thrown with message "Prepared statement needs to be re-prepared". Stack trace: #0 [ROOT]/libraries/vendor/joomla/database/src/DatabaseDriver.php(651): Joomla\Database\Mysqli\MysqliStatement->execute()
1 [ROOT]/libraries/src/Table/Table.php(1411): Joomla\Database\DatabaseDriver->execute()
2 [ROOT]/components/com_sppagebuilder/models/page.php(137): Joomla\CMS\Table\Table->hit()
3 [ROOT]/components/com_sppagebuilder/controller.php(82): SppagebuilderModelPage->hit()
4 [ROOT]/libraries/src/MVC/Controller/BaseController.php(730): SppagebuilderController->display()
5 [ROOT]/components/com_sppagebuilder/sppagebuilder.php(33): Joomla\CMS\MVC\Controller\BaseController->execute()
etc. ...
It seems that counting these "hits" is tying up the database, and we'd like to disable it, but I can't find a command in the Builder settings.
Is this possible? Have you encountered similar software issues?
Thanks