Error After PageBuilder Update - Question | JoomShaper

Error After PageBuilder Update

Aleksandr

Aleksandr

SP Page Builder 1 year 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

0
8 Answers
Aleksandr
Aleksandr
Accepted Answer
11 months ago #111526

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.

0
Aleksandr
Aleksandr
Accepted Answer
11 months ago #111515

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

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 11 months ago #111351

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

0
Aleksandr
Aleksandr
Accepted Answer
1 year ago #109941

@Rashida Any solutions?

0
Aleksandr
Aleksandr
Accepted Answer
1 year ago #109777

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

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 year ago #109558

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

0
Aleksandr
Aleksandr
Accepted Answer
1 year ago #109349

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

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 year ago #109343

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

0