I think I found a bug, although it can be circumvented quite easily and not many users will be affected.  I often use tags, instead of bug I write . Followed by a link, it won't work. If one types  [tag:bug] [meta stackoverflow][1]   it becomes:   [meta stackoverflow]  Two spaces between the tag and the link fixes this, one can type:  [tag:bug]  [meta stackoverflow][1]       Maybe this can be fixed to not confuse users (like me).
Links in [link text][number] format don't work properly if they follow a tag using the new [tag:tagName] format. Here's the result of [tag:python] [gold badge page][1]:      [gold badge page]   Putting the tag inside the link is worse. Here's the result of [[meta-tag:bug] some text][2], where [2] is google.com:        The part of the link outside the tag just disappears silently.  EDIT: To be more precise, the entire link to [2] disappears. The markup that is produced contains (invalid) nested anchor tags, as shown here from Firefox's "View Source":  &lt;a href="http://google.com" rel="nofollow"&gt;&lt;a href="/questions/tagged/bug" class="post-tag required-tag" title="show questions tagged 'bug'" rel="tag"&gt;bug&lt;/a&gt; some text&lt;/a&gt;   So the tag is still a link, but it is a link to the tag page, which is the behavior it would have if the link to [2] didn't exist at all. The user's desired behavior in this case is... ambiguous, to be charitable.  EDIT 2: I briefly included markup from Firebug here, but it turned out to be irrelevant. It has now been removed to improve readability. See  if you're interested.
I want to merge an audio file (.wav or .au format) with a video file (.mp4 format).  Please suggest me how to achieve this. I want to merge these file to new .mp4 video file. An ffmpeg command would be very welcome. Speeding up a NOT IN subquery Good evening,  I'm currently up to try to improve the performance of some of my queries. As far as I know, statements like "IN" or "NOT IN" are even faster with a large amount of values if a subquery on an indexed field without conditions is used.  SELECT * FROM table1 WHERE field1 NOT IN (SELECT index_field FROM table2)   When it comes to use conditions at table2, the query becomes realy slow on a large amount of data.  SELECT * FROM table1 WHERE     field1 NOT IN (         SELECT             index_field         FROM table2         WHERE             user_id = '2'     )   I was thinking about using LEFT Join but when I need to to the filtering for the user_id, it also becomes slow.  How may I solve this problem? Currently, I've no clue about that.  The original query looked sth. like this  SELECT     i.* FROM stream_item si LEFT JOIN user__publisher_item ui     ON ui.user_id = 2     &amp;&amp; ui.item_id = si.item_id INNER JOIN item i     ON i.id = si.item_id WHERE      si.stream_id IN (5,7,8,9,19,24,29,42,43,44)     &amp;&amp; ui.id IS NULL || (         ui.`read` = 0 || ui.saved = 1     ) GROUP BY     si.item_id ORDER BY     si.`found` DESC LIMIT 0,10     id      select_type     table   type        possible_keys                                                                           key                 key_len     ref                 rows        Extra 1       SIMPLE          si      index       PRIMARY,stream_2_item,stream_id_found                                                   stream_2_item       4           \N                  663236      Using temporary; Using filesort 1       SIMPLE          ui      eq_ref      user_id_item_id,user_2_item,user_id_read_saved_hidden,user_id_saved,user_id_hidden      user_id_item_id     8           const,si.item_id    1           Using where 1       SIMPLE          i       eq_ref      PRIMARY                                                                                 PRIMARY             4           si.item_id          1      I have a table which represents the n:m relationship between stream and items. An unique item can be accessible via multiple streams. Based upon this i have a state-table for user dependent states of an item. Currently, the user-state-entry will only be generated, if the item was read or saved the first tim. Otherwise, there is no entry in the user_item table. In the beginning, this query was fine but now, it takes a lot of time. Even if I leave out the "INNER JOIN" it takes 7 seconds on the current tables with around 500k rows each.  The table-structure in the background is as follows:   stream stream_item //n:m relation between stream and items item //unique items stream_group //user-defined groups of multiple streams stream_group_streams //_n:m relation between stream_groups and streams_ user user_item //state-table that holds the user-dependent states of an item - if there is no state, no row exists for an item   I already asked this question at  but added my 2 Edits with further information to late so that I haven't got an answer anymore. Database does not update automatically with MySQL and Python I'm having some trouble updating a row in a MySQL database. Here is the code I'm trying to run:  import MySQLdb  conn=MySQLdb.connect(host="localhost", user="root", passwd="pass", db="dbname") cursor=conn.cursor()  cursor.execute("UPDATE compinfo SET Co_num=4 WHERE ID=100") cursor.execute("SELECT Co_num FROM compinfo WHERE ID=100") results = cursor.fetchall()  for row in results:     print row[0]  print "Number of rows updated: %d" % cursor.rowcount  cursor.close() conn.close()   The output I get when I run this program is:     4Number of rows updated: 1   It seems like it's working but if I query the database from the MySQL command line interface (CLI) I find that it was not updated at all. However, if from the CLI I enter UPDATE compinfo SET Co_num=4 WHERE ID=100; the database is updated as expected.  What is my problem? I'm running Python 2.5.2 with MySQL 5.1.30 on a Windows box. Upgrade SQL Server database Using Compatibility Level I've made a backup of a SQL Server database running on SQL Server 2008. I've restored that backup into a SQL Server 2012 instance. I've set the compatibility level on the restored instance to SQL Server 2012 (110).   What does this do to the database?   Does it, for example,    cause stored procedures to be examined for incompatibilities cause any updates to all of the data pages in the database Cause updates to to datapages as the are accessed in the future Cause errors in the future if stored procedures or views are executed that use incompatible syntax   Where in books on line, or else where, can I find more detail? I'm looking for an idiom that is equivalent to the Portuguese:  Quem tudo quer, tudo perde. Who wants everything, loses everything.  It basically points out that being too ambitious will have bad consequences: not only does one not get what one's striving for, but one also ends up losing what one already had (and probably took for granted). This idiom should be usable in everyday speech. Labels cannot be moved although data-defined settings are active I'm trying to manually move labels but having some trouble. I'm trying to move the labels while in edit mode. I've added fields for x coordinate (all null), y coordinate (all null), rotation (all =0), and font-size (all =10). This makes the "move label" and "rotate label" buttons active, but when I click on the labels, no box around the label appears and it's impossible to move the label. What am I doing wrong? What is the difference between Θ(n) and O(n)? Sometimes I see Θ(n) with the strange Θ symbol with something in the middle of it, and sometimes just O(n). Is it just laziness of typing because nobody knows how to type this symbol, or does it mean something different? How to prove if $n$ is prime and $n | a^2$ then $n | a$? My professor assigned this for homework but I don't understand how to connect the dots. He suggested using the fact that $\gcd (x,y) \cdot \operatorname{lcm} (x,y) = xy$ but I'm not sure how that's relevant. Error: Counter too large! with \alph{cntr} and cntr>26 I would like to have \alph{counter} for values larger than 26. The following MnWE gives me the error ! LaTeX Error: Counter too large.  \documentclass{article} \begin{document}  \begin{enumerate} \def\theenumi{\alph{enumi}} \setcounter{enumi}{24} \item twenty-five \item twenty-six \item twenty-seven \end{enumerate}  \end{document}   I would like it to behave like one of these:  ..., x, y, z, aa, bb, cc, ..., xx, yy, zz, aaa, bbb, ccc, ... (preferred) ..., x, y, z, aa, ab, ac, ..., ax, ay, az, ba,  bb,  bc,  ... (can be if nothing else works)   A solution without LaTeX3 extensions would be awesome as I cannot run LaTeX3 extensions. How do  form? Why are they called the "time-reversed" versions of a black hole? What's an "eternal" black hole? How come a white hole is only encountered if you remove the star from the space-time surrounding the black hole? Why is it that if you add any matter to the area that the white hole disappears? Any explanation greatly appreciated. Double-clicking a window’s title bar to minimize it in Mavericks After upgrading to Mavericks I’m no longer able to minimize a window to the Dock by double-clicking on its title bar. How do I get this functionality back? If you multiclass a Warlock and a Sorcerer, then you have a character with both the Spellcasting and Pact Magic features.  PHB Page 101, Sorcerer, Spellcasting, Spell Slots:     You regain all expended spell slots when you finish a long rest.   PHB Page 107, Warlock, Pact Magic, Spell Slots:     You regain all expended spell slots when you finish a short or long rest.   PHB Page 165, Customization Options, Multiclassing, Class Features:     Pact Magic. If you have both the Spellcasting class feature and the Pact Magic class feature from the warlock class, you can use the spell slots you gain from the Pact Magic feature to cast spells you know or have prepared from classes with the Spellcasting class feature, and you can use the spell slots you gain from the Spellcasting class feature to cast warlock spells you know.   Do the spell slots keep their previous method of recovery (sorcerer slots long rest, warlock slots any rest), or do they all act consistently as I am led to believe from the language of the multiclass section? Do they all recover only from long rests as per the sorcerer feature, or can they all be recovered with a short rest because the warlock feature says so? Interaction with the site on the app should count towards Enthusiast/Fanatic If I do any of the below, which would normally constitute "activity" on any Stack Exchange site (including mobile):   View my profile Vote on any question or comment Visit one or more questions   ...then Stack Exchange considers me to have "visited" the site.  If I do any of the below on the mobile app:   Vote on any question or comment Visit one or more questions   ...then Stack Exchange does not consider me to have visited the site.  If one wants the app to have feature parity with the mobile site, then shouldn't my participation within the app also count towards the Enthusiast/Fanatic badge? Is there a tool to get the lines in one file that are not in another? Can Wubi use the ISO I already have? The Windows Installer for Ubuntu desktop instructions say that an ISO image for Ubuntu is downloaded during the installation process.  But what if I already have an ISO image for Ubuntu. Can I make the Windows Installer use that, so it doesn't have to download an ISO image again?  12.04 LTS and 12.10 are the versions of Ubuntu I'm interested in installing, in case that matters. What happens if there is a security problem in a package in the universe repository four years after the 12.04 LTS release; will the package be updated from upstream, patched, or left alone?  It's my understanding that the "5 years of support &amp; security updates" applies only to the core of Ubuntu -- anything in Main repository.  Not for things in the Universe repository.    For a more specific example -- if I install Ruby now, and want to use it for the next several years on 12.04 and it has a security vulnerability; while this might be patched in the upstream (so I could always download the latest from their website and compile it myself or use a PPA), will this upstream fix be migrated into the precise package repositories? What about backports? Why is the Centroid of a Triangle Shared with Its Midpoint Triangle How can I reliably get the operating system's name? Say I am logged into a remote system, how can I know what it's running? On most modern Linuxes (Linuces?), you have the lsb_release command:  $ lsb_release -ic     Distributor ID: LinuxMint Codename:       debian   Which as far as I can tell just gives the same info as /etc/lsb-release. What if that file is not present? I seem to recall that the lsb_release command is relatively new so what if I have to get the OS of an older system?  In any case, lsb stands for Linux Standard Base so I am assuming it won't work on non-Linux Unices. As far as I know, there is no way of getting this information from uname so how can I get this on systems that do not use lsb_release? How make f[{x,y}] evaluate as f[x,y]? The story is basically told from an alien's point of view. Essentially they observed us from far off, deemed us as violent and a danger to the universe, and set course (asteroid or something) to kill us. They kept observing and saw all the art and beauty we created and realized we were actually not so bad, but by then they couldn't stop it. So it was sort of also an apology letter to Earth in the end.  First read it like a year ago online and I can't find any trace of it anymore, nor can I recall the site it was on. Anyone know what short story this is?