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 2 months 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
12 Answers
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 2 months 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
2 months ago #223825

Hi, I share temporary access in the hidden box.

0
RP
Roberto Parisotto
Accepted Answer
2 months 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 2 months 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
2 months 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
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 2 months ago #223972

Hi,

Could you please check again now and let me know whether you still encounter the error:

Prepared statement needs to be re-prepared

mentioned in your post?

Best regards,

0
RP
Roberto Parisotto
Accepted Answer
2 months ago #223974

Hi, The last error is: 2026-05-13T14:13:26+00:00 CRITICAL 162.120.187.141 error Uncaught Throwable of type Joomla\Database\Exception\ExecutionFailureException thrown with message "Prepared statement needs to be re-prepared" I haven't seen any errors like that in the everything.php log for about 12 hours. Have you made any changes? We suspended the Meta/Facebook campaign today, which was causing a lot of crawler access. We suspected that too many accesses were causing resource saturation and errors.

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 2 months ago #224024

Hi,

Yes, I have changed the database type to MySQL (PDO).

Path : In Global Configuration > Server > Database > Database Type : MySQL (PDO).

Please check now and do let me know if it is working fine at your end.

Best regards,

0
RP
Roberto Parisotto
Accepted Answer
1 month ago #224109

Hi, It seems to me that those errors didn't appear yesterday or today. However, we suspected they were caused by heavy bot traffic related to Facebook, so we suspended Meta campaigns two days ago; as a result, the site is receiving less traffic. We'll see if the error recurs. Thanks, Rashida.

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 month ago #224126

Hello,

Thanks for the feedback!

Glad to hear that the errors have not appeared again so far.

Best regards,

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 month ago #224399

Hello,

I haven’t heard back from you regarding this issue. Could you please confirm if everything is working fine now? If so, kindly accept the most helpful answer to close the post.

Best regards,

0
RP
Roberto Parisotto
Accepted Answer
1 month ago #224721

Hi, while monitoring PHP errors, I haven't encountered any problems like this in the last few days. Close this post, thanks a lot, Rashida.

0