Problem SP Pagebuilder 5.4.0 - mysqli_sql_exception - Forum | JoomShaper
Staff replied SP Page Builder

Problem SP Pagebuilder 5.4.0 - mysqli_sql_exception

Asked by ssnobben 2 years ago Last activity 2 years ago

Hi got this reports from Admin Tools raining now after update to new SP Pagebuilder v 5.4.0.

What to do to get rid of this?

see here:

A PHP Exception occurred on your site. Here you can find the stack trace:
Exception Type: mysqli_sql_exception
File: /var/www/site/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php
Line: 138
Message: Unknown column 'Array' in 'where clause'
#0 /var/www/site/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php(138): mysqli->prepare()
#1 /var/www/site/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(1020): Joomla\Database\Mysqli\MysqliStatement->construct()
#2 /var/www/site/libraries/vendor/joomla/database/src/DatabaseDriver.php(1785): Joomla\Database\Mysqli\MysqliDriver->prepareStatement()
#3 /var/www/site/plugins/system/sppagebuilder/sppagebuilder.php(270): Joomla\Database\DatabaseDriver->setQuery()
#4 /var/www/site/libraries/src/Plugin/CMSPlugin.php(289): plgSystemSppagebuilder->onBeforeRender()
#5 /var/www/site/libraries/vendor/joomla/event/src/Dispatcher.php(454): Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin\{closure}()
#6 /var/www/site/libraries/vendor/joomla/application/src/AbstractApplication.php(99): Joomla\Event\Dispatcher->dispatch()
#7 /var/www/site/libraries/src/Application/CMSApplication.php(1063): Joomla\Application\AbstractApplication->dispatchEvent()
#8 /var/www/site/libraries/src/Application/SiteApplication.php(732): Joomla\CMS\Application\CMSApplication->render()
#9 /var/www/site/libraries/src/Application/CMSApplication.php(311): Joomla\CMS\Application\SiteApplication->render()
#10 /var/www/site/includes/app.php(58): Joomla\CMS\Application\CMSApplication->execute()
#11 /var/www/site/index.php(32): require_once('...')
#12 {main}
Request information
GET variables
Array
(
)
POST variables
Array
(
)
COOKIE variables
Array
(
)
REQUEST variables
Array
(
)
SERVER variables
Array
(
    [REDIRECT_HTTP_AUTHORIZATION] => 
    [REDIRECT_HTTPS] => on
    [REDIRECT_SSL_TLS_SNI] => site
    [REDIRECT_STATUS] => 200
    [HTTP_AUTHORIZATION] => 
    [HTTPS] => on
    [SSL_TLS_SNI] => site
    [HTTP_ACCEPT_ENCODING] => gzip, deflate, br
    [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36
    [HTTP_HOST] => site
    [HTTP_FROM] => bingbot(at)microsoft.com
    [HTTP_ACCEPT] => */*
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    [SERVER_SIGNATURE] => 
    [SERVER_SOFTWARE] => Apache/2.x.xx (Ubuntu)
    [SERVER_NAME] => site
    [SERVER_ADDR] => xxxxxxxxxxx
    [SERVER_PORT] => 443
    [REMOTE_ADDR] => 52.167.144.137
    [DOCUMENT_ROOT] => /var/www/site
    [REQUEST_SCHEME] => https
    [CONTEXT_PREFIX] => 
    [CONTEXT_DOCUMENT_ROOT] => /var/www/site
    [SERVER_ADMIN] => webmaster@site
    [SCRIPT_FILENAME] => /var/www/site/index.php
    [REMOTE_PORT] => 11487
    [REDIRECT_URL] => /en/component/tags/tag
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => 
    [REQUEST_URI] => /en/component/tags/tag
    [SCRIPT_NAME] => /index.php
    [PHP_SELF] => /index.php
    [REQUEST_TIME_FLOAT] => 1728305003.8961
    [REQUEST_TIME] => 1728305003
)

1 reply

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)

Log in to reply.