Pages and Posts Disappeared

  • Resolved omercan

    (@omercan)


    15 years, 3 months ago

    I have wordpress installed on my local machine. I was working on a theme yesterday. I also have some other themes that I created before.

    I finished my work last night. Turned off the comp. Went to sleep. Turned it back on today. I pulled up https://localhost/… here we go… there is a another theme I used to work on last month. I switched to it to look at something yesterday when I was working on the current theme. It was just a few seconds look. Anyway…

    I got in to admin panel. I switched it back to the current theme I was working on. Viewed the site… Oh Well… All the pages and posts are gone. My new theme I created in tact but all the content(PAGES ANS POSTS) I created has just disappeared. They do not show in my wordpress admin panel.

    I went into phpmyadmin to see if the content was there. Oh my god… no pages.. no posts…

    I found a few articles online which they mention about the same problem but there is no instruction how they fixed it. I tried a few things in wp-config and phpmyadmin config.inc but I cannot determine the cause of the problem.

    Here some details:
    ZE Community Server 4.5 with phpmyadmin, mysql and Apache extensions
    Windows XP professional
    Zend Studio 7.0

    phpmyadmin config.inc.php
    $cfg[‘Servers’][$i][‘verbose’] = ”;
    $cfg[‘Servers’][$i][‘host’] = ‘localhost’;
    $cfg[‘Servers’][$i][‘port’] = ”;
    $cfg[‘Servers’][$i][‘socket’] = ”;
    $cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
    $cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
    $cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
    $cfg[‘Servers’][$i][‘user’] = ‘root’;
    $cfg[‘Servers’][$i][‘password’] = ”;
    $cfg[‘Servers’][$i][‘nopassword’] = true;
    $cfg[‘Servers’][$i][‘AllowNoPassword’] = true;

    wp-settings are:
    Default on admin panel.. https://localhost/?p=123
    define(‘DB_NAME’, ‘wordpress’);
    define(‘DB_USER’, ‘wordpress’);
    define(‘DB_PASSWORD’, ‘abc123’);
    define(‘DB_HOST’, ‘localhost’);

    PLEASE HELP! Thank you in advance.

Viewing 15 replies - 1 through 15 (of 17 total)

  • I went into phpmyadmin to see if the content was there. Oh my god… no pages.. no posts…

    If you don’t see them in the database then you are looking at the wrong database, the wrong tables, or you restored ‘over’ you database.

    Thread Starter omercan

    (@omercan)

    I’m looking at WordPress database with its tables. I’m looking at the right place. I did not do anything different than what I was doing any other time.

    Thread Starter omercan

    (@omercan)

    This is a major bug in wordpress. That kind of data loss should not happen just switching from one theme to another.

    This is a major bug in wordpress. That kind of data loss should not happen just switching from one theme to another.

    If you can duplicate the steps to cause your data to be deleted, then that should be reported as a bug. See Reporting Bugs.

    This has happened to 4 different blog sites that I have. My servers were recently upgraded to the latest mysql. The posts and pages are mysteriously wiped out when the blog is being updated. I haven’t been able to put a finger on what in particular is being worked on when everything vanishes.

    All of these blogs are using various versions of the thesis theme and thesis open hook. They also share a number of plugins.

    has anyone else been experienced this?

    I woke up this morning to find my whole database wiped clean and reverted to the original install. My webhost is insisting that I must have elected to restore my database, but according to the timestamp he provided it happened at 3:30 am when I was fast asleep. I wish I could figure out what caused it. The only thing I did was to make 2 new posts to the the blog from my computer, and 1 from my iphone app…

    Anyone have any ideas what’s going on?

    It happened again and I went in and looked at the database and the posts table had crashed and needed repairing. Once I repaired the database, the posts all re-appeared again.

    Same problem.

    I’ve had all my posts and pages wiped out on two WP blogs hosted on hostgator. I asked for help and they got them back up up again by doing a DB repair.

    When I asked how and why that happened they couldn’t say but “wordpress does that sometimes”.

    It’s definitely a bug – but where and how to fix it – I don’t have a clue.

    The only thing I remember doing was opening a post to edit it, then switching to upload media window before doing anything to the post, dialogue box – “are you sure you want to navigate away from this page” (presumably because I did not ‘update’ the post I opened) I say yes, go to media files, nothing there, back to posts, nothing there, go to pages, nothing there. All wiped out.

    I work only on Linux platforms although that shouldn’t be a factor, should it?

    I had this problem. (but it was not caused by changing themes or anything related to the theme)

    I was making a new post, then trying to upload a picture from my hard drive through the upload media window- the picture never would upload, though it was a small file. So I closed the window and went back to the draft I was working on. I clicked save draft and then the draft disappeared. I then went to the EDIT POST navigation page and No posts are listed. Also no pages are listed. I get a page not found error when I try to go to one of my pages from a google search.

    Went to Hostgator support for help. My tech said,

    “This is a common occurrence with wordpress sites in general. You can repair a database within cPanel by going to MySQL Databases and selecting the wordpress database involved and clicking repair.”

    Then he repaired it for me and all my posts and pages came back except the one that I was working on when it happened.

    There’s more than one reason a DB table can become corrupted, and there’s nothing to suggest this a problem specific to WordPress usage, after all, how many other apps do you have running that use a MySQl database? One, two, none?

    https://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html

    Love how the host quickly points the finger, so i’m going to point mine straight back and say it’s just as likely to be a poor host setup/configuration causing the table corruption as it is WordPress.

    I called my hosting company, and they said a database had been corrupted, and they fixed it. They were willing to tell me how to fix it myself, but I’m expecting this won’t happen again for a long time, so instead of writing down and storing the instructions, I’ll call back for help if it happens again some day.

    Moderator James Huff

    (@macmanx)

    Just in case anyone stumbles across this, here’s what you do:

    Access your WordPress database via phpMyAdmin (most hosting providers offer this in their control panel), check all of the tables, and choose “Repair tables” from the pull-down menu.

    You can also fix crashed tables from the command line (which is quicker and less risky than using phpMyAdmin) with the following commands:

    1. SSH into your server and connect to MySQL:

    mysql -u dbname -p dbusername

    2. Enter your database password when prompted.

    3. Check that the posts table has indeed crashed (you’ll get a message telling you it has):

    check table wp_posts;

    4. Repair the posts table:

    repair table wp_posts;

    I just encountered this problem myself. Repairing the database works… but this cannot be the only solution. Why is it happening? This shouldn’t be happening at all. Especially to multiple people.

    No answers other than, “repair your database again”?

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Pages and Posts Disappeared’ is closed to new replies.