Details
-
Bug
-
Resolution: Fixed
-
Blocker
-
9.10.5
-
Windows 11 Pro, Firefox 115, using a local instance of XWiki 14.10.14 on PostgreSQL 15, Tomcat 9.0.78
-
Unknown
-
Description
Steps to reproduce
- Login as Admin
- Install Blog 9.10.5
- After installation is finished click on Wiki Home page, or click on Blog App Home page from Applications Panel
Expected results
No warning/ error is thrown.
Actual results
The following warning and error are displayed in the logs:
2023-07-28 13:49:04,221 [http-nio-8080-exec-4 - http://localhost:1113/rest/wikis/xwiki/classes/Blog.EnablePanelsConfigurationClass/properties/blog/values?fp=&limit=10] WARN o.h.e.j.s.SqlExceptionHelper - SQL Error: 0, SQLState: 42883 2023-07-28 13:49:04,221 [http-nio-8080-exec-4 - http://localhost:1113/rest/wikis/xwiki/classes/Blog.EnablePanelsConfigurationClass/properties/blog/values?fp=&limit=10] ERROR o.h.e.j.s.SqlExceptionHelper - ERROR: operator does not exist: boolean <> integer Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 290
The issue could not be reproduced when installing Blog 9.10.4.
It also seems to be reproducing only on PostgreSQL (15), as on MySQL 8, MariaDB 10.11, Oracle 19c or HSQL 2.7.2 could not be reproduced.
Reproduced on XWiki 14.10.14 and 15.5.