1064 mysql db error after upgrading to 4.0.3

Hi there!

Sorry about that. Would you try logging in again?

To asnwer your question, I do not use SP Simple Portfolio.

Best regards.

Any updates?? May be Paul can help?

It seems like typical of Joomshaper very poor customer support.

Hi,
I have the same problem, do you have a solution?

Thanks

Hello Ronny Ko,

I hope you are doing well.

Would you please trigger the error again with debug mode on.
You should then see the complete SQL and where exactly the problem was triggered.

With the origin of the error, I could check the source code.

According to chat support, version 4 should not be used productively yet.
That was the latest status from the pinned thread here in the forum.

Please be aware, version 4.0.3 also swallows the intotexts. "<hr id="system-readmore" />"

Hello Jens,

As per your request, here's the full debug output. Let us know what you find pleas.e

How do I find the versions prior to 4? And will it not break anything?

Call stack
#   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:384
5   SppagebuilderHelperArticles::getCategories()    JROOT/components/com_sppagebuilder/helpers/articles.php:54
6   SppagebuilderHelperArticles::getArticles()  JROOT/components/com_sppagebuilder/addons/articles/site.php:99
7   SppagebuilderAddonArticles->render()    JROOT/components/com_sppagebuilder/parser/addon-parser.php:726
8   AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:412
9   AddonParser::viewAddons()   JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:100
10  include()   JROOT/libraries/src/MVC/View/HtmlView.php:410
11  Joomla\CMS\MVC\View\HtmlView->loadTemplate()    JROOT/libraries/src/MVC/View/HtmlView.php:203
12  Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_sppagebuilder/views/page/view.html.php:51
13  SppagebuilderViewPage->display()    JROOT/libraries/src/MVC/Controller/BaseController.php:639
14  Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:80
15  SppagebuilderController->display()  JROOT/libraries/src/MVC/Controller/BaseController.php:672
16  Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
17  require_once()  JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
18  Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()  JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
19  Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:355
20  Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:200
21  Joomla\CMS\Application\SiteApplication->dispatch()  JROOT/libraries/src/Application/SiteApplication.php:241
22  Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:294
23  Joomla\CMS\Application\CMSApplication->execute()    JROOT/includes/app.php:61
24  require_once()  JROOT/index.php:32

Hello Ronny Ko,

How do I find the versions prior to 4? And will it not break anything?

Best would be a Backup, to get back to SPPB 3.x.
Some users reported, they were able to go back by deinstalling 4.x and installing 3.8.
The Support stated, there is no way to get back to 3.x when upgraded to 4.x.

Unfortunately, I can't confirm either statement, as I'm currently on SPPB 3.8 and won't be switching until 4.1 at the earliest.

Quote from the Featured thread: https://www.joomshaper.com/forum/question/16053#:~:text=I%20simply%20re%2Dinstalled%20SPPB3%20over%20a%20few%20SPPB4s%20that%20white%20screened%2C%20and%20went%20back%20to%20work.

Installing SPPB3 over SPPB4 can work.

You can find SPPB 3.x in your Downloadarea.

-> https://www.joomshaper.com/downloads/extension?start=0#:~:text=SP%20Page%20Builder%20Pro,Download

Or Search for 3.8

As per your request, here's the full debug output. Let us know what you find pleas.e

Thank you very much, I'll take a look at it later today.
A quick look at the log, the addon "Article" seems to be the cause.

4   Joomla\Database\DatabaseDriver->setQuery()  JROOT/components/com_sppagebuilder/helpers/articles.php:384
5   SppagebuilderHelperArticles::getCategories()    JROOT/components/com_sppagebuilder/helpers/articles.php:54
6   SppagebuilderHelperArticles::getArticles()  JROOT/components/com_sppagebuilder/addons/articles/site.php:99
7   SppagebuilderAddonArticles->render()    JROOT/components/com_sppagebuilder/parser/addon-parser.php:726

Support may also be able to help with the information provided.

Edit:

        $query
            ->select('*')
            ->from($db->quoteName('#__categories'))
            ->where($db->quoteName('extension') . ' = ' . $db->quote('com_content'))
            ->where($db->quoteName('published') . ' = ' . $db->quote(1))
            ->where($db->quoteName('access')." IN (" . implode( ',', Factory::getUser()->getAuthorisedViewLevels() ) . ")")
            ->where($db->quoteName('language')." IN (" . $db->Quote(Factory::getLanguage()->getTag()).", ".$db->Quote('*') . ")")
            ->where($db->quoteName('parent_id')." IN (" . implode( ',', $parent_id ) . ")")
            ->order($db->quoteName('lft') . ' ASC');

        $db->setQuery($query);

Update, I searched the forum for similar issues and found one.

https://www.joomshaper.com/forum/question/16988

Looks like that sppb is overriding a addon which causes the problems.

To make sure, you have the same issue, you can try and change the default template to cassiopeia by joomla it self.
If this works, the problem should be the same.