All Questions
Tagged with status-completed data-explorer
304 questions
14
votes
1
answer
459
views
Adding new indexes to Data Explorer Stack Exchange tables?
This is in regards to the Stack Exchange Data Explorer, specifically, its query creator.
I am trying to run some queries about Stack Overflow involving CreationDate on the table PostsWithDeleted, but ...
- 181
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
17
votes
1
answer
293
views
Can we exchange one index for another one?
In the Stack Exchange Data Explorer only the most logical/beneficial yet minimal set of indexes is created for the tables found in the schema.
One of those indexes is on the Users table:
CREATE ...
reneMod
- 92k
7
votes
2
answers
290
views
Data Explorer Query crashes with collation conflict error
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 ...
- 569
25
votes
2
answers
763
views
Create a view that provides a list of databases
In an answer to Strange new database 'Data.StackExchangePOC' is messing up cross-site SEDE queries our DBA extraordinair Aaron Bertrand suggested to have a feature request for a view to list ...
reneMod
- 92k
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.1k
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
- 92k
16
votes
1
answer
282
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
34
votes
1
answer
271
views
The current SEDE refresh was delayed overnight
On Saturday, January 22nd, we had a failure on a backup share that won't be fully resolved until Monday.
We've immediately re-routed backups to multiple secondary locations, so that concern has been ...
Aaron BertrandStaff
- 43.5k
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
- 92k
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
- 92k
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
- 92k
14
votes
1
answer
152
views
Expose moderator-only and required tags in SEDE
The API has two methods to get a list of required tags (the gray ones) and moderator-only tags (the red ones):
required tags
moderator only tags
That means there must be an enumeration (or two ...
GlorfindelMod
- 256k
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 ...
9
votes
1
answer
210
views
Rename "Favorite" vote type to "Bookmark" in VoteTypes table SEDE
Over at SEDE, in this query, it shows the vote type (or what should be the vote type) "bookmark" as "favorite":
Can we update that to say "bookmark", since favorites are ...
- 26.9k
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
- 92k
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
- 92k
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
1
vote
2
answers
140
views
SEDE help page still links to version 3.0 of Creative Commons license
Related to the post : SEDE footer still links to version 3.0 of Creative Commons license.
In the Stack Exchange Data Explorer help page, currently the Creative Commons license is referred with ...
- 39k
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
252
views
SEDE footer still links to version 3.0 of Creative Commons license
According to Stack Exchange and Stack Overflow have moved to CC BY-SA 4.0, subscriber content is now licensed under version 4.0 of the Creative Commons license. The change is reflected in the footer ...
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
2
answers
80
views
Change taglines for non-English sites and new Meta sites on SEDE homepage
The homepage of the Stack Exchange Data Explorer has mixed-language taglines for non-English sites; e.g. for Russian Stack Overflow it is "Q&A for программистов".
Can this be changed to something ...
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
4
votes
1
answer
109
views
Help section update related to ##UserID## in data.stackexchange
On help page of data.stackexchange, It is stated that:
The ##UserId## parameter is treated specially for users who are logged
in. If they have an account on the target site that shares the email
...
- 150
10
votes
0
answers
126
views
Can the Description for the CloseReasonTypes be added for the newer Close Reasons?
The table CloseReasonTypes in The Stack Exchange Data Explorer holds the id, name and description for the various close reasons.
When the close reasons got a major overhaul the new close reasons got ...
reneMod
- 92k
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
- 92k
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