Sitemap Module
ExpressionEngine 2, ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5, ExpressionEngine 6
Back to this add-on's main page
View Other Add-ons From Brian Litzinger
Exception Caught in MySQL 5.7.x
Bug (Resolved)
Josh Conner
|
Posted: 10 April 2019 10:58 AM |
|
|
|
When trying to view rendered sitemap I get:
Exception Caught SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'flsheriffs_local.exp_category_posts.cat_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT edit_date, entry_date, exp_channel_titles.entry_id, url_title, channel_id, exp_category_posts.cat_id, cat_name, cat_url_title FROM exp_channel_titles LEFT JOIN exp_category_posts ON exp_channel_titles.entry_id = exp_category_posts.entry_id LEFT JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE channel_id = '16' AND exp_channel_titles.site_id = '1' AND status IN ('open') AND (expiration_date = 0 OR expiration_date > 1554907408) GROUP BY entry_id LIMIT 50000
Added
ee()->db->query("SET SESSION sql_mode = ''");
to line 23 of mod.sitemap.php for a quick fix.
|
|
|
PutYourLightsOn
|
Posted: 11 April 2019 05:43 AM |
# 1
|
|
|
Thanks for reporting this. We’ll add a fix in the next release.
|
|
|
PutYourLightsOn
|
Posted: 26 February 2020 12:30 AM |
# 2
|
|
|
Fixed in version 4.0.1.
|
|
|