[Bug] Update Job throws error in Alpha v8.5.0

Permalink Browser Info Environment
When I try to run the "Update Social Feed Data" automated job, I get this error:

{"error":{"message":"An exception occurred while executing 'SELECT b.*\n FROM btEasySocialFeed b\n INNER JOIN CollectionVersionBlocks cvb ON b.bID = cvb.bID\n INNER JOIN CollectionVersions cv ON cvb.cvID = cv.cvID\n WHERE cv.cvIsApproved = 1\n GROUP BY facebook_page_id, instagram_page_id, twitter_page_id, youtube_channel_id\n ORDER BY b.last_update ASC\n ':\n\nSQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c5Site.b.bID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"},"errors":["An exception occurred while executing 'SELECT b.*\n FROM btEasySocialFeed b\n INNER JOIN CollectionVersionBlocks cvb ON b.bID = cvb.bID\n INNER JOIN CollectionVersions cv ON cvb.cvID = cv.cvID\n WHERE cv.cvIsApproved = 1\n GROUP BY facebook_page_id, instagram_page_id, twitter_page_id, youtube_channel_id\n ORDER BY b.last_update ASC\n ':\n\nSQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c5Site.b.bID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"]}

I suspect this is related to the database changes that are coming to 8.5.0, as I'm on an alpha version of that (due to features I need elsewhere).

Type: Pre-Sale
Status: In Progress
BloodyIron
View Replies:
BloodyIron replied on at Permalink Reply
BloodyIron
Take note that I can update the block without the auto job by updating per time and/or when i hit save. So fixing this job would be nice, but right now I can still get it generally working.

concrete5 Environment Information

# concrete5 Version
Core Version - 8.5.0a3
Version Installed - 8.5.0a3
Database Version - 20181112211702

# concrete5 Packages
Easy Social Feed (1.1.5)

# concrete5 Overrides
None

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.29 (Ubuntu)

# Server API
apache2handler

# PHP Version
7.2.10-0ubuntu0.18.04.1

# PHP Extensions
apache2handler, calendar, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, Phar, posix, readline, Reflection, session, shmop, SimpleXML, sockets, sodium, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 8M
upload_max_filesize - 2M
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
opcache.max_accelerated_files - 10000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Vivaldi/2.2.1388.37

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.