Image search isn't working?

Hi,

Image search isn't working, debug shows this error message.

Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #22 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.thumb' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

This looks like a hosting issue, but I was wondering if Perch Support has any experience or suggestions to assist with a fix for this?

Perch Runway: 3.1.2
Production mode: Production (100)
Installed apps: content (3.1.2), assets (3.1.2), categories (3.1.2), perch_blog (5.6.1), perch_forms (1.12)
DB driver: PDO
DB tables: perch3_backup_plans (0), perch3_backup_resources (0), perch3_backup_runs (0), perch3_blog_authors (3), perch3_blog_comments (0), perch3_blog_index (2204), perch3_blog_posts (24), perch3_blog_posts_to_tags (0), perch3_blog_sections (1), perch3_blog_tags (0), perch3_blog_webmention_queue (0), perch3_blogs (2), perch3_categories (104), perch3_category_counts (6), perch3_category_sets (10), perch3_collection_index (19624), perch3_collection_items (972), perch3_collection_revisions (222), perch3_collections (6), perch3_content_index (3642), perch3_content_items (1462), perch3_content_locks (2), perch3_content_regions (334), perch3_forms (2), perch3_forms_responses (8), perch3_menu_items (19), perch3_navigation (6), perch3_navigation_pages (23), perch3_page_routes (87), perch3_page_templates (31), perch3_pages (137), perch3_resource_log (20442), perch3_resource_tags (4), perch3_resources (5656), perch3_resources_to_tags (4), perch3_settings (35), perch3_user_passwords (1), perch3_user_privileges (43), perch3_user_role_buckets (21), perch3_user_role_privileges (18), perch3_user_roles (2), perch3_users (7)
Users: 7
App runtimes:
<?php
    $apps_list = [ 
        'perch_forms',
        'perch_blog'        
    ];
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins), publish_posts (1 mins), process_webmentions (1 mins)
Editor plug-ins:
H1: 8e55aad8e5b8274ea0ac6c02a4ac2823
L1: 1be6e0eb2a58b4bad0f7b6828f6471f8
F1: 3b606135b33e6a102526838f4152a807
headerColour: #000000
content_singlePageEdit: 1
helpURL: /en/guides
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
installedAt: 3.0.14
update_3.0.14: done
headerScheme: dark
update_runway_3.0.14: done
latest_version:
on_sale_version: 3.1.2
update_runway_3.1.1: done
dashboard: 0
sidebar_back_link: 0
hide_pwd_reset: 1
keyboardShortcuts: 1
siteOffline: 0
content_hideNonEditableRegions: 1
content_frontend_edit: 0
content_skip_region_list: 0
assets_restrict_buckets: 0
perch_blog_update: 5.6
perch_blog_post_url: /en/news/{postSlug}
perch_blog_site_name:
perch_blog_slug_format: {postTitle}-%Y-%m-%d
perch_blog_akismet_key:
perch_blog_max_spam_days: 0
perch_blog_comment_notify: 0
perch_blog_webmention_tx: 0
perch_blog_webmention_rx: 0
logoPath: /perch/resources/cms-logo.png
update_runway_3.1.2: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_SITEPATH: apps/XXXXXXXXXX/public
PERCH_SCHEDULE_SECRET: XXXXXXXXXX
PERCH_DB_USERNAME: XXXXXXXXXX
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: XXXXXXXXXX
PERCH_DB_PREFIX: perch3_
PERCH_EMAIL_FROM: XXXXXXXXXX
PERCH_EMAIL_FROM_NAME: XXXXXXXXXX
PERCH_LOGINPATH: /perch
PERCH_PATH: /srv/users/serverpilot/apps/XXXXXXXXXX/public/perch
PERCH_CORE: /srv/users/serverpilot/apps/XXXXXXXXXX/public/perch/core
PERCH_RESFILEPATH: /srv/users/serverpilot/apps/XXXXXXXXXX/public/perch/resources
PERCH_RESPATH: /perch/resources
PERCH_HTML5: 1
PERCH_TZ: UTC
PERCH_RWD: 1
PERCH_TEMPLATE_FILTERS: 1
PERCH_GMAPS_API_KEY: XXXXXXXXXX
PERCH_MAP_JS: /perch/assets/js/public_maps.js
PERCH_YOUTUBE_API_KEY: XXXXXXXXXX
PERCH_DEBUG: 1
PERCH_EMAIL_METHOD: smtp
PERCH_EMAIL_HOST: smtp.mailtrap.io
PERCH_EMAIL_SECURE: tls
PERCH_EMAIL_AUTH: 1
PERCH_EMAIL_PORT: 2525
PERCH_EMAIL_USERNAME: XXXXXXXXXX
PERCH_RUNWAY: 1
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_ASSET_VERSION: 6738d5d5f5664f7c5e34
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /srv/users/serverpilot/apps/XXXXXXXXXX/public/perch/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_XHTML_MARKUP:
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_DEFAULT_BUCKET: default
PERCH_TRANSLATION_ASSIST:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_PRIV_ASSIST:
PERCH_CUSTOM_EDITOR_CONFIGS:
PERCH_ENABLE_EXIF: 1
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown
Hosting settings
PHP: 7.1.21
Zend: 3.1.0
OS: Linux
SAPI: fpm-fcgi
Safe mode: not detected
MySQL client: mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
MySQL server: 5.7.23-0ubuntu0.16.04.1-log
Free disk space: 12.74 GB
Extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, calendar, ctype, dom, fileinfo, filter, ftp, hash, iconv, json, SPL, PDO, bz2, posix, readline, Reflection, session, SimpleXML, snmp, soap, sockets, standard, tokenizer, xml, xmlreader, xmlwriter, zip, mysqlnd, cgi-fcgi, bcmath, Phar, curl, mbstring, gd, gettext, gmp, imap, intl, ldap, exif, mcrypt, mysqli, odbc, pcntl, pdo_dblib, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, shmop, tidy, xmlrpc, xsl, Zend OPcache
GD: Yes
ImageMagick: No
PHP max upload size: 512M
PHP max form post size: 1024M
PHP memory limit: 256M
Total max uploadable file size: 256M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: Yes
TMP: /srv/users/serverpilot/tmp/XXXXXXXXXX
TEMP: /srv/users/serverpilot/tmp/XXXXXXXXXX
TMPDIR: /srv/users/serverpilot/tmp/XXXXXXXXXX
PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
USER: serverpilot
HOME: /srv/users/serverpilot
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
REQUEST_URI: /perch/core/settings/diagnostics/?extended
QUERY_STRING: extended
REQUEST_METHOD: GET
SERVER_PROTOCOL: HTTP/1.0
GATEWAY_INTERFACE: CGI/1.1
REMOTE_PORT: 39212
SCRIPT_FILENAME: /srv/users/serverpilot/apps/XXXXXXXXXX/public/perch/core/settings/diagnostics/index.php
SERVER_ADMIN: webmaster@
CONTEXT_DOCUMENT_ROOT: /srv/users/serverpilot/apps/XXXXXXXXXX/public
REQUEST_SCHEME: https
DOCUMENT_ROOT: /srv/users/serverpilot/apps/XXXXXXXXXX/public
REMOTE_ADDR: 86.30.197.156
SERVER_PORT: 443
SERVER_ADDR: 127.0.0.1
SERVER_NAME: XXXXXXXXXX
SERVER_SOFTWARE: Apache/2.4.34 (Unix) OpenSSL/1.0.2g
LD_LIBRARY_PATH: /opt/sp/apache/lib:/opt/sp/apache/lib
HTTP_COOKIE: _ga=GA1.2.1076650364.1526721702; cmsa=1; PHPSESSID=19b0e153b7a892b5273299e7f40c3685
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.9
HTTP_ACCEPT_ENCODING: gzip, deflate, br
HTTP_REFERER: https://XXXXXXXXXX/perch/core/settings/diagnostics/
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36
HTTP_DNT: 1
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_CONNECTION: close
HTTP_X_FORWARDED_PROTO: https
HTTP_X_FORWARDED_SSL: on
HTTP_X_FORWARDED_FOR: XXXXXXXXXX
HTTP_HOST: XXXXXXXXXX
SCRIPT_URI: https://XXXXXXXXXX/perch/core/settings/diagnostics/
SCRIPT_URL: /perch/core/settings/diagnostics/
HTTPS: on
FCGI_ROLE: RESPONDER
PHP_SELF: /perch/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1536581653.8916
REQUEST_TIME: 1536581653
argc: 1