42883 42883, 7, ERROR: Operator does Not Exist
Alejandra Lopez
Hello i'm havin a problem, i got a fresh installation of joomla and also a fresh install of sp page builder pro, but when a i try to use it i have the next message: 42883 42883, 7, ERROR: operator does not exist: character varying = integer LINE 3: WHERE "client_id" = 0 AND "home" = 1 ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
I'm using joomla 5.2.1, Mysql 8.0.35 Community Server - GPL and debian 12 as server.
Thanks
Ziaul Kabir
Accepted AnswerHello Alejandra,
Thank you for reaching out to us.
To begin troubleshooting, please enable the debug system by navigating to:
System > Global Configuration > System and set Debug System to “Yes.”
Then, go to
Server and set Error Reporting to “Maximum.”
After making these changes, check where the issue originates and let me know the details.
Thank you,
Alejandra Lopez
Accepted AnswerHello! Thanks in advance for the help. Here I show you the result after doing what it mentions.
An error has occurred.
42883 42883, 7, ERROR: operator does not exist: character varying = integer LINE 3: WHERE "client_id" = 0 AND "home" = 1 ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
Call Stack
FunctionLocation
1 () JROOT/libraries/vendor/joomla/database/src/Pdo/PdoDriver.php:452 2 Joomla\Database\Pdo\PdoDriver->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1336 3 Joomla\Database\DatabaseDriver->loadResult() JROOT/components/com_sppagebuilder/helpers/helper.php:1873 4 SppagebuilderHelperSite::getTemplate() JROOT/components/com_sppagebuilder/helpers/helper.php:1830 5 SppagebuilderHelperSite::loadLanguage() JROOT/administrator/components/com_sppagebuilder/sppagebuilder.php:31 6 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 7 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 8 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 9 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:150 10 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:195 11 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:306 12 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:58 13 require_once() JROOT/administrator/index.php:32
Thank you.
Ziaul Kabir
Accepted AnswerTo investigate the issue further, I need administrator access to your site. This will allow me to check the problem directly and provide a proper solution.
Please ensure you take a full backup of your site before sharing access as a precaution.
Thank you,
Alejandra Lopez
Accepted AnswerIn that aspect, it is complicated to give you access to the server via ssh since the security administration is very rigorous and is not part of my department.