Query Error


MySQL Error  : Query Error
Query : SELECT x.*, y.p_filename, y.width, y.height, COUNT(z.com_id) as comments FROM laz_data x LEFT JOIN laz_pics y ON (x.id=y.msg_id and y.book_id=2) LEFT JOIN laz_com z ON (x.id=z.id) WHERE x.accepted='1' GROUP BY x.id ORDER BY x.id DESC LIMIT 0, 100
Error Number : 1055 Expression #18 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ixaaipdm_laza806.y.p_filename' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Requested URI: https://vietnamvetradio.com:443/lazarus/
Date : Tue, November 12, 2019 16:16:19
IP : 34.231.21.123
Browser : CCBot/2.0 (https://commoncrawl.org/faq/)
Referer :
PHP Version : 5.6.40
OS : Linux
Server : Apache
Server Name : vietnamvetradio.com