CMS MADE SIMPLE FORGE

Newsletter Made Simple

 
Back Back to List

[#12409] Lists and users not displayed in the admin section

avatar
Created By: agi webconseil (siohan)
Date Submitted: Sun Jan 31 02:11:54 -0500 2021

Assigned To: Robert Campbell (calguy1000)
Version: 2.13.3
CMSMS Version: 2.2.15
Severity: Major
Resolution: None
State: Open
Summary:
Lists and users not displayed in the admin section
Detailed Description:
That is the error in line 53 of function.admin_list_tab.php
Expression #2 of SELECT list is not in GROUP BY clause and contains
nonaggregated column 'phoenix.L.name' which is not functionally dependent on
columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by


History

Comments
avatar 
Date: 2021-08-30 06:09
Posted By: Gabor Horvath (zsiri)

Dear agi webconseil,

What version of PHP and MySQL are you using? I experience the same error (PHP
7.4.3, MySQL 8.0.26) and I don't know how to fix it. Did you solve it?

PHP 7.3 and MySQL 5.7 worked flawlessly.
avatar 
Date: 2021-08-30 08:58
Posted By: Gabor Horvath (zsiri)

I have the solution:
In SQL, "ONLY_FULL_GROUP_BY" must be disabled from "sql_mode". After that, the
lists work.