Views:
314
Votes: 7
Tags:
support
status-completed
data-explorer
error-message
jquery
Link:
🔍 See Original Question on Meta Stack Exchange ⧉ 🔗
URL:
https://meta.stackexchange.com/q/399418
Title:
Data Explorer Query crashes with collation conflict error
ID:
/2024/04/28/Data-Explorer-Query-crashes-with-collation-conflict-error
Created:
April 28, 2024
Edited: June 17, 2024
Upload:
November 23, 2025
Layout: post
TOC:
false
Navigation: false
Copy to clipboard: false
I have a website built off my Q & A posted in Stack Exchange sites such as; Ask Ubuntu, Stack Overflow, SE Security, etc.
Data Explorer is used to scrape ALL Stack Exchange Q & A I’ve posted and download the query results for filtering by a python script and publishing to GitHub Pages. There are 310 Questions and 2,181 Answers, of which 54 and 1,135, respectively, are worthy of publication.
Data Explorer has been working fine for a few years but today it crashed with error:
Line 11: Cannot resolve collation conflict between
“SQL_Latin1_General_CP1_CI_AS” and “SQL_Latin1_General_CP1_CS_AS” in CASE operator occurring in GROUP BY statement column 4.
Here is the data explorer query, last changed on December 12, 2021.
How do I debug this error?
Problem fixed
A week after posting question the problem was fixed:
