Error 42883 On Fresh Joomla Install Using PostgreSQL - Question | JoomShaper

Error 42883 On Fresh Joomla Install Using PostgreSQL

D

Dezmond

SP Page Builder 1 year ago

Hello,

I have installed a fresh copy of Joomla and only installed Page Builder and when I try to navigate to Page Builder on the backend I get the following:

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.

Is there a specific setting that needs to be tweaked in order for Page Builder to work with PostgreSQL and 5.1.4 joomla build? Thnx

0
2 Answers
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 year ago #167881

Hi there!

Sorry for your experience.

Here is the technical requirements of SP Page Builder, Kindly check this:

https://www.joomshaper.com/documentation/sp-page-builder/technical-requirements

After fulfilling the requirements, if issue persists, then kindly share your admin acces to check the issue for you. Please keep a full site backup before giving the access.

Best Regards

0
D
Dezmond
Accepted Answer
1 year ago #167900

Thanks for your response, does it also work with PostgreSQL?

0