Support » Fixing WordPress » WordPress database error 127 possibly triggered by spam or bastats

  • I have a WordPress blog on Yahoo Small Business (which is why I’m still on version 2.0.2 and chosen because of the 1 click install, but I didn’t realise how problematic support issues would be!). I’ve had an ongoing problem where the blog has been down for the last two weeks. I explain the current problem, but then relate the background to this point:

    The blog is installed in (because the Yahoo install process doesn’t allow you to install the blog in the root directory). That, and the various links, seems to display OK, but at (where people normally find my blog) it either hangs with the standard not found message, or loads with the following error at the top of the page:

    WordPress database error:[Can’t open file: ‘wp_bas_log.MYI’ (errno: 144)

    And in my recent comments section I get:

    WordPress database error: [Got error 127 from storage engine] SELECT DISTINCT wp_comments.* FROM wp_comments LEFT JOIN wp_posts ON wp_posts.ID=wp_comments.comment_post_ID WHERE (post_status = ‘publish’ OR post_status = ‘static’) AND comment_approved= ‘1’ AND post_password = ” AND comment_type = ” ORDER BY comment_date DESC LIMIT 5

    When I go in to site admin (from /btz) I get the following error at the top of the page above the dashboard:

    WordPress database error: [Got error 127 from storage engine]
    SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = ‘spam’

    And the following error in the latest activity right column, just before the comments section:

    WordPress database error: [Got error 127 from storage engine]
    SELECT comment_author, comment_author_url, comment_ID, comment_post_ID FROM wp_comments WHERE comment_approved = ‘1’ ORDER BY comment_date_gmt DESC LIMIT 5

    Other options I try within site admin display, but with the same error at the top each time.

    When I look in phpMyAdmin, all of my data appears to be fine, except that a table called wp_bas_log is “in use”. I understand that is used/created by the bastats plug in. I’ve tried deactivating and reactivating bastats, but that hasn’t changed anything. I’ve tried running a repair of the database. My friend Ismael had a similar problem on his Yahoo Small Business and he resolved his by a simple save and restore of the MySQL database. I’ve tried that too, which initially appeared to make things worse, but now I’m back to the above situation.

    Please can somebody help or advise me?

    The problem seems to have been caused initially while I was marking/moderating a deluge of spam comments (about 80 that weren’t trapped by Akismet). The normal process fell over and left several tables related to bastats in use, but also meant that PHP was not running properly on the site, and I couldn’t access phpMyAdmin properly. I’ve had numerous calls and email exchanges with Yahoo support. I hadn’t realised that anything to do with supporting the database is by email only and 24 hour turnaround if you are lucky. To date, they have been of very limited help. One of the frustrations is that the characteristics of the problem seemed to change each time I look or try things. (Maybe that’s my lack of technical experience.) See the previous forum post and resolutions suggested that I tried, which have changed things but not resolved things yet.

    whooami was a great help. Please treat me like a newbie.

    Thanks in advance!

Viewing 1 replies (of 1 total)
  • Try running a repair on the table. The error that you get has been discussed many times in the past if you want to review the previous threads.

Viewing 1 replies (of 1 total)
  • The topic ‘WordPress database error 127 possibly triggered by spam or bastats’ is closed to new replies.