« first day (1380 days earlier)      last day (722 days later) » 

rene
rene
5:51 AM
Mothers day!
 
Feeds
Feeds
6:26 AM
0
Q: Can you please close Stackexchange.Arduino? It has been open long enough for now

reneI was running a query this morning similar to: declare @sql nvarchar(max) select @sql = concat(N'insert into #validaccounts select distinct accountid from (', STRING_AGG(concat(N' select u.accountid from [', convert(nvarchar(max),name), N'].dbo.users u inner join users h on h.accountid = u.acc...

bug data-explorer
 
 
9 hours later…
cigien
cigien
3:21 PM
@Feeds Is there some workaround for this until it's fixed?
 
cigien
cigien
3:36 PM
Specifically, I'm using data.stackexchange.com/stackoverflow/query/1242966/… and I get the same error about Arduino being open.
 
rene
rene
@cigien yes, you can exclude StackExchange.Arduino from a multi-db query. Something like and name not like 'StackExchange.Arduino%' where I assume you're not interested in the currently restored by not yet finalized _Temp db version of Arduine
 
cigien
cigien
Perfect, thanks, that worked. And thanks for the clear instructions, that worked as well, so now I can adjust any other queries that have an issue.
Is adding the workaround to your MSE post (as an edit to the question, or as an answer?) worth it? Or is the workaround something that would be obvious to anyone who knows how SEDE works?
 
rene
rene
@cigien already did so
 
cigien
cigien
Ah, ninja'ed :) Thanks again.
 
rene
rene
thanks for asking about it
 
cigien
cigien
3:44 PM
np
 
rene
rene
slightly adjusted so you can still use the meta db of arduino
 

« first day (1380 days earlier)      last day (722 days later) »