[3186][3190] Cannot delete members (PostgreSQL)

[MegaByte]

Under SMF2.0RC1, I get the following error when trying to delete a member:

ERROR: operator does not exist: boolean <> integer
LINE 2: ...id_group = 1 OR FIND_IN_SET(1, additional_groups) != 0 THEN ...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
File: /usr/local/apache-tomcat6.0/webapps/ROOT/forums/Sources/Subs-Members.php
Line: 139

This is another integer-> boolean casting problem.  I manually added a typecast, after which I received the following error message:

ERROR: column "recipient" does not exist
LINE 8: HAVING recipient IS null
^
File: /usr/local/apache-tomcat6.0/webapps/ROOT/forums/Sources/PersonalMessage.php
Line: 2551

[karlbenson]

Thanks for reporting.

Can't delete members - I reported that one on our tracking only an hour or so ago.
http://dev.simplemachines.org/mantis/view.php?id=3186

[MegaByte]

I guess http://dev.simplemachines.org/mantis/view.php?id=3190 is the second half of this bug.

[karlbenson]

No, I missed the second part actually. LOL.
Then found it myself will bugtesting pgl.

LOL.
So yeah, http://dev.simplemachines.org/mantis/view.php?id=3190
I added a possible fix to that bug report.