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 (5369) GROUP BY ID

STR8BLOGGIN » Blog Archive » Stupid Lighttpd tip

Stupid Lighttpd tip

When you want to turn on SSL, you must use a conditional on the $SERVER[”socket”] variable to set the PEM path and all that junk. Example from the bottom of my lighttpd.conf:

server.document-root  = \"/home/satan/public_html/\"
server.error-handler-404 = \"/?_error=404\"
accesslog.filename  = \"/home/satan/access-log\"
server.errorlog  = \"/home/satan/error-log\"
$SERVER[\"socket\"] == \":443\" {
        ssl.engine                 = \"enable\"
        ssl.pemfile                = \"/usr/local/etc/www.satan.com.pem\"

This instruction is actually magical: it causes the server to listen on that port. Which is pretty stupid if you ask me, but I love lighty anyway.

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

Leave a Reply