Solved SP Page Builder

Error after PageBuilder update

Asked by Oleksandr 3 years ago Last activity 3 years ago

Hi
After updating PageBuilder, the frontend throws an error:

1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= ?)) AND (`a`.`publish_' at line 6

#   Function    Location
1   ()  JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141
2   Joomla\Database\Mysqli\MysqliStatement->__construct()   JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1048
3   Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900
4   Joomla\Database\DatabaseDriver->setQuery()  JROOT/components/com_sppagebuilder/helpers/articles.php:131
5   SppagebuilderHelperArticles::getArticles()  JROOT/components/com_sppagebuilder/addons/articles_scroller/site.php:96
6   SppagebuilderAddonArticles_scroller->render()   JROOT/components/com_sppagebuilder/parser/addon-parser.php:735
7   AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:415
8   AddonParser::viewAddons()   JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:100
9   include()   JROOT/libraries/src/MVC/View/HtmlView.php:410
10  Joomla\CMS\MVC\View\HtmlView->loadTemplate()    JROOT/libraries/src/MVC/View/HtmlView.php:203
11  Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_sppagebuilder/views/page/view.html.php:51
12  SppagebuilderViewPage->display()    JROOT/libraries/src/MVC/Controller/BaseController.php:639
13  Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:80
14  SppagebuilderController->display()  JROOT/libraries/src/MVC/Controller/BaseController.php:672
15  Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
16  require_once()  JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
17  Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()  JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
18  Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:355
19  Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:208
20  Joomla\CMS\Application\SiteApplication->dispatch()  JROOT/libraries/src/Application/SiteApplication.php:249
21  Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:294
22  Joomla\CMS\Application\CMSApplication->execute()    JROOT/includes/app.php:61
23  require_once()  JROOT/index.php:32

System Info:
PageBuilder 3.8.9 to 4.0.8
Joomla 4.2.9
php 8.0

Accepted answer

Marked as the solution

Oleksandr Asked this

3 years ago · edited

Now I will explain to you what really happened. Take this into service. Error 1064 was caused by the "articles scroller" addon because I had no articles. You need to add a check for this in addon. The error with "Warning: file_exists()" was caused by unpublished plugin with custom addon. Hope you will find this useful. Best regards.

7 more replies

Rashida Rahman Staff

3 years ago

Hi,

If you have SP Simple Prortfolio then you can try this:

Please uninstall your SP Simple Portfolio component by 1st unpublishing your module/extension (from the Extensions\Modules tab) and trashing it.

Then go to Extensions tab again and navigate to "Manage" and find your SP Simple Portfolio extension, then unpublish it and then 'Uninstall' from menu option.

Download a fresh copy / package of the SP Simple Portfolio Extension from JoomShaper's Extensions Download page and reinstall, then recreate a module, and its content.

PS: you are basically then disassociating the original database associated with the template and allowing the Extension upon new installation to recreate a new / blank database that will work with current version of template

You can do the same with SP Page Builder also.

Hope this helps!

Note: Please take a full site backup before trying anything!

Best Regards

Oleksandr Asked this

3 years ago · edited

Yes, error 1064 disappeared, but another one appeared:

Warning: file_exists(): open_basedir restriction in effect. File(/site.php) is not within the allowed path(s): (/home/reef/reef.ua/new:/home/reef/.system/tmp:/usr/local/pear) in /home/reef/reef.ua/new/components/com_sppagebuilder/parser/addon-parser.php on line 630

Warning: file_exists(): open_basedir restriction in effect. File(/site.php) is not within the allowed path(s): (/home/reef/reef.ua/new:/home/reef/.system/tmp:/usr/local/pear) in /home/reef/reef.ua/new/components/com_sppagebuilder/builder/classes/addon.php on line 287

There are colons in the address for some reason

Rashida Rahman Staff

3 years ago

Hi,

Glad that your initial issue has been solved already. Where are you getting this error, please? Can I have your admin access to check?

Best Regards

Oleksandr Asked this

3 years ago

First one is frontend without authorisation, second one is frontend editor

Oleksandr Asked this

3 years ago · edited

@Rashida Any solutions?

Rashida Rahman Staff

3 years ago

Hi Aleksandr,

Please take my sincere apology.

The warning is no more in your site. However, are you facing any performance issue there? Please let me know.

Best Regards

Oleksandr Asked this

3 years ago

Turning off the display errors is not a solution. But I'll test the functionality with this. Thanks.