SP Page Builder 6.4.0 Issues With Hits - Question | JoomShaper

SP Page Builder 6.4.0 Issues With Hits

RP

Roberto Parisotto

SP Page Builder 1 day ago

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

0
5 Answers
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 day ago #223819

Hi there!

I hope you’re doing well. I’m sorry for the experience you’ve had so far.

To look into this issue more closely, could you please share temporary Super Admin access (inside the hidden content box)? I’ll check this and update you as soon as possible.

Please make sure to keep a full site backup before sharing the credentials, just to be safe.

Best regards,

0
RP
Roberto Parisotto
Accepted Answer
1 day ago #223825

Hi, I share temporary access in the hidden box.

0
RP
Roberto Parisotto
Accepted Answer
1 day ago #223826

Hi, since we have RSFirewall installed, I need to know which country you're connecting from to grant you administrative access; Bangladesh and the US are enabled.

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 9 hours ago #223897

Thanks for the access. I'm from Bangladesh and I can log in.

Would you please help me about where should I get the error?

0
RP
Roberto Parisotto
Accepted Answer
6 hours ago #223899

Hi Rashida, /administrator/logs/everything.php if you search: /components/com_sppagebuilder/models/page.php(137): Joomla\CMS\Table\Table->hit() you'll find many errors

0