[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).
{"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 |