Last night we crossed over 16,777,216 comments in the database. The wise amongst you might note that this number is 2^24, or in MySQLese an unsigned mediumint. Unfortunately, like 5 years ago we changed our primary keys in the comment table to unsigned int (32 bits, or 4.1 billion) but neglected to change the index that handles parents. We're awesome! Fixing is a simple ALTER TABLE statement... but on a table that is 16 million rows long, our system will take 3+ hours to do it, during which time there can be no posting. So today, we're disabling threading and will enable it again later tonight. Sorry for the inconvenience. We shall flog ourselves appropriately. Update: 11/10 12:52 GMT by J : It's fixed.

opencity writes "The Washington Post reports on the two Diebold source disks that were anonymously sent to a Maryland election official this past week. Further investigation has lead individuals involved to believe the disks came from a security check demanded by the Maryland legislature sometime in 2003." From the article: "Critics of electronic voting said the most recent incident in Maryland casts doubt on Lamone's claim that Maryland has the nation's most secure voting system. "There now may be numerous copies of the Diebold software floating around in unauthorized hands," said Linda Schade, co-founder of TrueVoteMD, which has pressed for a system that provides a verifiable paper record of each vote."

Mr. Soxley writes to tell us that the Boeing 767 recently purchased by Google founders Sergey Brin and Larry Page is at the heart of what promises to be quite a legal battle. From the article: "Now the Delaware holding company that technically owns the 767, Blue City Holdings LLC, is embroiled in multiple lawsuits with an aviation designer hired to plan and oversee the massive plane's interior renovation. [...] But last October, Blue City terminated Mr. Jennings's contract, saying he wasn't doing his job properly. Mr. Jennings then filed a nearly $200,000 lien against the aircraft with the Federal Aviation Administration for payment he hadn't received. He later filed a complaint related to the matter against Blue City and Gore Design Completions Ltd., the San Antonio executive-jet outfitting firm that worked on the plane, in District Court in Bexar County, Texas."

kenoa writes "In a recent blog entry, Gabor Cselle wrote about How Researchers are Reinventing the Mail Client. He highlights some ideas taken from research papers that will probably make it into the real world someday. From the article ' "[TaskMaster] All your emails, drafts, attachments, and bookmarks are mapped to "thrasks". Emails in the same thread are grouped automatically, but the user still has to assign other mails, links, and deadlines manually. [Bifrost] The idea here is that the people are the main indicators of whether an email is important. (...) Bifrost then reorganizes your inbox and displays your email in a number of predefined categories: Timely, VIP Platinum, VIP Gold, Personal, Small/Large distribution lists. [ReMail] Thread Arcs visualize relationships between email messages. Instead of wasting lots of space with a tree view that Thunderbird has, it displays the thread structure in a little image. (...) Contact Maps offer a different view of the address book: Senders from which you have received email are grouped by domain. Each person's name is shown with a different background color, depending on the time of the last email exchange." ' " Given that most of us probably read email essentially the same way as elm/pine did for us a decade ago, it sure would be swell to see updates to these metaphors.

To put things in perspective, the Curmudgeon Gamer has created graphs showing inflation-adjusted console costs. The PS3 is far from the most expensive console in history (that would be the Neo Geo, at almost $1000 adjusted price), but that hasn't stopped analysts, publishers, developers, and gamers from grumbling about it the week after E3. ABI Research has publicly stated that Sony may have 'hamstrung' itself with the console's high price. Publishers and developers are worried because (despite Sony's protests to the contrary), developers just don't have the kits to make the games. From the GameDaily article: "'A lot of developers have not gotten the kits,' said Sega of America president Simon Jeffrey while attending E3 last week. 'There certainly will not be a lot of titles available.' The result is that publishers that do want to take part in the PS3 launch will have to release games that don't fully take advantage of the power of the Cell processor, added Jeffrey."

JordanL writes "Hot on the heels of the beta rollouts of IE 7, comes an editorial from John Dvorak declaring IE the biggest mistake Microsoft has ever made. From the article: 'All the work that has to go into keeping the browser afloat is time that could have been better spent on making Vista work as first advertised [...] If you were to put together a comprehensive profit-and-loss statement for IE, there would be a zero in the profits column and billions in the losses column--billions.'"

Anonymous Emo writes "The community/blogging site LiveJournal recently introduced ads on some pages for free users. More interestingly, they also added a new restriction to their TOS (XVI 17 b.) banning users from using or providing ad-blocking software. The new TOS also permits them to immediately terminate the account of anyone they catch doing this."

Cheviot writes: "It seems Apple's new iTunes 2 installer deletes the contents of users' hard drives if the drives have been partitioned. I personally lost more than 100gb of data. More information is available at Apples Discussions board. (registration required). Apple has pulled the installer, but for hundreds, if not thousands, the damage is already done." The iTunes download page has a nice warning about the problem. Ouch.