Posted with ECTO – Corrupted Database

  • Why this would happen makes no sense to me but here’s what I did. I sent three articles in about a min. time span using Ecto, Isent the first, then I edited and updated a second one, and then sent a third one after those were sent. I checked the blog after the first two and it was ok, then I sent the third and it wouldn’t go – said parse error or something (this is normal for Ecto). I switch over to my blog to check to see if it went anyway and everything was gone. I logged into my account, when to manage posts, and they are all gone.

    Is there anything I can do? I do have a backup of the database that’s about 4 weeks old. Is there a better solution?

    Thanks in advance for your help.

    https://gatheringinlight.com

Viewing 8 replies - 1 through 8 (of 8 total)

  • You could take a look at your database with phpmyadmin (if you have access to it) and see if the posts are still there, and just not showing up.

    If so, you could manually delete those last posts from the database in case one is somehow messing things up.

    If you do not see any posts in the database even through phpmyadmin then you may be forced to restore from the backup unfortunately.

    Thread Starter cwdaniels

    (@cwdaniels)

    I will look into your suggestion aleister right now —

    here is the error i am getting

    WordPress database error: [Can’t open file: ‘wp_posts.MYI’ (errno: 145)]

    SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON (wp_post2cat.category_id = wp_categories.cat_ID) WHERE 1=1 AND (category_id = ’21’) AND post_date_gmt <= ‘2006-04-12 05:04:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND post_status != “attachment” GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 1

    Thread Starter cwdaniels

    (@cwdaniels)

    How do I find the posts in phpadmin? I looked under databases and found my WP one, I see one called wp_posts but it says under collation “in use.” Am I in the right spot?

    here’s my IM (gatheringinlight) if you’re online and would rather go that way. Thanks again.

    What service is that? MSN?

    Actually, I am sorry but I have to go right now..

    Since you are getting the ‘in use’ message, there is a good chance that the database is corrupt. You can try a repair though from phpmyadmin.

    Here is a nice visual tutorial:

    https://www.tamba2.org.uk/wordpress/repair/

    Let us know how it goes!

    Thread Starter cwdaniels

    (@cwdaniels)

    No its AIM – thanks for your time I will check out the tutorial.

    I have not left quite yet.. I will in just a minute or so. I pulled up your page again and see that there are posts, so I am guessing it worked ??

    Hopefully everything is there. ??

    Thread Starter cwdaniels

    (@cwdaniels)

    Ok – I got it running again. It was a pretty easy fix.
    Once I went into the database and found wp_posts – it wouldn’t let me “browse” because under collation it said it was “in use.” Something about Ecto didn’t tell it do stop running, or something. Anyways – I checked the box next to the table wp_post, scrolled to bottom drop-down menu and selected “check table.” The first message showed up as an error, but then it fixed whatever was wrong and gave a second message that said it was OK. Its all back to normal. Aleister thanks for your help.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Posted with ECTO – Corrupted Database’ is closed to new replies.