Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ginny_galleries.c.comment' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT `caption`,`path`,p.`id`,c.`comment`,
UNIX_TIMESTAMP(`date_submitted`) AS `unix_date_submitted` FROM `plogger_pictures` p LEFT JOIN `plogger_comments` c
ON p.`id` = c.`parent_id` WHERE (
`path` LIKE '%Lent%' OR
`description` LIKE '%Lent%' OR
`comment` LIKE '%Lent%' OR
`caption` LIKE '%Lent%' )
GROUP BY p.`id` ORDER BY `date_submitted` DESC LIMIT 0, 20
In file: /galleries/galleries.php
On line: 2008