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
Hello 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,
Hello! 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
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.
To 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,
In 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.
In that case, please take a backup using Akeeba Backup in ZIP format and share it with me. This will allow me to investigate the issue on my end.
Thank you!
I'm having the same error here. When installing joomla 6 + PostgreSQL + Helix Uktimate 2.2.0 + SP Page Builder 6.1.0.
I apologize for the delayed response.
Please create a separate post for this issue and include a screenshot of the problem.
Thank you.
Thank you. I switched hosting providers, and now everything is working correctly.
You are welcome.
