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

Curioso! » Blog Archive » PictPress 0.9

PictPress 0.9

Update: The newest version is PictPress 1.0.

PictPress is a wordpress plugin that automatically appends thumbnails and picture pages to a post for all images found in the directory corresponding to the permalink of the post. Thumbnails and pictures are resized on the fly and stored in a cache directory. For an example see my post with Vermeer paintings.


  • PictPress needs the ImageMagick convert program to resize images.
  • PictPress needs the rdjpgcom program to read comments from the images.
  • The function exif_read_data must be available to read EXIF data like picture date etc.
  • WordPress must have a permalink structure enabled.


  1. Unzip pictpress.zip in the root directory of your site. This creates a pictpress directory next your wordpress directory.
  2. Move, copy or link the file pictpress/pictpress.php to the WordPress plugin directory, e.g. on a Unix system
    ln pictpress/pictpress.php wordpress/wp-content/plugins.
  3. Enable the PictPress plugin on the Plugins admin page.
  4. Insert a line @import url( /pictpress/pictpress.css ); after the import for the WordPress style sheet in your index.php.
  5. Insert a line
    RewriteRule ^cache/([0-9]+)/(.*) /pictpress/resize.php?size=$1&path=$2 [QSA] in your .htaccess file.




  1. First upload one or more JPEG images to the permalink directory you want to use
    (I use YYYY/MM/post-name myself).
  2. Then create a new post that will have this permalink.
  3. When pressing Publish, thumbnails for all images will be appended to the post (with a --more-- marker after the first five thumbnails) and for each image a picture page will be appended to the post. The thumbnails have links to the picture pages and the pictures have links to the full resolution image.
  4. If you want to edit the post, you have to delete the generated content before pressing Publish again.

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

Comments are closed.