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 (79,78,77,76,75,74,73) GROUP BY ID

Curioso! » 2005 » September


Archive for September, 2005

Reverse proxy for EyeHome

Wednesday, September 28th, 2005

My EyeHome is connected to the Ethernet port of my Powerbook with Internet sharing enabled to the Airport. This provides access to the Internet, but not to other computers on my LAN. In order to reach my iMac, I added a reverse proxy to /etc/httpd /httpd.conf:

  • Uncomment
    #LoadModule proxy_module       libexec/httpd/libproxy.so
    
    and
    #AddModule mod_proxy.c
    
  • Add these lines
    Listen 8001
    <VirtualHost *:8001>
        ProxyPass / http://192.168.1.30:8000/
    </VirtualHost>
    
    where 192.168.1.30 is the IP address of my iMac

This forwards HTTP requests to port 8001 of my Powerbook to port 8000 of my iMac (where EyeHome is running).

It appears that instead of the EyeHome software on Mac, you can also run the Neuston Media Center software on Linux or Windows. Update: not really, apparently the EyeHome and the Neuston Media Center are distinguishable by the server.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 79 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 = '79' AND comment_approved = '1'

No Comments »

EyeHome links

Monday, September 26th, 2005

The EyeHome is a TV settop box that provides access from a television set to EyeTV recordings, movies, pictures and music stored on a Mac. Information on the web is sparse, but I did find some useful links:

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 78 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 = '78' AND comment_approved = '1'

No Comments »

Ruby IMAP server

Tuesday, September 13th, 2005

I tried to get ximapd running with the Hyper Estraier backend. In order to get Thunderbird to login, I had to remove LOGINDISABLED from the CapabilityCommand. Further my Hyper Estraier install only provided an estraier.so library for Ruby support, while the Hyper Estraier backend is referencing a HyperEstraier class. I replaced all HyperEstraier by Estraier, but then got stuck on a “no such document” message. After replacing the line

        result = @index.search(cond, 0)
        return result.to_a

by

        result = @index.search(cond)
        a = Array.new
        for i in 0...result.doc_num
          a << result.get_doc_id(i)
        end
        return a

it worked.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 77 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 = '77' AND comment_approved = '1'

No Comments »

Ruby servers

Wednesday, September 7th, 2005

Some servers/daemons written in Ruby:

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 76 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 = '76' AND comment_approved = '1'

No Comments »

Warped Passages

Monday, September 5th, 2005

Unraveling the Mysteries of the Universe’s Hidden Dimensions
This book gives an overview of discoveries in theoretical physics from early twentieth-century physics to curent particle physics and string theory.
Read the rest of this entry »

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

Comments Off

Programming Ruby

Monday, September 5th, 2005

Ruby is an increasingly popular, fully object-oriented dynamic programming language. This book gives a complete description, comprising:

  • a tutorial on using Ruby
  • a reference to the language
  • documentation on all built-in classes, modules, and methods
  • descriptions of all 98 standard libraries

Read the rest of this entry »

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 74 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 = '74' AND comment_approved = '1'

No Comments »

Agile Web Development with Rails

Thursday, September 1st, 2005

Rails is a new approach to web development written in Ruby:

  • develop sophisticated web applications quickly and easily;
  • use incremental and iterative development to create the web apps that users want; and
  • get to go home on time.

This book gives an introduction to Rails, an example shopping application, and an in depth overview of all aspects of Rails.
Read the rest of this entry »

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 73 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 = '73' AND comment_approved = '1'

No Comments »