Some groups show up twice in the group listing when searching for groups

[Kristina Hoeppner]

on Mahara 1.4alpha / master.dev

When I search for a group in "Find Groups", some groups show up twice in the list. The URL and description are the same. However, the user count can be a different one, e.g. https://skitch.com/anitsirk/rpsn1/find-groups-myportfolio-schools (Richard, Francois, Sean: That's on MyPortfolio) and the attached screenshot.

This behavior is confusing because one thinks that the group exists twice.

[Ruslan Kabalin (rkabalin)]

That is an interesting one, notice that the group members counter is not correct either.

The bug has been introduced long time ago in a487b737, but thanks to 52522d7f (get_records_sql_assoc replacement), it became apparent only month ago. User role field had nothing to do with the "current user" as it did not take in account the ID of the current user.