i'm creating a website with FEU and user directory but whenever i call the tag {CGUserDirectory} i get the following error:
Do i need to modify settings on my server?DEBUG: error in query
QUERY = SELECT U.*, IFNULL(H.refdate, '1970-01-01 01:00:01') AS refdate FROM cms_module_feusers_users U LEFT JOIN (SELECT userid,action,MAX(refdate) AS refdate FROM cms_module_feusers_history GROUP BY userid,action HAVING action in ('change settings','login')) AS H ON U.id = H.userid WHERE COALESCE(U.disabled,0) = 0 AND U.expires > '2018-02-28 11:42:41' GROUP BY U.id ORDER BY username ASC LIMIT 0, 100
Error = Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'H.refdate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
My installs information:
Cms Version: 2.2.6
Installed Modules:
AdminSearch: 1.0.4
CGContentUtils: 2.2.2
CGExtensions: 1.60
CGSimpleSmarty: 2.1.8
CGSmartImage: 1.22.2
CGUserDirectory: 1.5.1
CMSContentManager: 1.1.6
CMSMailer: 6.2.14
CmsJobManager: 0.1.2
DesignManager: 1.1.4
FileManager: 1.6.5
FilePicker: 1.0.2
FormBuilder: 0.8.1.6
FrontEndUsers: 2.9
Gallery: 2.3.2
LISE: 1.3.1
LISEEvents: 1.3.1
LISESponsors: 1.3.1
LISETrainings: 1.3.1
MenuManager: 1.50.3
MicroTiny: 2.2.2
ModuleManager: 2.1.3
Navigator: 1.0.8
News: 2.51.3
Search: 1.51.3
SiteMapMadeSimple: 1.2.8
Config Information:
php_memory_limit:
max_upload_size: 10000000
url_rewriting: mod_rewrite
page_extension:
query_var: page
auto_alias_content: true
locale:
set_names: true
timezone: Europe/Brussels
permissive_smarty: false
Php Information:
phpversion: 7.0.27
md5_function: On (True)
json_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_ALL: 0
E_STRICT: 0
E_DEPRECATED: 0
test_file_timedifference: No time difference found
test_db_timedifference: No time difference found
create_dir_and_file: 1
memory_limit: 64M
max_execution_time: 60
register_globals: Off (False)
output_buffering: 40926
disable_functions:
open_basedir:
test_remote_url: Success
file_uploads: On (True)
post_max_size: 10M
upload_max_filesize: 10M
session_save_path: /srv/users/hvdo/tmp/hvdodev (0750)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)
check_ini_set: On (True)
curl: On
Performance Information:
allow_browser_cache: Off (False)
browser_cache_expiry: 60
php_opcache: On (True)
smarty_cache: Off (False)
smarty_compilecheck: Off (False)
auto_clear_cache_age: On (True)
Server Information:
Server Software: Apache/2.4.28 (Unix) OpenSSL/1.0.2g
Server Api: fpm-fcgi
Server Os: Linux 4.4.0-112-generic On x86_64
Server Db Type: MySQL (mysqli)
Server Db Version: 5.7.21
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable
Permission Information:
tmp: /srv/users/hvdo/apps/hvdodev/public/tmp (0775)
tmp_cache: /srv/users/hvdo/apps/hvdodev/public/tmp/cache (0775)
templates_c: /srv/users/hvdo/apps/hvdodev/public/tmp/templates_c (0775)
modules: /srv/users/hvdo/apps/hvdodev/public/modules (0775)
uploads: /srv/users/hvdo/apps/hvdodev/public/uploads (0775)
File Creation Mask (umask): /srv/users/hvdo/apps/hvdodev/public/tmp/cache (0775)
config_file: 0444
----------------------------------------------