It’s interesting that Web 2.0 wonderbaby and made-for-adsense link aggregator Digg (which I love) isn’t working when I try and post a comment. This is the first comment I’ve ever really wanted to post, so it hurts me more that I can’t, because of a mysterious error:

It’s really hard to correct my “Error in entering captcha” when there’s not a visible captcha to fill out. I can’t correct this item to submit my comment on their GLAT story because there’s nothing to fix. And so I resort to writing it down here:

Interesting. They quote my year-old post (elliottback.com/wp/archives/2005/01/20/complete-glat-solutions/) on that matter at least twice in the article, which is annoying split onto multiple pages. Then again, I like their formatting better ^_^;

Then again, it’s 4:30 AM and their diggall page is spitting out random SQL code:

select pagesize from settings:0.00026512145996094

select sql_calc_found_rows items.id as id, title, category, cleancat, ctitle, url, bodytext, username, category_id, dig_count, anon_dig_count, obscene_count, userid,unix_timestamp(now()) – unix_timestamp(date_created) as secondsold, date_format(date_created, ‘%c/%d/%y %l:%i %p’) as date_created, deleted, obscene_flag, sdelete_flag, items.top_flag as top_flag, catdaysback, commentcount, never_promote from items where (items.deleted = 0 and obscene_flag != 1 and (items.top_flag = 0)) and (sdelete_flag != 1) and (from_unixtime(unix_timestamp(date_created)+catdaysback*86400) >= now()) order by items.date_created desc, items.dig_count desc LIMIT 100, 25:1.9898481369019

select found_rows():0.00018501281738281

select count(*) as count from digs where itemid = 178096 and userid = 78568 and deleted = 0:0.00038003921508789

(select itemid,username2 as friend from digs inner join friends on digs.userid = friends.id2 where friends.id1 = 78568 and approval1 = 1 and itemid = 178096 and friends.deleted = 0 and digs.deleted = 0 order by friend) UNION (select itemid,username1 as friend from digs inner join friends on digs.userid = friends.id1 where friends.id2 = 78568 and approval2 = 1 and itemid = 178096 and friends.deleted = 0 and digs.deleted = 0 order by username2):0.00052618980407715

select obscene_threshold, register_threshold from settings:0.00012993812561035

select category_id as catid, cleancat, category, count(*) as count from items where items.deleted = 0 and sdelete_flag != 1 and obscene_flag != 1 and top_flag = 0 and (from_unixtime(unix_timestamp(date_created)+catdaysback*86400) >= now()) group by category_id order by category:0.80735111236572

select items.id as id, title, category, cleancat, ctitle, url, bodytext, username, category_id, dig_count, anon_dig_count, obscene_count, userid,unix_timestamp(now()) – unix_timestamp(date_created) as secondsold, date_format(date_created, ‘%c/%d/%y %l:%i %p’) as date_created, deleted, obscene_flag, sdelete_flag, items.top_flag as top_flag, catdaysback, commentcount, never_promote from items where (items.deleted = 0 and obscene_flag != 1 and (items.top_flag = 0)) and (sdelete_flag != 1) and (from_unixtime(unix_timestamp(date_created)+catdaysback*86400) >= now()) order by items.date_created desc, items.dig_count desc LIMIT 0, 25:1.1316390037537

select count(*) as count from items where (items.deleted = 0 and obscene_flag != 1 and (items.top_flag = 0)) and (sdelete_flag != 1) and (from_unixtime(unix_timestamp(date_created)+catdaysback*86400) >= now()) :0.72928595542908
(select itemid,username2 as friend from digs inner join friends on digs.userid = friends.id2 where friends.id1 = 78568 and friends.approval1 = 1 and digs.digdate > ‘2005-12-13′ and friends.deleted = 0 and digs.deleted = 0 group by itemid, friend order by itemid, friend) UNION (select itemid,username1 as friend from digs inner join friends on digs.userid = friends.id1 where friends.id2 = 78568 and friends.approval2 = 1 and digs.digdate > ‘2005-12-13′ and friends.deleted = 0 and digs.deleted = 0 group by itemid, friend order by itemid, friend):0.0042569637298584

select itemid from digs where userid = 78568 and digdate > ‘2006-01-02′ and deleted = 0:0.00051403045654297

select obscene_threshold, register_threshold from settings:0.00051593780517578

select category_id as catid, cleancat, category, count(*) as count from items where items.deleted = 0 and sdelete_flag != 1 and obscene_flag != 1 and top_flag = 0 and (from_unixtime(unix_timestamp(date_created)+catdaysback*86400) >= now()) group by category_id order by category:0.6172559261322

Maybe digg really is dying?

This entry was posted on Saturday, January 7th, 2006 at 4:41 am and is tagged with unix timestamp, random sql, wonderbaby, sql code, sdelete, format date, select count, pagesize, category id, digs, title category, calc, desc, aggregator, formatting, unix. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback.

One Response to “Digg Done Dead”

1. donkers says:

   4/17/2006 at 1:57 am

   itis butyful

   Reply