Urgent: Error 1054 with menus using tags - Forum | JoomShaper
Solved SP Page Builder

Urgent: Error 1054 with menus using tags

Asked by Jean-Marie Putz 2 years ago Last activity 2 years ago

Since today, I get systematically the error
1054
Unknown column 'Array' in 'where clause'

when using any menu option using tags.
In debug mode, it seems to be related to sppagebuilder.

Erreur: 1054
1054
Unknown column 'Array' in 'where clause'
Call Stack

Function Location

1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1020
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1785
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/plugins/system/sppagebuilder/sppagebuilder.php:270
6 plgSystemSppagebuilder->onBeforeRender() JROOT/libraries/src/Plugin/CMSPlugin.php:289
7 Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin{closure}() JROOT/libraries/vendor/joomla/event/src/Dispatcher.php:454
8 Joomla\Event\Dispatcher->dispatch() JROOT/libraries/vendor/joomla/application/src/AbstractApplication.php:99
9 Joomla\Application\AbstractApplication->dispatchEvent() JROOT/libraries/src/Application/CMSApplication.php:1061
10 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:732
11 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:311
12 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:58
13 require_once() JROOT/index.php:32

The problem is very urgent, as if affects deeply my website based menus using tags... AND I leave tomorrow for a couple of weeks, so I will not be in state to make an update. I installed the last version today. Is there a way to go back to previous version without having to restore the entire site?

Accepted answer

Marked as the solution
Toufiq Senior Staff

Here is the patch.

16 more replies

Toufiq Senior Staff

Hi there,

Thank you for reaching out, and I apologize for any inconvenience caused by this oversight. To better address the issue, could you kindly provide Joomla administrator access? This will enable me to thoroughly investigate the matter and provide you with a prompt resolution.

I appreciate your cooperation and will ensure to get back to you as soon as possible.

Best regards,

Toufiqur Rahman (Team Lead, Support)

Jean-Marie Putz Asked this

Thank for the quick reply

Jean-Marie Putz Asked this

To reproduce the problem, take a menu option (the site is trilingual...) so depending on the language you use, choose Patrimoine (or Heritage or Erfgoed), then chose Monument by country and select a country. Same problem in all languages and nearly all submenus.|I hope this helps

Toufiq Senior Staff

I have checked no problem found. Can you share a screencast video?

Jean-Marie Putz Asked this

Did I see correctly you put the site in debug mode?
I'sorry I will have to leave for the airport in 20 minutes, no time to provide a screencast...

I am trying it right now, and some things are working, but for others the error message has becone 404 now. Could this be a cache problem, because I was working at cache enhancement earlier...

Jean-Marie Putz Asked this

I cleared all cache, and the problem is occuring again, same 1054 error.

TO reproduce it, just try to use the menu nest to Video (in French it is Patrimoine, in English Heritage and in Dutch Erfgoed). There you should get a list of countries, just click a country , for instance India, and you will get the problem immediateley...

Sorry I cannot help more at this time.

Is it not possible to reinstall the previous version of SP Pagebuilder? It occured after the last update.

Thanks for your efforts

Jean-Marie Putz Asked this

I am not a specialist, but may be this could help: My impression it happens from the third level of tags.

For instance: Heritage/Architecture/India , while Heritage/Architecture seem to get results.

I hope I am clear enough, and that this can help you to investigate further

Toufiq Senior Staff

Please check now. Thanks

Jean-Marie Putz Asked this

at the firsr sight it is working now .
thanks a lot
have a good day

Toufiq Senior Staff

You are most welcome & Thanks

Jean-Marie Putz Asked this

Can you tell me in short what the issue was related to? In order for me to decide if I will install the next version as soon as announced, please?

Andrea

Hi, I have same problem with all link to TAGS : error 1054 Unknown column 'Array' in 'where clause'
here : www.federvini.it
The website is live so I have created a remporary redirect from https://www.federvini.it/tag-list/..... to homepage to avoid hundreds of errors.

Any suggestion to solve this ?

Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1020
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1785
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/plugins/system/sppagebuilder/sppagebuilder.php:270
6 plgSystemSppagebuilder->onBeforeRender() JROOT/libraries/src/Plugin/CMSPlugin.php:289
7 Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin{closure}() JROOT/libraries/vendor/joomla/event/src/Dispatcher.php:454
8 Joomla\Event\Dispatcher->dispatch() JROOT/libraries/vendor/joomla/application/src/AbstractApplication.php:99
9 Joomla\Application\AbstractApplication->dispatchEvent() JROOT/libraries/src/Application/CMSApplication.php:1061
10 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:732
11 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:311
12 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:58
13 require_once() JROOT/index.php:32

Andrea

Thanks it works !

Toufiq Senior Staff

You are most welcome & Thanks

Log in to reply.