ckimrie/cki.member_list.ee_addon — pull request #4 by thisisrobyn (2012-11-26 19:33:05+00:00)
Title: disambiguation of member_id on line 34

Changed line 34 to include the table name exp_members to disambiguate field name member_id. Seemed to work, but please check for yourself.

I had installed this field type, then added a channel field that used the field type. Tried to publish a new entry in the relevant channel, and got the following error:

=======

A Database Error Occurred

Error Number: 1052

Column 'member_id' in field list is ambiguous

SELECT `group_title`, `member_id`, `screen_name` FROM (`exp_members`) JOIN `exp_member_groups` ON `exp_members`.`group_id` = `exp_member_groups`.`group_id` JOIN `exp_member_data` ON `exp_member_data`.`member_id` = `exp_members`.`member_id` ORDER BY `exp_member_groups`.`group_id` asc, `exp_members`.`screen_name`

Filename: third_party/cki_mblist/ft.cki_mblist.php

Line Number: 42