WordPress.org

1. laurelin77
   Member
   Posted 1 year ago #

   I was in the middle of writing a new post in my blog. I went to upload a photo and it wouldn't upload. I went to save the post and it said the post was unknown and couldn't be saved. I went to the dashboard and it says:
   You have , contained within 3 categories and 10 tags. You have 280 total comments, 278 approved, 1 spam and 1 awaiting moderation.

   I'm logged in, but my User Online stats say there are 0 people logged in. When I log out and log back in, I'm taken to my home page which now reads, "Sorry, you are looking for something that isn't here."

   What has happened? I didn't upgrade anything, change anything, post anything, or upload anything (except the picture which didn't even upload successfully). When I try to access the blog from another computer, I get the exact same thing, so it can't be my browser or my computer.

   Please help! I have 115 customers that use this blog on a daily basis. I can't have it gone!

2. whooami
   Member
   Posted 1 year ago #

   we need more info

   1. whats the url to the blog
   2. have you checked the status of the tables in the database? if not, you need to do so.

3. laurelin77
   Member
   Posted 1 year ago #

   http://evenstarpaperie.com/blog

   I have no idea how check the status of the tables...

4. whooami
   Member
   Posted 1 year ago #

   I have no idea how check the status of the tables...

   phpmyadmin. youre on yahoo hosting. read this:

   http://help.yahoo.com/l/us/yahoo/smallbusiness/webhosting/mysql/mysql-05.html

5. whooami
   Member
   Posted 1 year ago #

   the other thing I would do is disable ALL of your plugins. There is at least one other problem that IS being caused by a plugin, that I see, that disabling them all will fix.

6. laurelin77
   Member
   Posted 1 year ago #

   I installed the phpmyadmin...what do I do from there??

7. laurelin77
   Member
   Posted 1 year ago #

   And I've disable all the plugins...no fix.

8. whooami
   Member
   Posted 1 year ago #

   theres a link right off the directions I gave you ..

   it goes here:

   http://help.yahoo.com/l/us/yahoo/smallbusiness/webhosting/mysql/mysql-25.html

9. laurelin77
   Member
   Posted 1 year ago #

   Yes, I got there. I have PHPmyadmin up and running in my browser window. I just don't know what all the numbers mean or what needs to be done to fix whatever is wrong.

10. laurelin77
    Member
    Posted 1 year ago #

    I'm looking at the database structure for my blog. The lines for wp_posts and wp_users say "in use" and generate errors when you try to go to their individual structure. The errors say:
    MySQL said: Documentation
    #1016 - Can't open file: 'wp_posts.MYI' (errno: 145)
    MySQL said: Documentation
    #1016 - Can't open file: 'wp_useronline.MYI' (errno: 145)

    Don't know what this means or how to fix!

11. whooami
    Member
    Posted 1 year ago #

    OK. sorry it took so long, I had to go do artwork for you.

    http://www.village-idiot.org/broke/tables.gif

    Eventually, if you look around in there, you will get to a page where there are rows .. and all the rows begin with wp_

    those are you tables, and the page content is going to have that stuff in it.

    Ive blacked out my table names.

    The bit I highlighted in red, in that image, is the size of the tables. None of them should be 1K, and there should be records in all of them.

    The red highlighting is the one you want to NOT be 1Kb.
    The blue highlighted field should NOT be 0.
    Ive also shown you what an empty table will look -- thats the yellow circled row.

    thats the yellow one.

    If you see empty tables, stop where you are, take note of them, and come back and here and tell me what the names of the empty are.
    .
    If you do not see empty tables than do like the green is, and check ALL the boxes, then go down to where the drop down menu is (with selected) and choose check table,

    whats the result of that?

12. whooami
    Member
    Posted 1 year ago #

    .. follow the green box again.. check all the boxes, and the where the "with selected" menu is, choose "Repair Table"

13. laurelin77
    Member
    Posted 1 year ago #

    The only empty table I have is wp_subscribe2. All the others have numbers in them except wp_posts and wp_useronline whose entire lines read "in use".

14. whooami
    Member
    Posted 1 year ago #

    wait..

15. whooami
    Member
    Posted 1 year ago #

    All the others have numbers in them except wp_posts wp_useronline whose entire lines read "in use".

    Ok, so theyre locked, basically. See if the repair fixes them, if not, you may need to contact yahoo and tell them that they are locked up.

16. laurelin77
    Member
    Posted 1 year ago #

    Do I just check their boxes and repair or all the boxes?

17. whooami
    Member
    Posted 1 year ago #

    yes.

18. whooami
    Member
    Posted 1 year ago #

    you cant break anything UNLESS you choose empty or drop, and you get a second chance if you do that. dont be afraid.

19. laurelin77
    Member
    Posted 1 year ago #

    I got all OK's except here:

    blog.wp_posts repair info Wrong bytesec: 110- 32-116 at 2058980; Skipped
    blog.wp_posts repair warning Number of rows changed from 463 to 462

20. laurelin77
    Member
    Posted 1 year ago #

    Ah! But, it's back!!! You're my hero! Can I enable my plugins again or leave them disabled?

21. whooami
    Member
    Posted 1 year ago #

    you can enable them. you might want to look into what caused the problem in the first place. Maybe its the revisions and something in how yahoo has their mysql servers set up -- since those revisions get written to the db. Just a thought.

    perhaps look into the 'disbale revisions' plugin?

22. laurelin77
    Member
    Posted 1 year ago #

    Thank you. I will! I'll also start backing up my posts so, should I lose them, they won't be gone forever!!

23. lao3d
    Member
    Posted 4 months ago #

    Same exact thing happened to me while writing a post -- you are my hero now, too! The "repair" function worked on my database "wp_post" table which was stuck reading "in use" just as described above. Solution worked like a top, thanks!!

Topic Closed

This topic has been closed to new replies.