All Questions
203 questions
17
votes
1
answer
349
views
Weekly SEDE refresh is stuck
It looks like Stack Overflow has been refreshed properly, but the next couple of sites are not making any progress.
GlorfindelMod
- 256k
14
votes
1
answer
290
views
Tags column of Posts table changed delimiter format. Many historical queries broken. Special tag rendering also broken
To the best of my memory, and in reading my past queries- some of which I re-run on a regular basis- the format of the Tags column of the Posts table in SEDE used to be like <starball><is>&...
- 29.2k
26
votes
3
answers
562
views
Strange new database 'Data.StackExchangePOC' is messing up cross-site SEDE queries
I just read a comment by user @questionto42 that one of my cross-site queries isn't working. My educated guess is this is because a special database Data.StackExchangePOC was created two days ago:
(...
GlorfindelMod
- 256k
20
votes
2
answers
431
views
The Data Explorer (SEDE) Refresh choked on a Raspberry
As we all know the community eagerly awaits the weekly SEDE refresh with all our posted content so we can analyze, share-alike or train our large language models (LLMs).
The script that runs the ...
reneMod
- 92.1k
16
votes
1
answer
283
views
Magic columns and site:// do not work for alcohol.meta.stackexchange
The site Beer, Wine & Spirits has the URL https://alcohol.stackexchange.com but in SEDE it uses beer for the main site and beerme for meta.
As far as I can tell, the shortcut site:// and the magic ...
- 15.6k
9
votes
1
answer
219
views
SQL query used to calculate staff escalation statistics doesn't take into account different tag names for international sites
This is a bug report of a SQL query used at What posts should be escalated to staff using [status-review], and how do I escalate them?.
In the above post, status-review posts are counted using this ...
- 1,673
13
votes
1
answer
302
views
Weekly SEDE refresh may be stuck restoring Literature.SE
I'm again looking at rene's SEDE query Status of the SEDE Refresh on Sunday 03:00 UTC to check the status, which is currently (in part):
.
category
database_id
Description
create_date
days ago
3
...
- 2,153
10
votes
1
answer
185
views
Data Explorer throws server error when attempting to query Psychology & Neuroscience
The Stack Exchange Data Explorer lets you write SQL queries to find questions, answers, comments, users etc across the StackExchange network, but the query interface throws an error if I try to select ...
- 15.1k
18
votes
1
answer
217
views
Weekly SEDE refresh has been contemplating Buddhism for a significant amount of time
Buddhism is interesting, surely, but either the weekly SEDE refresh has gained some Artificial Intelligence and is contemplating rebirth, or something is stuck. I'm not sure which one to hope for!
I'm ...
- 2,153
18
votes
1
answer
347
views
Weekly SEDE refresh stuck at Gaming.SE
The weekly SEDE refresh is stuck, this query shows the problem occurred while copying the Gaming Stack Exchange database:
Note: a similar thing happened before.
GlorfindelMod
- 256k
28
votes
1
answer
467
views
Can you please close the "Stackexchange.Arduino" database? It has been open long enough for now
I was running a query this morning similar to:
create table #validaccounts(accountid int primary key)
declare @sql nvarchar(max)
select @sql = concat(N'insert into #validaccounts
select distinct ...
reneMod
- 92.1k
18
votes
1
answer
140
views
The SEDE refresh job didn't start
Normally, at 03:00 UTC each Sunday the Stack Exchange Data Explorer is being refreshed with the weekly full backup from all sites.
I have this query to check on the status of the refresh as it takes 6 ...
reneMod
- 92.1k
26
votes
1
answer
251
views
SEDE refresh didn't happen this Sunday
The Stack Exchange Data Explorer is updated every Sunday morning; the first sites are already finished by 3am UTC. However, today this doesn't seem to happen; all I can find is posts from May 30th and ...
GlorfindelMod
- 256k
10
votes
0
answers
106
views
SEDE calls Code Golf Stack Exchange by its old name [duplicate]
As of May 30'th 2019, Code Golf.SE's new official name is Code Golf and Coding Challenges. However, SEDE hasn't updated this:
I know this is a minor bug, but it shouldn't take much effort to change ...
- 2,205
2
votes
0
answers
34
views
Incorrect name and broken image for site at SEDE [duplicate]
Over at SEDE, on the list of sites, Psychology & Neuroscience is still listed as "Cognitive Sciences" and the image is scrambled:
Can we fix that?
- 26.9k
9
votes
3
answers
1k
views
Chrome warns me my connection is not secure when authenticating in SEDE with a Google account
When I go to the login page of the Stack Exchange Data Explorer here and click the Log in using Google button, I'm not getting logged in but instead greeted with a Chrome message protecting my privacy:...
reneMod
- 92.1k
11
votes
1
answer
151
views
Descriptions for review task result types 22 and 23 are swapped in SEDE
The descriptions for review task result types 22 and 23 are swapped in the Data Explorer.
For context, these are the internal database numbers used to indicate the type of review someone made on a ...
12
votes
1
answer
209
views
Overlapping text in Database Schema SEDE
Over at SEDE, there is overlapping text in the Database Schema under Close-As-Off-Topic-Reason-Types:
that makes it really hard to read. This is also happening underneath "Pending Flags", ...
- 26.9k
13
votes
1
answer
293
views
NET::ERR_CERT_DATE_INVALID error at data.stackexchange.com
I'm currently getting a "connection not private error" over at the Stack Exchange Data Explorer (using Chrome). I have verified that my date and time settings are correct, and another user ...
- 8,020
15
votes
1
answer
154
views
Typo in old close reason 'noise or pointless' in SEDE
There used to be a close reason 'noise or pointless' on Meta sites. However, in SEDE it's listed as "noise of pointless", which makes it look like the person who inserted that was either ...
GlorfindelMod
- 256k
21
votes
1
answer
233
views
The Stack Exchange Data Explorer intermittently goes down
Since Sunday, I expect after the refresh of 03:00 UTC, the Stack Exchange Data Explorer seems to have troubles serving pages to us.
I notice that I'm either logged out frequently, I get the red error ...
reneMod
- 92.1k
12
votes
1
answer
109
views
The close reason descriptions for "Needs details or clarity" and "Opinion-based" are swapped in SEDE
The close reason descriptions for "Needs details or clarity" and "Opinion-based" are swapped in SEDE. Can this be corrected?
For reference, this is what those close reason ...
user313042
20
votes
1
answer
167
views
Certificate Expired on SEDE
It looks like the SSL certificate for data.stackexchange.com just expired.
If you were in the middle of running queries you would be greeted with:
Something unexpected went wrong while running ...
reneMod
- 92.1k
15
votes
1
answer
336
views
SEDE appears to be partially-refreshed
I went to check some of my queries against UNIX & Linux this morning and noticed that the results all had dates older than a week. Going to rene's "did the SEDE refresh work?" query, I see that U&...
- 2,153
15
votes
1
answer
205
views
Unable to login into Stack Exchange Data Explorer
It might be related to the recent SEDE outage but I'm unable to login to SEDE via Stack Exchange Open ID. When clicking the 'Log in using Stack Exchange' button, I get an error message
No OpenID ...
GlorfindelMod
- 256k
33
votes
1
answer
564
views
SEDE is offline
Cannot access SEDE at all.
Have checked with https://downforeveryoneorjustme.com/data.stackexchange.com which also says it's down.
- 36.3k
2
votes
1
answer
152
views
Number of queries in SEDE overflows
The total number of queries on SEDE (shown on the query list page) overflows sometimes, depending on the actual number:
I think it's still readable if the font size is reduced by a few points, or ...
GlorfindelMod
- 256k
11
votes
1
answer
216
views
Cross-site queries on SEDE fail with "The EXECUTE permission was denied"
I just noticed that any cross-site queries using dynamically generated SQL on the Stack Exchange Data Explorer (SEDE) now fail with the error message:
The EXECUTE permission was denied on the ...
- 31.8k
17
votes
1
answer
202
views
Network-wide queries don't work on the SEDE
For example, a
SELECT * FROM sysdatabases;
results
maybe some synchronization is running and it is only a temporary situation?
Note, no network-wide query will work, if you make this permanent.
- 1
2
votes
0
answers
36
views
Long site title messes up SEDE site list formatting [duplicate]
On the Stack Exchange Data Explorer homepage, if you scroll down a bit, you'll encounter a site with a very long title: Software Recommendations Meta Stack Exchange. A title this long messes up the ...
GlorfindelMod
- 256k
6
votes
1
answer
91
views
URL link issue in data explorer tutorial page
There is an issue with a URL, in one of the Data Explorer tutorial pages.
In the Tutorial -> Next Steps page, I can see the following description
You can find some interesting queries in this list ...
- 39k
3
votes
1
answer
72
views
Data explorer update seems to have failed
I noticed the data Explorer update for September 30 at 3:00 UTC seems to have failed. Looking at the Data Explorer main page it shows the last update was yesterday however the following query shows ...
- 6,276
7
votes
1
answer
242
views
SEDE doesn't age well (aka don't let users input their Birthday on SEDE and stop showing their age)
Stack Exchange has removed anything related to age from their live database recently, following the GDPR, in the database level, including in the tables used by SEDE.
However, SEDE itself still let ...
- 175k
12
votes
1
answer
158
views
The SEDE Refresh batch failed a second time in a row
Last week it was asked what Codegolf_Temp database is and it turned out to be a batch job that stalled mid-way and didn't recover. That was then rectified by restarting the batch later on the day.
...
reneMod
- 92.1k
13
votes
2
answers
340
views
What's the Codegolf_Temp database (and why does it mess up my query)?
Today, I was running some queries on SEDE and found out that this one fails to run because of the following error:
Invalid object name 'StackExchange.Codegolf_Temp.dbo.badges'.
Apparently, there's ...
GlorfindelMod
- 256k
5
votes
0
answers
114
views
CogSci is now Psychology.SE but SEDE isn't aware of it [duplicate]
SEDE seems to be unaware of the name change on Cognitive Sciences (to Psychology & Neuroscience).
The site icon is a broken image and the text of the site name still reads "Cognitive Sciences" ...
- 111k
18
votes
2
answers
749
views
A site URL changed and now its icon in SEDE is broken
This has happened before, and it's happened again, all because Cognitive Sciences recently was renamed Psychology & Neuroscience, with a change to the URL.
The first thing that needs to be fixed ...
- 56.4k
44
votes
1
answer
9k
views
reCaptcha v1 is shutting down on March 31, but SEDE still uses it
According to this post, I thought the new recaptcha API was used network-wide.
Though today, when going to SEDE (which for whatever reasons never recognized me automatically), I got this message ...
- 629
12
votes
1
answer
284
views
Alias "Post Link" in data.stackexchange.com generate invalid links for "Meta sites" of pt.stackoverflow and es.stackoverflow
I create a query using [Post Link] and [Comment Link] and I noticed that the generated links are inverted for some sites, for example:
This https://data.stackexchange.com/ptme/query/775699/bug-in-...
- 1,063
6
votes
1
answer
69
views
SEDE download link returns a 404
Trying to download the data dump from the help page of SEDE yields a 404 when clicking on the download button. (Shouldn't it link here instead?)
- 163
4
votes
1
answer
68
views
Data Explorer shows "This is a favorite query" for unfavorited queries
The hover text for the Favorite Query star on Stack Exchange Data Explorer displays the hover text "This is a favorite query (click again to undo)".
This hover text shows the same message ...
- 15.2k
2
votes
1
answer
55
views
SEDE text-only output column width is not correct for datetime columns
The column width of date, time, and datetime typed columns in text-only output mode is too narrow. The following query:
select
'a' a,
'aaaaaaaaaaaaaaaaaaaaaaaaaaaa' b,
getdate() c,
'a' ddd,
...
- 26.1k
12
votes
1
answer
117
views
SEDE magic columns (and site://) do not use HTTPS
Post links generated via the SEDE magic columns (e.g. [Post Link], [Comment Link], etc.) as well as site:// provide HTTP links, but should provide HTTPS links instead.
Example query:
select
(select ...
- 26.1k
16
votes
2
answers
337
views
Data.SE breaks when looking things up on Beer, Wine, and Spirits
When switching sites to Beer, Wine, and Spirits on the site switcher on data.SE (this thing), I get a Runtime Error:
Description: An application error occurred on the server. The current custom error ...
- 84.5k
6
votes
1
answer
142
views
SEDE [Post Link] magic column not compatible with chat one-boxing for answers
I am filing this as a bug report but I am not sure if the "bug" is on the SEDE side or the chat side (or if this should be a chat feature request).
Issue: SEDE links to answers (or anything ...
- 26.1k
3
votes
1
answer
64
views
Few site and meta site names are ending with Stack Exchange and not all the sites in the data explorer main page
In the Stack Exchange Data Explorer main page the Stack Exchange site and it's meta site names are displaying.
For the following site and it's meta site's names are ending with Stack Exchange but not ...
- 39k
13
votes
1
answer
185
views
404 on Beer Meta image
The Beer Stack Exchange icon on Data Explorer is missing or misdirected. The HREF points to an image that seems inappropriately named: cdn.sstatic.net/Sites/beermeta/img/apple-touch-icon.png
- 251
9
votes
2
answers
105
views
SEDE Tutorial does not have a tab title
The new tutorial does not have a <title> attribute in the <head> of the HTML:
My browser dev tools are telling me that it does have a <title> tag, but it is empty. This seems to be ...
- 6,838
12
votes
1
answer
96
views
The images on the main page of SEDE are not loading
I visited the main page of SEDE and noticed that most of the images return a 404:
This looks like a similar problem as reported earlier in Missing images in SEDE but that covered the site-switch drop ...
reneMod
- 92.1k
7
votes
0
answers
100
views
Data explorer site created new jon.doe account, instead of logging me to the old one
I've logged in to data explorer site, but it didn't recognise my old account and created a new one.
Is it possible to merge those accounts, as I can't logging to my old account anymore.
Related:
...
- 2,169