You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
As per the comment in includes/Hooks.php, PostgreSQL doesn't use the IFNULL() function, it has a COALESCE() function.
In includes/Query.php at lines 1908 and 1915, the SELECT statement being constructed is using IFNULL() without testing what the database type is first.
Attached is a quick patch that does seem to do the trick, though extra checks, etc. may be required.
As per the comment in includes/Hooks.php, PostgreSQL doesn't use the IFNULL() function, it has a COALESCE() function.
In includes/Query.php at lines 1908 and 1915, the SELECT statement being constructed is using IFNULL() without testing what the database type is first.
Attached is a quick patch that does seem to do the trick, though extra checks, etc. may be required.
Thanks.
ivan.
Query.php.patch.txt
The text was updated successfully, but these errors were encountered: