error 127

  • davepp

    (@davepp)


    17 years, 7 months ago

    Please can you help? My blog is a hosted one: http://www.ladd.co.za/blogware My WordPress profile davepp. My email address is dave@ladd.co.za. I received an error 127 when trying to “save and Continue editing” on the latest post. I managed to get it up after about 3 hours, by going in and out of the Write Screen. I checked the forum, followed the advive there and approached my host and he has run database repairs. I am still getting error messages. The host asked me to mention that I had run out of disk space when this happened. We fixed that immediately. I have 2 blogs, so he ran repairs on both. I ran a backup just before the repairs were done – hopefully I won’t lose anything. The latest error message is below, followed by the repair log from the host. Can anyone help us please?

    WordPress database error: [Got error 127 from table handler]
    SELECT COUNT(*) FROM wp_post2cat, wp_posts WHERE wp_posts.ID=wp_post2cat.post_id AND post_status=’publish’ AND category_id = ‘4’

    WordPress database error: [Got error 134 from table handler]
    SELECT * FROM wp_posts WHERE ID = ’60’ LIMIT 1

    WordPress database error: [Got error 124 from table handler]
    UPDATE wp_posts SET guid = ‘http://www.ladd.co.za/blogware/?p=’ WHERE ID = ’60’

    WordPress database error: [Got error 134 from table handler]
    SELECT * FROM wp_posts WHERE ID = ’60’ LIMIT 1

    Warning: Cannot modify header information – headers already sent by (output started at /home/laddco/public_html/blogware/wp-includes/wp-db.php:104) in /home/laddco/public_html/blogware/wp-includes/pluggable-functions.php on line 272

    Database Problem on my Blog

    As requested, we ran a repair on the database as follows:

    Please mention that you ran out of disk space while trying to post to your blog. This could be vital as only certain bits might have reached the database.

    # myisamchk -r *.MYI
    – recovering (with sort) MyISAM-table ‘sk2_blacklist.MYI’
    Data records: 424
    – Fixing index 1

    ———

    – recovering (with sort) MyISAM-table ‘wp_categories.MYI’
    Data records: 15
    – Fixing index 1
    – Fixing index 2

    ———

    – recovering (with sort) MyISAM-table ‘wp_comments.MYI’
    Data records: 797
    – Fixing index 1
    – Fixing index 2
    – Fixing index 3

    ———

    – recovering (with sort) MyISAM-table ‘wp_linkcategories.MYI’

Viewing 9 replies - 1 through 9 (of 9 total)
  • Samuel B

    (@samboll)

    17 years, 7 months ago

    Error 127 indicates a record has crashed. I can’t believe your host can’t fix this. This is not a WP problem.

    livinadaydream

    (@livinadaydream)

    17 years, 5 months ago

    WordPress database error: [Got error 127 from storage engine]
    SELECT COUNT(DISTINCT ID) FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2006-10-27 03:44:59’ AND (post_status = “publish”) AND post_status != “attachment”

    I have the same problem. My blog is at http://enthused.org and I have pleanty of disk space. I don’t have any backups, and I can’t stand to lose everything. I don’t even know where to begin to fix it.

    HELP! =(

    Chris_K

    (@handysolo)

    17 years, 5 months ago

    error 127 is still a MySQL error. Contact your host.

    katherinesands

    (@katherinesands)

    16 years, 12 months ago

    I too am having an error 127 problem. My host, freeservers.com seem to think the answer is for me to install WordPress again, thereby losing all my posts and all my data. Is this really necessary???

    BradyDale

    (@bradydale)

    16 years, 9 months ago

    I’m having this trouble, too. I’ve been reading the various threads on it but I’m not getting anywhere. I guess I’m just venting because my computer at home just went down so I can’t really dig into this at work.

    Here’s what I do know, though, I ran a Database Repair and it did nothing. That stinks.

    I have a second blog that’s hosted in the same database. It’s okay, but this one is not. Ouch.

    lowrentit

    (@lowrentit)

    16 years, 9 months ago

    I too have this same problem. My archives are still intact but but the “main page” is gone. I’ve tried the repair but it just made my archives disappear, so now I restored my DB and now i’m back to square one.

    If any one has any success stories PLEASE post.

    moshu

    (@moshu)

    16 years, 9 months ago

    lowrenIT,
    stop double posting and start reading!
    Quotes from above:

    1. Error 127 indicates a record has crashed. I can’t believe your host can’t fix this. This is not a WP problem.

    2. error 127 is still a MySQL error. Contact your host.

    BradyDale

    (@bradydale)

    16 years, 8 months ago

    It seems like everyone who’s having this problem is on Yahoo! and that Yahoo! won’t do anything.
    Sooooo…
    here’s a question. If we migrated our whole website to another host, would that screw everything up?
    Would they then be able to fix it?

    dwagle

    (@dwagle)

    16 years, 8 months ago

    My site http://www.blog.com.np has been hosted on iPower. When I logged in, I saw this message at the top of the Dashboard:

    WordPress database error: [Got error 127 from table handler]
    SELECT COUNT(comment_ID) FROM bl_comments WHERE comment_approved = ‘spam’

    When I opened the site, there were no comments.

    I was receiving massive spam (not filtered by Akismet). Can anyone suggest what’s going on with my site?

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘error 127’ is closed to new replies.