WordPress database error: [Got error 28 from storage engine]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (23, 22, 21) ORDER BY t.name ASC

Crappy Graphs! by Brian Shaler » 2007 » September

Archive for September, 2007

The Weekend Is Over Already??

Sunday, September 30th, 2007

Have you ever noticed that the more fun you have on the weekend, the shorter it feels?

User Submitted Crappy Graph

WordPress database error: [Got error 28 from storage engine]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (23) ORDER BY t.name ASC

Uncategorized | No Comments »

User Interaction vs. Length of Visit

Monday, September 24th, 2007

This is more obvious than it is profound, but I decided to post it merely by relevance. Several weeks ago, I debuted the Crappy Graphs user submission tool. Since then, the tool has been used to post hundreds of graphs. These user submitted graphs have since attributed to about 100,000 views on the site.

When you browse user submitted graphs, you can feel that they were drawn by different people. This factor helps lower the barrier to interaction. The effect is just like displaying 20 comments after a blog post. New visitors can see all these voices and feel more of an urge to chime in.

With Crappy Graphs, visitors feel this effect and click around. They submit. All in all, this site is seeing a significant increase in visit length and page views per visit.

Note: Today’s crappy graph was drawn using the user submission tool!

WordPress database error: [Got error 28 from storage engine]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (22) ORDER BY t.name ASC

Uncategorized | 3 Comments »

Featured User Graph: mattmc’s “Trapped in an Elevator”

Saturday, September 1st, 2007

I have decided to feature one of the Crappy Graphs drawn by a fan of this site over in the super awesome user graphs section.

This graph recently caught fire on the internet and attracted tens of thousands of visitors in the last few days.


This graph was drawn by Matt McInerny

WordPress database error: [Got error 28 from storage engine]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (21) ORDER BY t.name ASC

Uncategorized | 2 Comments »