The Flat file enrolment plug-in generates an SQL error when calling the get_users_by_capability function. The php warning reads:

Warning - in /home/davidvm/public_html/pilot/lib/adodb/drivers/adodb-postgres7.inc.php(115): pg_query() [function.pg-query]: Query failed: ERROR: column reference "sortorder" is ambiguous

The issue seems to be that the sort parameter pass in get_users_by_capability requires an "r." prefix.

While looking for the cause of this issue I notice that get_assignable_roles function in accesslib.ph could potentially have the same problem.

I include a diff of the propose changes, I hope that helped.

Regards,

GV