search

Admidio / admidio

Admidio is a free open source user management system for websites of organizations and groups. The system has a flexible role model so that it’s possible to reflect the structure and permissions of your organization.
https://www.admidio.org
GNU General Public License v2.0
307 stars 123 forks source link

SQL Error in List Configuration when multiple Roles selected #1586

Closed ttytrekker closed 3 months ago

ttytrekker commented 4 months ago

Describe the bug S Q L - E R R O R CODE: HY000 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'admidio43.mem.mem_leader' which is not in SELECT list; this is incompatible with DISTINCT

B A C K T R A C E FILE: adm_program/system/classes/Database.php LINE: 797

CALL: Database->showError() FILE: adm_program/system/classes/ListData.php LINE: 213 CALL: Database->queryPrepared()

FILE: adm_program/system/classes/ListData.php LINE: 198 CALL: ListData->setDataBySql()

FILE: adm_program/modules/groups-roles/lists_show.php LINE: 230 CALL: ListData->setDataByConfiguration()

To Reproduce

  1. Go to List Configuration and select any list.
  2. From Select Members add two or more Roles.
  3. Click Display List to generate error.

Expected behavior List is displayed based on selection criteria.

Screenshots

Screenshot 2024-02-13 at 12 38 16 PM Screenshot 2024-02-13 at 12 42 06 PM

System (please complete the following information):

Additional context None.

Fasse commented 3 months ago

Thanks for the detailed error report. This is fixed within the next version.

ttytrekker commented 3 months ago

Like your app and happy to help.