Database error in vCard PRO:
INVALID SQL: SELECT UNIX_TIMESTAMP(date), COUNT(s.card_id) AS score, cd.card_id, cd.card_thmfile, cd.card_caption, cd.card_rating, cd.card_date
FROM vcard_stats AS s
	LEFT JOIN vcard_cards AS cd ON s.card_id=cd.card_id
	LEFT JOIN vcard_category AS ct ON ct.cat_id=cd.cat_id
WHERE WEEK(date)=WEEK(FROM_UNIXTIME(1635161600)) AND ct.cat_active='1'
GROUP BY s.card_id
ORDER BY score DESC
LIMIT 0, 15
mysql error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'woi2_ecard.s.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql error number: 1055
Date: 2021/10/25 - 11:33:20 AM
Script: /topcards.php
Referer: