WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE ID IN (112,111,110) GROUP BY ID

Curioso! » 2007 » June


Archive for June, 2007

Springer GTM Test

Wednesday, June 27th, 2007

If I were a Springer-Verlag Graduate Text in Mathematics, I would be J.L. Doob’s Measure Theory.

I am different from other books on measure theory in that I accept probability theory as an essential part of measure theory. This means that many examples are taken from probability; that probabilistic concepts such as independence, Markov processes, and conditional expectations are integrated into me rather than being relegated to an appendix; that more attention is paid to the role of algebras than is customary; and that the metric defining the distance between sets as the measure of their symmetric difference is exploited more than is customary.

Which Springer GTM would you be? The Springer GTM Test

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 112 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '112' AND comment_approved = '1'

No Comments »

Photo tools

Thursday, June 14th, 2007

Tools for working with images:

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 111 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '111' AND comment_approved = '1'

No Comments »

Concatenate image tiles to larger image

Thursday, June 7th, 2007

Often sites display larger images split up in tiles of e.g. 256×256 pixels. The tiles can easily be retrieved using e.g. curl. The full image can be reconstructed using ImageMagick montage:

montage +frame +shadow +label -tile NxM -geometry +0+0 *.jpg joined.jpg

where N is the number of horizontal tiles and M is the number of vertical tiles.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 110 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '110' AND comment_approved = '1'

No Comments »