SP Page Builder's Hit() Method Failing On A Database Execute. - Question | JoomShaper

Celebrate JoomShaper's Sweet 16 with Flat 35% OFF!

SP Page Builder's Hit() Method Failing On A Database Execute.

G

Graeme

SP Page Builder 3 months ago

Hi. I upgraded to page builder 6.3.1, and it's crashed my website. stack trace is specific — it's SP Page Builder's hit() method failing on a database execute. The SP Page Builder update (6.2.2→6.3.1) ran a schema migration on the #__sppagebuilder table, and MySQL's prepared statement cache still has the old table definition.

But → System → Maintenance → Database The scan may show no errors because Joomla only checks core tables by default — but if SP Page Builder added a new column, force a repair anyway by clicking Fix on all tables. No Changes I have requested a system restore on my server, but if you have any insight into this problem it would be useful.

Site is a staging site as Move from Wordpress

Admin Area works But Has checked out two tables agtf5_sppagebuilder unchecking thes pulls the same error in the backend

0
9 Answers
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 3 months ago #220272

Hello 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 of your staging site(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.

Note: Did you try to clear your Joomla and browser caches deeply, please?

Best regards,

0
G
Graeme
Accepted Answer
3 months ago #220276

There are no errors in the database nothing to fix I have cleared the Cache but the front has failed
() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:411 2 Joomla\Database\Mysqli\MysqliStatement->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:651 3 Joomla\Database\DatabaseDriver->execute() JROOT/libraries/src/Table/Table.php:1411 4 Joomla\CMS\Table\Table->hit() JROOT/components/com_sppagebuilder/models/page.php:137 5 SppagebuilderModelPage->hit() JROOT/components/com_sppagebuilder/controller.php:82 6 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:730 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:33 8 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 9 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 10 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 11 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:217 12 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:271 13 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:304 14 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:58 15 require_once() JROOT/index.php:51

I have cleard the cache and browser Cache The Admin Area works But Has checked out two tables agtf5_sppagebuilder unchecking thes pulls the same error in the backend

0
G
Graeme
Accepted Answer
2 months ago #221388

Hi Any News yet I have several site i need to update and I am worried to know if this may effect them

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

Hello,

Sorry for the unwanted delay!

Can I take an akeeba backup of your site? Or can I change anything without the fear of any trouble there. Although you said it's an staging site, but I wanted to be sure.

Thanks for your cooperation.

0
G
Graeme
Accepted Answer
2 months ago #221407

Yes You can take a backup the the server Backup every days and keeps a snapshot for 3 weeks so i dont normally do backups i just ask for it to be restored fron the day before the issue

But if you would an akeeba abackup help your self I just dont keep them on the server onece made

0
G
Graeme
Accepted Answer
2 months ago #222446

Any news on this

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

Hi,

Please accept my apologies.

I have updated your SP Page Builder to the latest, then changed the database type to MySQL (PDO).

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

https://cleanshot.com/share/WQ9wlFBV

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

Best regards,

0
G
Graeme
Accepted Answer
1 month ago #223970

Hi Thank For Thta I Had been Chaning My other sites to pdomysql But Left This site incase it was a different problem it was not the same error i got on other site. Thank For Fixing I Can soon start my Migration To Joomla 6

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

You arealways welcome:)

Have a nice day!

0