WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
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 (1099) GROUP BY ID

An Activist’s Life, by Thomas Leavitt » Blog Archive » Knoppix

WordPress database error: [Can't open file: 'wp_secureimage.MYI' (errno: 145)]
DELETE from wp_secureimage WHERE img_datetime < '2008-07-20 13:54:33'

« Requiem for a fictional Scotsman
A Gnostic Creation Myth »
July 25th, 2005
Geek stuff

Knoppix

For over a year now, I’ve been running Knoppix as my primary computer operating system… after my anti-virus program went crazy and ate my Windows XP installation, I just couldn’t face reconstructing it. So I burnt a copy of Knoppix to CD, and off I went. Never looked back - never even bothered installing to hard disk, because the default auto-configuration worked perfectly… well, almost: it doesn’t do hardware acceleration. But: Games Knoppix does. However, that hasn’t been updated since January. :(

Crack Attack! without hardware acceleration just does not cut it - way too sluggish. And I have an ATI Radeon Pro 256 megabyte hellacious video card in my dual processor Xeon 2.8 GHz desktop, so it is somewhat of a waste not to have accelerated video.

And now, the Knoppix people have released a bootable DVD, with 4 GIGABYTES of goodies… but for some godforsaken reason (licensing? but then why can Games Knoppix do it? or is it a “purity” issue, “tainting” the kernal and all that?) they don’t include the option to use hardware acceleration. So I was taking a break from other work last night, and dug around to find out how to fix this.

Pretty much looks like I’m going to have to remaster my own version of Knoppix, yikes - not really my thing, screwing around with kernal recompiles, etc. but at least there appears to be a fair amount of information out there about how to do it. Am glad I have the skills to be able to tackle such a project, even if I’d prefer not to bother.

divider

This entry was posted on Monday, July 25th, 2005 at 1:41 pm, and is filed under Geek stuff. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT * FROM wp_comments WHERE comment_post_ID = '1099' AND comment_approved = '1' ORDER BY comment_date

Leave a Reply

WordPress database error: [Can't open file: 'wp_secureimage.MYI' (errno: 145)]
INSERT INTO wp_secureimage (img_name, img_data, img_datetime) VALUES ('5d36165f3acf4473950a2f580e4ac30e','','2008-07-20 14:04:33');