devot:eeDevoted to ExpressionEngine

I get the following error when I try to view the XML sitemap page.

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 ‘ac732234_account_kit_com.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 = ‘1’ AND exp_channel_titles.site_id = ‘1’ AND status IN (‘open’) AND (expiration_date = 0 OR expiration_date > 1508840649) GROUP BY entry_id LIMIT 50000

ee/legacy/database/drivers/mysqli/mysqli_connection.php:122

^ Bump.

Hmm we’ve tested locally and cannot replicate this issue. What versions of EE and Sitemap are you running? Can you check whether MySQL strict mode is enabled? Disabling it might prevent this error from appearing.

Thanks for your reply.

Sitemap: 3.0.1
EE: 3.5.10

How do I see if MySQL strict mode is enabled?

Is that something you can see in the phpInfo?

No, you’ll have to check for it in MySQL, see this StackExchange answer for instructions:
https://stackoverflow.com/a/40889485/1769259

Thank you sir.
Much appreciated.

Sure thing, let me know how it goes.

Will do.

kubik101, were you able to get this resolved? I’m having the same problem.

EE 4.3.1
Sitemap 4.0.0

@srevoal - I can’t remember what I did to be honest. Try following the instructions left in the following link: https://stackoverflow.com/a/40889485/1769259

And contact your host if you are still struggling.

I would have done either of these 2 things.