Hi,
THX for report. Should be fixed now :)

https://www.mediamonkey.com/addons/browse/popular/


Expression #16 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mm_phpbb3.addons_files_urlname.UrlName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT addons_files.*, addons_files_urlname.UrlName as UrlName, SUM(versions.downloads) AS DownloadCount, SUM(versions.latest_downloads) AS LatestDownloadCount FROM addons_files LEFT JOIN `addons_files_urlname` ON `addons_files`.`id` = `addons_files_urlname`.`ParentID` AND (`addons_files_urlname`.`Active` = 1) INNER JOIN (SELECT addons_files_versions.file_id as file_id, addons_files_versions.downloads as downloads, COUNT(addons_download_log.id) as latest_downloads FROM addons_files_versions LEFT JOIN addons_download_log ON addons_download_log.version_id = addons_files_versions.id AND addons_download_log.timestamp > DATE_SUB(CURDATE(), INTERVAL 90 DAY) WHERE addons_files_versions.DateDeleted IS NULL GROUP BY addons_files_versions.id) as versions ON versions.file_id = addons_files.id WHERE addons_files.DateDeleted IS NULL AND addons_files.approved<>0 GROUP BY addons_files.id ORDER BY LatestDownloadCount DESC, DownloadCount DESC LIMIT 5 156 /home/mm/public_html/addon_system/admin/files/files.core.php[phpBB Debug] PHP Warning: in file /home/mm/public_html/addon_system/admin/files/files.core.php on line 160: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given