SP Page Builder's Hit() Method Failing On A Database Execute.
Graeme
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
Rashida Rahman
Accepted AnswerHello 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,
Graeme
Accepted AnswerThere 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
Graeme
Accepted AnswerHi Any News yet I have several site i need to update and I am worried to know if this may effect them
Graeme
Accepted AnswerYes 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