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

Curioso! » Blog Archive » PictPress 0.99

PictPress 0.99

Update: The newest version is PictPress 1.0.

PictPress is a WordPress 1.2 plugin that automatically generates a post with thumbnails and picture posts for all images found in a directory. Thumbnails and pictures are resized on the fly and stored in a cache directory. For an example see my post with pictures of a Treble concert.


  • PictPress needs either the ImageMagick convert program or the GD2 library to resize images.
  • PictPress optionally uses exif_read_data or the rdjpgcom program to read comments from the images.; exif_read_data is also optionally used to read EXIF data like picture date etc.
  • You will need some other means to upload images to subdirectories of the WordPress upload directory.


  1. Unzip pictpress.zip in the plugin directory of your WordPress site. This creates a pictpress plus a pictpress.php file.
  2. Go to the Plugin admin page and press the install link.
  3. Enable the PictPress plugin on the Plugins admin page.
  4. Make sure that you have configured a valid destination directory for Uploads under Options Misceallaneous and that the web server has write access to the upload directory.


  1. First upload one or more JPEG images to a subdirectory of the WordPress upload directory according to the setings for pp_image_dir
    (I use %year%/%monthnum%/%postname% myself).
  2. Then create a new post that will use this directory (in my case by maing sure that date and Post Slug are the same as used for the directory).
  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 post will be generated. The thumbnails have links to the picture posts and the pictures have links to the full resolution images.
  4. Titles for the picture posts are either set to the JPEG comment or to the image filename.
  5. Captions under the thumbnails are set to the corresponding picture post titles and follow updates being made to the titles.
  6. When updating a post, any new images in the image directory are merged with the existing post and the thumbnails are replaced by the new set. This is the way to include new pictures after these have been added to the image directory. Edits to posts between the PictPress comment tags are lost; other edits are kept.
  7. Picture posts are suppressed from the post overview pages and in principle should only appear on pages of their own.


There are a number of options that can be confgured via the PictPress options form that can be reached from the WordPress options pages.

  • Location of image directory
  • Location of cache directory for resized images
  • URL used for resized images
  • Size of thumbnails and images on picture pages
  • Maximum number of thumbnails per page
  • Number of thumbnails before more…
  • Image resize method, ImageMagick or GD2.
  • Strings for use in title, alt attribute, captions.
  • Protect images against referrers from other web sites yes/no.
  • Automatically insert CSS header yes/no
  • Generate a single post for all pictures yes/no; this switches back to the behaviour of the previous version, see the PictPress 0.91 description.

The strings used for title etc. can contain the following variables:

  • %aperture%, EXIF aperture setting
  • %comment%, JPEG comment
  • %date%, EXIF DateTimeOriginal
  • %digitized%, EXIF DateTimeDigitized
  • %edited%, edited date
  • %exif%, table with all info returned by exif_read_data
  • %exposure%, EXIF ExposureTime
  • %focallength%, EXIF FocalLength
  • %height%, height of image in pixels
  • %iso%, EXIF ISOSpeedRatings
  • %make%, camera manufactureer
  • %model%, camera model
  • %modified%, file modified date
  • %size%, file size in bytes
  • %sizekb%, file size in kilobytes
  • %sizemb%, file size in megabytes
  • %title%, title of picture post
  • %width%, width of image in pixels

Template Functions

The following template functions can be used in index.php (I put them at the top of the menu section myself):

  • pp_prev_thumb(), generate thumbnail for previous picture post if applicable.
  • pp_next_thumb(), generate thumbnail for next picture post if applcable.
  • pp_navigation(), generate navigation section with link to post with thumbnails, thumbnail for previous picture post, and thumbnail for next picture post, all if applicable.

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

Comments are closed.