Error on opening main page (index.php) as non-admin with postgresql db

[sgm09]

Link to my forum: not online yet
SMF version: 2.1.4
TP version: 3.0.2
Default Forum Language: English
Theme name and version: default (curve2) or any theme
Browser Name and Version: firefox/chrome/any
Mods installed: no mods
Related Error messages:
/srv/http/SMF3/Sources/TPortal.php (Line 1344)
Database Error: ERROR: argument of AND must be type boolean, not type record
LINE 6: AND ( '0'' = ANY (string_to_array( var.value3, ',' )) OR ...

As described here:
https://github.com/Tinyportal/TinyPortal/issues/1050

Forum where I discovered the error after installing tinyportal, throws it on 'global moderator' member accessing the main page. On a fresh install however, I discovered that both regular user + global moderator have this bug. On a mysql test install i did, there was no bug, so this is postgres related.

They didn't like this bug being tracked on github for whatever reason and they sent me here :\

[@rjen]

They was actually ME, thank you. I did provide an explanation as well.

thanks for reporting. I saw on GitHub that you are on Php 8.4. We did not test on 8.4 yet.
Since it is Postgress related I will leave this to Tino to answer. I have no test environment to check it.