Urgent: Error 1054 With Menus Using Tags - Question | JoomShaper

Urgent: Error 1054 With Menus Using Tags

JP

Jean-Marie Putz

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

0
31 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #169623

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)

0
JP
Jean-Marie Putz
Accepted Answer
1 year ago #169625

Thank for the quick reply

0
JP
Jean-Marie Putz
Accepted Answer
1 year ago #169627

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #169706

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

0
JP
Jean-Marie Putz
Accepted Answer
1 year ago #169710

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...

0
JP
Jean-Marie Putz
Accepted Answer
1 year ago #169711

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

0
JP
Jean-Marie Putz
Accepted Answer
1 year ago #169715

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #169749

Please check now. Thanks

0
JP
Jean-Marie Putz
Accepted Answer
1 year ago #169780

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #169795

You are most welcome & Thanks

0
JP
Jean-Marie Putz
Accepted Answer
1 year ago #169799

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?

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #169802

Here is the patch.

0
A
Andrea
Accepted Answer
1 year ago #170053

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #170061

Download this patch and install this build on your site.

https://drive.google.com/file/d/1vqUm8GvIib4Dt71ZbToVxZN2KwJ0EKCN/view

0
A
Andrea
Accepted Answer
1 year ago #170184

Thanks it works !

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #170244

You are most welcome & Thanks

0
TC
thibaud chevalier
Accepted Answer
1 year ago #170401

Thanks ^_^

0
TomaszGrzechnik
TomaszGrzechnik
Accepted Answer
1 year ago #170487

Hi Toufiq, I have the same problem with tags: 1054 Unknown column 'Array' in 'where clause'

I download your patch but I can't install it...

Any solution?

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #170490

Could you kindly grant me access to your Joomla administrator area so that I can investigate the issue you're experiencing? Prior to providing access, please ensure that you have backed up your site. Additionally, it's important to note that providing login credentials is entirely voluntary on your part; we respect your decision either way. However, if you do choose to share the login details, it would greatly expedite the resolution process. Thank you for your cooperation.

0
TomaszGrzechnik
TomaszGrzechnik
Accepted Answer
1 year ago #170493

In hidden content I send you credentials

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #170496

Please check now and which page occurred the problem?

0
TomaszGrzechnik
TomaszGrzechnik
Accepted Answer
1 year ago #170505

Oooo !!! Works !!! All problems was on \blog pages with articles

Please tell me what was a problem?

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #170509

I just installed the patch build. Thanks

0
TomaszGrzechnik
TomaszGrzechnik
Accepted Answer
1 year ago #170783

Hi Toufiq, when will be new version with patch? On other site I have the same problem. Temporary I revert to 5.3.8 version without bug.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #170896

We will release it next week. Thanks

0
A
Addington
Accepted Answer
1 year ago #171093

Error 1054 With Menus Using Tags - I have this problem too and i solved it by reinstalling 5.3.6.
Maybe you should take down version 5.3.8 so that no one else tries to update to it?

I'd appreciate it if you would confirm on this chat that the problem is resolved when you release 5.3.9 so i can check here before installing the next version.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #171104

We have solved this issue. I hope it will release it in this week. Thanks

0
M
Michał Brennek
Accepted Answer
1 year ago #171493

Quick reply - bought the SP builder pro and have the same issue tags are not working. Should I wait for the next release or is there a workaround? Please help.

0
A
Addington
Accepted Answer
1 year ago #171496

can you download and install an earlier version? that's what worked for me

0
M
Michał Brennek
Accepted Answer
1 year ago #171498

Installed the Toufiks patch and it is perfect now

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #171541

Please check the latest version. Thanks

0