[FIXED] website bug

Discussion about anything that might be of interest to MediaMonkey users.

Moderator: Gurus

cingo

[FIXED] website bug

Post by cingo »

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
Peke
Posts: 17446
Joined: Tue Jun 10, 2003 7:21 pm
Location: Earth
Contact:

Re: website bug

Post by Peke »

Hi,
THX for report. Should be fixed now :)
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
Image
How to attach PICTURE/SCREENSHOTS to forum posts
Post Reply