Module

Developer
Supported

Sitemap Module

ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5

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

     

You must be logged in to post.

Error when viewing XML Sitemap

Support (Resolved)

kubik101
kubik101

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

kubik101
# 1
kubik101

^ Bump.

PutYourLightsOn
# 2
Developer
PutYourLightsOn

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.

kubik101
# 3
kubik101

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?

PutYourLightsOn
# 4
Developer
PutYourLightsOn

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

kubik101
# 5
kubik101

Thank you sir.
Much appreciated.

PutYourLightsOn
# 6
Developer
PutYourLightsOn

Sure thing, let me know how it goes.

kubik101
# 7
kubik101

Will do.

srevoal
# 8
srevoal

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

EE 4.3.1
Sitemap 4.0.0

kubik101
# 9
kubik101

@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.