Query Error

MySQL Error  : Query Error

Query        : SELECT x.*, y.p_filename, y.width, y.height, COUNT(z.com_id) as comments FROM book_data x LEFT JOIN book_pics y ON (x.id=y.msg_id and y.book_id=2) LEFT JOIN book_com z ON (x.id=z.id) WHERE x.accepted='1' GROUP BY x.id ORDER BY x.id DESC LIMIT 0, 10

Error Number : 1055 Expression #18 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_299156_2.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://testfloriundluki.4lima.de:443/guestbook/

Date         : Thu, January 9, 2025 14:41:47

IP           : 3.16.78.146

Browser      : Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

Referer      : https://testfloriundluki.4lima.de/guestbook

PHP Version  : 5.6.40

OS           : Linux

Server       : Apache/2.4

Server Name  : testfloriundluki.4lima.de