Module

Developer
Supported

Sitemap Module

ExpressionEngine 3, ExpressionEngine 4

Back to this add-on's main page
View Other Add-ons From PutYourLightsOn

     

You must be logged in to post.

Exception Caught in MySQL 5.7.x

Bug Report

Josh Conner
Josh Conner

When trying to view rendered sitemap I get:

Exception Caught
SQLSTATE[42000]
Syntax error or access violation1055 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_dateentry_dateexp_channel_titles.entry_idurl_titlechannel_idexp_category_posts.cat_idcat_namecat_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 OR expiration_date 1554907408GROUP 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
# 1
Developer
PutYourLightsOn

Thanks for reporting this. We’ll add a fix in the next release.