Ciao a tutti, sto creando un sito in drupal e ho installato il componente aggiuntivo "Download Count".
Una volta installato, non riesco ad entrare nella pagina del modulo poichè mi viene dato questo errore:
Error message PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'glorep2.dc.dcid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT dc.dcid AS dcid, dc.type AS type, dc.id AS id, f.filename AS filename, f.fid AS fid, f.filesize AS filesize, f.uri AS uri, COUNT(dc.dcid) AS count, COUNT(dc.dcid) * f.filesize AS totalsize, MAX(dc.timestamp) AS last FROM {download_count} dc INNER JOIN {file_managed} f ON dc.fid = f.fid GROUP BY dc.type, dc.id, dc.fid ORDER BY count DESC; Array ( ) in download_count_view_page() (line 82 of /var/www/html/sites/all/modules/download_count/includes/download_count.pages.inc).
Una volta installato, non riesco ad entrare nella pagina del modulo poichè mi viene dato questo errore:
Error message PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'glorep2.dc.dcid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT dc.dcid AS dcid, dc.type AS type, dc.id AS id, f.filename AS filename, f.fid AS fid, f.filesize AS filesize, f.uri AS uri, COUNT(dc.dcid) AS count, COUNT(dc.dcid) * f.filesize AS totalsize, MAX(dc.timestamp) AS last FROM {download_count} dc INNER JOIN {file_managed} f ON dc.fid = f.fid GROUP BY dc.type, dc.id, dc.fid ORDER BY count DESC; Array ( ) in download_count_view_page() (line 82 of /var/www/html/sites/all/modules/download_count/includes/download_count.pages.inc).
