Fatal error: Uncaught Cube\Exception: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #57 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bcsurplu_v8.rvl.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [Query]: SELECT l.*, rvl.id AS recently_viewed_listings_id FROM ppb_listings AS l
INNER JOIN ppb_recently_viewed_listings AS rvl ON rvl.listing_id = l.id WHERE (l.listing_type IN ('auction')) AND (l.draft = 0) AND (l.active = 1) AND (l.approved = 1) AND (rvl.user_token = '') GROUP BY l.id ORDER BY IF(rvl.updated_at is null, rvl.created_at, rvl.updated_at) DESC LIMIT 4 in /home/bcsurplus/public_html/library/Cube/Db/Statement/Pdo.php:227
Stack trace:
#0 /home/bcsurplus/public_html/library/Cube/Db/Adapter/AbstractAdapter.php(185): Cube\Db\Statement\Pdo->execute(Array)
#1 /home/bcsurplus/public_html/library/Cube/Db/Adapter/PDO/Mysql.php(228): Cube\Db\Adapter\AbstractAdapter->query('SELECT l.*, rvl...', Ar in /home/bcsurplus/public_html/library/Cube/Db/Statement/Pdo.php on line 227