WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_str8_posts LEFT JOIN wp_str8_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (5422,5421,5420) GROUP BY ID

STR8BLOGGIN » 2007 » May

Archive for May, 2007

Secure browser sessions by proxying through SSH

Tuesday, May 8th, 2007

Download Putty and Puttygen
Run Puttygen
Create a private key; save it somewhere on your harddrive. Don’t bother with encrypting/passwording it.
Copy the public key (shown in the box) with Ctrl-C
Login to the server you want to proxy through, as normal, with Putty
Edit .ssh/authorized_keys - you may have to create the .ssh folder
Paste your public key on one long line into the file and then log out of the server
Load your Putty settings for the site
On the left, go to Connection -> Data and enter your username where it says “Autologin Username”
On the left, go to Connection -> SSH -> Auth, and select your private key
On the left, go to Connection -> SSH -> Tunnels, type source port 1080 (or whatever you want), …

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_str8_comments WHERE comment_post_ID = 5422 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(*) FROM wp_str8_comments WHERE comment_post_ID = '5422' AND comment_approved = '1'

No Comments »

Birds are smart

Monday, May 7th, 2007

The complex intellect of ravens has me rethinking my recent dietary changes to be more morality-compliant. I gave up red meat but kept chicken, and I’m starting to think I may have to axe the fowl entirely. Dohhh.

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_str8_comments WHERE comment_post_ID = 5421 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(*) FROM wp_str8_comments WHERE comment_post_ID = '5421' AND comment_approved = '1'

No Comments »

Goodbye, Digg

Tuesday, May 1st, 2007

I don’t need you selling your users to your sponsors over a few hex digits. Reddit has a better algorithm anyway.

Oh, and 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0.

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_str8_comments WHERE comment_post_ID = 5420 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(*) FROM wp_str8_comments WHERE comment_post_ID = '5420' AND comment_approved = '1'

No Comments »