Forum

Thread tagged as: Problem

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
Stephen Meehan

Stephen Meehan 4 points

  • 2 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Do you mean the search in Assets?

Yes, search in Assets.

I've been in touch with my hosting provider, looks like the issue is related to strict SQL mode.

It looks like I can turn strict SQL mode off. Do you think this would fix the issue?

Here's a blog post I found related to turning it off. How to Disable Strict SQL Mode in MySQL 5.7

Drew McLellan

Drew McLellan 2638 points
Perch Support

Yes, that would fix it.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Should be fixed in the next release.

Thanks, I've turned strict SQL mode off for now, asset image search is now working.

I'll reactivate it once I've updated Perch on the next release.

It is a directory issue which is not located in wamp server. Take a screenshot and share here Apple Support. They have a good tech developer to solve your issue quickly

Researchers in Washington nation and Oregon found that adults with again ache Web Design Company that is reasonably impairing experienced much less pain.Discover comfort with benefits lasting several months.