Support » Fixing WordPress » WordPress db error Got error 28 / images not displaying

  • The site in question is one that is used basically 3/4 of the year – over the summer it is dormant. It was working fine in June. I looked at it today and everywhere there should be an image, I see a blank box with a black X in the upper left hand corner.

    If I click on the Video’s tab of the site, the video thumbnail does not appear. However if I click where the thumbnail should be, the video will play.

    The site itself works fine other than that.

    When I log into my WordPress account, and look at the available Themes, or even my Media, I do not see any thumbnails/photos, but just blank boxes with the black X in the upper corner. I have not done anything to the site between June and today.

    Today I tried upgrading to WP Ver 3.6.1 – no joy.
    I checked my php error log and am seeing errors like this:
    [14-Sep-2013 09:02:48] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’, ‘post_format’) AND tr.object_id IN (1021) ORDER BY ASC made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms

    All start out with the “Got error 28 from storage engine for SELECT”. The info that follows differs by error.

    I have removed all plug-ins, but the problem still remains. Tried various combinations of.. the problem still remains. is the site.

    Any ideas greatly appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • that error 28 indicates a shortage of disk space . check into your hosting account.

    Thanks so much dohman! I had seen other topics also indicating a disc space shortage, but the hosting firm said no, it wasn’t on their end. When I got your post, I went back to the hosting company and was a lot more forceful about it. They dug around and in my case, found that it turns out that there was an error in a RewriteRule in the .htaccess file of my primary domain. It should have looked like this:
    RewriteRule ^.*\.(jpg|jpeg|gif|png|bmp) /wp-content/plugins/wp-retina-2x/wr2x_image.php [QSA,L]

    I did not realize that the .htaccess file of the primary domain could impact a subdomain. Learned something today.

    I appreciate your taking the time to point me in the right direction dohman!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress db error Got error 28 / images not displaying’ is closed to new replies.