When a question got many other questions linked from/to it, there is a special page showing list of all those questions, e.g.   I just noticed while leaving it open, that the live refresh is active in there and showing "x questions with new activity" whenever there is new activity, even if in a question not linked to/from the original question.  I think the live refresh should be disabled while in that view, or filtered to load only questions actually being linked.
When there are too many linked questions to fit in the sidebar, it shows a link to &quot;see more linked questions...&quot;. Clicking on this link takes you to a front-page type showing only the linked questions. You can then use the tabs to sort by &quot;active&quot; to show the most recently active linked questions. However, the gray popup that appears when new questions are posted shows up for any recent activity, not just activity on the linked questions. Clicking through then updates the list, appending more questions to the top of the list, regardless of whether or not they're linked to the question at hand. To reproduce:  Go to  Wait for activity  Screenshots:   Now obviously this isn't a show-stopper, but I thought it might be worth mentioning.  Update June 2020 This is still relevant.  While sitting on the &quot;linked questions&quot; page for a specific question - in the above screenshot,  - and sorted by newest, when a new question is asked the &quot;1 question with new activity&quot; banner will show up, even if that new question does not link back to the question that you were on.
A Google search spewed forth millions of hits on how to find tables without clustered indexed, the PK normally being the clustered index of a table. However, a table could easily have a natural key as a clustered index, and a non-clustered surrogate index, like an identity column.  How do I find all tables in a DB without a primary key defined? I have 245 tables in this DB: manual inspection is grossly inefficient. Additional Boxes - Criteria, Longevity, Manipulability This feature has existed for a while (I'm not sure since when exactly), but I'm mainly interested in the Gen VI implementation (hence the tag).  Usually, at the start of a game, you have some number of Boxes available. In B/W, those were 8, in X/Y I think it was 15. Under certain conditions though, you receive additional Boxes that just appear at the end of your current Boxes list. Which brings me to Part 1 of my question:     1) What are the exact conditions for additional Boxes to appear and do you always get 8 additional Boxes? (Using Pokemon Bank reveals that in X/Y, the maximum number of Boxes is 31, which I have experienced to be unlocked in 2 steps of 8 Boxes each.)   Since I'm a person who really likes to order and organize stuff, my Boxes have names and are used to categorize my Pokemon. This results in some Boxes ending up empty for a while most of the time. So here's to     2) Do additional Boxes you receive stay forever or do they disappear if the conditions for them are no longer met?      3) If they disappear, is there a way (such as renaming or putting any Pokemon in the last Box) to make them stay no matter what, even if you released all your other Pokemon? Why are only certain shutter speeds or apertures available? Huge close votes review queue on Stack Overflow Today, the size of the close-votes queue is 55k questions and growing. Is that a problem?   Which action could be taken to clean it up? It seems to be growing faster than Stack&nbsp;Overflow members are capable to handle it. How do I get Pokémon Go to detect my phone's orientation? When initiating a battle it starts off in AR mode, but then warns me saying my phone's orientation is not detected. I am then forced to turn off AR mode. Has anybody experienced this? If so, what are the solutions?    Per comments, I am unsure this is a permissions issue. I have everything turned on. Can you recommend a Java library for reading (and possibly writing) CSV files? Is there a way to exclude other particle systems from the effects of a Wind effect? I have a scene with a number of particle systems. I'd like to have a separate wind effect for my main scene and another for an extra: an emitter + wind-effect to blow leaves into my scene. I can't find any way to exclude, so here I am. At the very worst, I can just render the main scene and then render the wind effect and composite it, but I figured I'd check first. Installing nvidia drivers on 18.04 What does the "yield" keyword do? Changing plurality in parentheses If a set of parentheses lies between a subject and its verb, and the parentheses contain an substitutive subject whose singularity/plurality disagrees with the original subject, whose singularity/plurality should be chosen for the verb?  In other words, in the following example, should "questions" (and its verb "are") be singular, or should they remain plural as shown?     Many (if not every) questions on this StackExchange are answered.   My intuition tells me that the two words in question should remain in plural forms, since the text in parentheses only interrupts the sentence (and the sentence would be grammatically incorrect if everything in parentheses were removed and the words were in singular form).  On the other hand, when read aloud (assuming one reads the text in parentheses), this has an uncomfortable sound to it, and I've seen others write in what would be the above example's singular-form case, so I'm curious to find out which is correct.  And, thinking about it, I suppose the same question would apply when commas are used in place of parentheses. All I remember is the guy was sent to a planet to test something or he did something illegal, and time moved really fast on the planet but slow to the outside world. He had to fix something to leave the planet I think. His dad was also dying and he checked how many days he had left every day, but in the end his dad didn't actually die as time was fast. It took place on a sandy planet. Automating the scanning of graphics files for corruption Does anyone know of a way to check graphics files (particularly JPEG, GIF, and PNG) for corruption (preferably in an automated way)?    Explanation:  A few days ago, a command worked incorrectly and ended up deleting thousands of graphics files from a FAT32 volume that was practically out of space. I’ve used several different file/photo-recovery programs, but naturally, they are limited in how much they can recover (though fortunately the volume has 8KB clusters, which helps somewhat).  Anyway, some of the larger files, that were fragmented, are now corrupt. Some of them are not even real files at all (the recovery software merely dumped the clusters that were pointed to by now-overwritten directory entries), while others are broken because of fragmentation.  Moreover, because some picture formats embed a smaller version of the picture as a thumbnail, scanning the thumbnails for corruption is not reliable because it may be intact while the actual file (i.e., the picture when viewed full-size), could be corrupt.    Here are a couple of examples:      Here’s the second one. It’s so damaged that it doesn’t display anything.    (A third one wouldn’t even upload because it doesn’t even have the correct header!) I'm about to use this diagram to make computing 3x3 determinants clear and easy for my students. I tried to add this picture to my lecture but it's blurred due to the bad quality of the picture. So i want to create exactly the same figure using latex.  I've searched and read a few topics about highlighting elements and diagonals in matrix but it does not work in this case. I want to add plus signs and minus signs as in the picture, and highlight elements in the matrice with elements outside the matrice.  I appreciate all your help and your advice. Thank you in advance ! Converting time field omitting time and returning null values? I have a time field in my shapefile that is formatted as HH:mm:ss.s It is a text field, and I want to convert it to a date so I can calculate time elapsed across rows (if there's a better way to do this let me know). Basically, each row is a point on a route, and I want to use the time field to calculate the amount of time elapsed between the first and last points on the route.   I tried using the convert time field tool, setting the input format as HH:mm:ss.s, and the output type as DATE. The output field however only shows values of 01/01/2001 for some rows and  for other rows.   time is the input field and time_c is the output field  I'm not sure what's going wrong here, here is what shows up in the geoprocessing results window:    I tried adding the date data to the field as well to make the format yyyy-MM-dd HH:mm:ss.s, but it still didn't work: Prove that formula is not tautology. Show Kripke's model proving that the following formula isn't tautology in intuitionistic logic. $ \neg ( p \wedge q ) \implies (\neg p \vee \neg q) $  Please help/hint me ;) What is the quantum mechanical explanation of the octet rule? What is the quantum mechanical explanation of the ? In other words, what makes the octet rule be true from a quantum mechanical view? How we explain  what makes some atoms don't follow the octet rule using QM? Map not loading when using getLegend and showing error for getView() I was able to run my application on using Legend earlier but now I want to update my Legend when scrolling on the map. So I tried to used this code  . And I got the gist of how he is able to do that but when I am trying the same I keeping getting the error var graphicUrl = wmsSource.getLegendUrl(currentResolution);  I think this is mainly due to the wmsSource not declare. But I tried to initialize  seems wmsSource in TileWMS but does not seems to work. var getExtent = function () {     return map.getView().calculateExtent(); } var getProjectionCode = function () {     return map.getView().getProjection().getCode(); }  var updateLegend = function() {     var currentResolution = map.getView().getResolution();     var graphicUrl = wmsSource.getLegendUrl(currentResolution);        const crs = `&amp;CRS=${getProjectionCode()}`;     const bbox = `&amp;BBOX=${getExtent().join(',')}`;     const height = getHeight(getExtent());     const width = getWidth(getExtent());     const heightAndWidth = `&amp;srcwidth=${height}&amp;srcheight=${width}` ;     const legenOptions = &quot;&amp;legend_options=countMatched:true;fontAntiAliasing:true;hideEmptyRules:true;forceLabels:on&quot; ;        var img = document.getElementById('legend');     img.src = `${graphicUrl}${crs}${bbox}${heightAndWidth}${legenOptions}`; }; //Updated Legend End   //View var myview = new ol.View({     center : [8717490.201868,2788422.791843],     zoom : 4 })  var firstSel = document.getElementById(&quot;City&quot;); var secSel = document.getElementById(&quot;Sector&quot;);  //var LayerArray = [baseLayer, firstLayer]  //Map var map = new ol.Map({       target : 'mymap',       view: myview,       layers: [         new ol.layer.Tile({             source : new ol.source.OSM({                 attributions: 'Surveyor Allpication'             })         }),         new ol.layer.Tile({             source : new ol.source.TileWMS({                url: 'http://localhost:8089/geoserver/India/wms',                params: {'LAYERS': 'India:India', 'TILED': true,'TRANSPARENT':true},                ratio: 1,                serverType: 'geoserver',                transition: 0,             })         })       ] }) updateLegend();   This here is my JS &lt;div class=&quot;innerMap&quot;&gt;     &lt;div class=&quot;map&quot; id=&quot;mymap&quot;&gt;&lt;/div&gt;         Legend:     &lt;div&gt;&lt;img id=&quot;legend&quot;/&gt;&lt;/div&gt;     &lt;!--    &lt;div&gt;&lt;img src=&quot;http://localhost:8089/geoserver/wms?REQUEST=GetLegendGraphic&amp;VERSION=1.0.0&amp;FORMAT=image/png&amp;WIDTH=20&amp;HEIGHT=20&amp;LAYER=India%3AIndia&amp;RULE=Agra&quot; /&gt;%Name&lt;/div&gt; --&gt; &lt;!--    &lt;div&gt;&lt;img src=&quot;http://localhost:8089/geoserver/India/wms?SERVICE=WMS&amp;VERSION=1.1.1&amp;REQUEST=GetLegendGraphic&amp;FORMAT=image/png&amp;WIDTH=20&amp;HEIGHT=20&amp;LAYER=India%3AIndia&amp;SRS=EPSG%3A4326&amp;STYLES=&amp;SRCWIDTH=742&amp;SRCHEIGHT=768&amp;BBOX=75.4541015625%2C14.21630859375%2C91.7578125%2C31.09130859375&amp;LEGEND_OPTIONS=countMatched:true;fontAntiAliasing:true;hideEmptyRules:true&quot; /&gt; &lt;/div&gt;  --&gt;     &lt;/div&gt;  This is my HTML. How do I make this work? How precise is the frequency of the AC electricity network? If I make a digital clock which first detects the AC frequency roughly (whether it is 50, 60, 100Hz, etc), then uses it as its clock pulse source, how precise would it be? Would it work world wide precisely?  For instance, in USA, what is the mean and standard deviation of the 60Hz AC frequency? Run TTY script every time I open a GUI terminal Prove that $\liminf x_n = -\limsup (-x_n)$