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.

An anonymous reader writes, "Novell has published additional details about its agreements with Microsoft concerning Windows and Linux interoperability and patents. It seems the company is receiving an up-front payment of $348 million from Microsoft, for SLES subscription certificates and for patent cross-licensing. Microsoft will make an upfront payment to Novell of $240 million for SLES subscription 'certificates' that Microsoft can use, resell, or distribute over the term of the agreement. Regarding the patent cooperation agreement, Microsoft will make an up-front net payment to Novell of $108 million, and Novell will make ongoing payments totaling at least $40 million over five years to Microsoft."

CaroKann writes, "Variety is reporting that George Lucas is getting out of the movie business. Mr. Lucas laments that today's big-budget franchise films are too expensive and too risky. He believes American audiences are deserting their movie going habits permanently. Instead of making major films, Lucasfilm will instead focus on television. Lucas states that for the price of one $200 million feature movie, 'I can make 50-60 two hour movies' that are 'pay-per-view and downloadable.' Notably, he does not plan on distributing movies online, calling online distribution a 'rathole.'"

Roland Piquepaille writes "Obviously, computers can't have an opinion. What computers are very good at, though, is scanning through text to deduct human opinions from factual information. This branch of natural-language processing (NLP) is called 'information extraction' and is used for sorting facts and opinions for Homeland Security. Right now, a consortium of three universities is for the U.S. Department of Homeland Security (DHS) which doesn't have enough in-house expertise in NLP. Read more for additional references and a diagram showing how information extraction is used."

Krishna Dagli writes "The U.S. House of Representatives on Tuesday approved a bill that would make it a federal felony for Webmasters to use innocent words like "Barbie" or "Furby" but actually feature sexual content on their sites. Anyone who includes misleading "words" or "images" intended to confuse a minor into viewing a possibly harmful Web site could be imprisoned for up to 20 years and fined, the bill says." Terrible news for the Barbie/Furbie fetishists out there, to say nothing about being completely impossible to enforce globally.

An anonymous reader writes "More worrying news from the UK. This time, a bill meant to fight cybercrime may make it illegal to use or make available network security tools available, just because they could be used by hackers." From the article: "Clayton cited the Perl scripting language, created by Larry Wall in 1987, as an example of a useful technology that could fall foul of the law. 'Perl is almost universally used on a daily basis to permit the Internet to function,' said Clayton. 'I doubt if there is a sysadmin on the planet who hasn't written a Perl program at some time or another. Equally, almost every hacker who commits an offense under section 1 or section 3 of the CMA will use Perl as part of their toolkit. Unless Larry is especially stupid, and there is very little evidence for that, he will form the opinion that hackers are likely to use his Perl system. Locking Larry up is surely not desirable.'" A note that this is equally confusing but separate from yesterday's story about the UK government wanting private encryption keys.

tito writes "A New Zealand company has successfully turned sewage into modern-day gold. New Zealand Herald is reporting that a Marlborough-based Aquaflow Bionomic yesterday announced it had produced its first sample of bio-diesel fuel from algae in sewage ponds. It is believed to be the world's first commercial production of bio-diesel from 'wild' algae outside the laboratory - and the company expects to be producing at the rate of at least one million litres of the fuel each year from Blenheim by April."

mresolver writes "University of Chicago students have once again emerged from the library after a long winter to participate in the world's largest scavenger hunt. The multiple day event is famous for the working breeder reactor that students managed to build during the 1999 hunt. This year, the official list (PDF) includes a superconductor, working wood refrigerator, hot air balloon made to Montgolfier specifications, one-way funhouse mirror, and a walk-in Kaleidoscope."

Dracophile asks: "The Sydney Morning Herald recently ran a front-page article about a 'smart card' to access government services and that it would double as a national identity card. The article points out that the current Prime Minister of Australia, John Howard, who fiercely opposed from opposition the Australia Card idea in 1985, is now a supporter. The article goes on to say that about 100 nations have some form of ID card. Is your country one of them? What concerns were raised? How were they addressed? Have welfare fraud and other identity-related crimes decreased? Have National ID cards improved or deteriorated conditions where you live?"