BIG database problem!!! Please help!

  • Resolved darko74

    (@darko74)


    16 years, 7 months ago

    I was writing a long long entry about some programming matter. It took me many hours to write it and explain the code.

    But, I don’t know how, I was so idiot to change the wordpress database password of my hosting provider before saving or publishing it. It of course gave me an error when I tried to save the last changes. I got initially shocked because I thought I had lost the last added text (a lot of text). Lucky me I use Firefox, and when I got back to the previous page, everything was still there. Then I edited the wp-config.php file (as the error message suggested) and updated the password variable to the new one.

    Now there’s no error displayed, but everytime I try to save the entry, the text area appears blank when the page is reloaded, and after checking the entry again, or previewing it etc, I can see that it’s totally empty!! even though everytime I paste on the text area all the text I previously saved in a text editor and next click on save, a message saying that the entry has been updated is displayed.

    Please what can I do to restore WP working well with the database??

Viewing 4 replies - 1 through 4 (of 4 total)
  • Mark Ratledge

    (@songdogtech)

    16 years, 7 months ago

    Probably nothing wrong with your databse. Cut and save the text you want, then delete the problematic post/page and start a new post/page.

    Thread Starter darko74

    (@darko74)

    16 years, 7 months ago

    Thanks songdogtech!

    I’ve done what you suggested:
    Bad posts deleted and started a new one. Saved it just once. The text still remains filled out, and just below the save button a small message says: Draft saved at 18:48:01

    Afterwards I’ve checked the database with phpmyadmin, and the post is stored in the wp_posts table, but these values are wrong in the record:

    post_date post_date_gmt
    —————- ——————–
    0000-00-00 00:00:00 0000-00-00 00:00:00

    Now if I click on “save” again, the page is reloaded, the “post updated” message is displayed, and the editor appears blank just as I told before. After checking the database again, now I see a new record has been created in wp_posts. This time it looks normal… but anyway it’s not displayed on the editor.

    Any suggestion to add??

    These are the values of the two records just in case this was useful:
    ID: 54, 55
    post_author: 1, 1
    post_date: 0000-00-00 00:00:00, 2009-11-13 18:48:01
    post_date_gmt: 0000-00-00 00:00:00, 2009-11-13 17:48:01
    post_content: the whole text…., the whole text….
    post_title: test, test
    post_category: 0, 0
    post_excerpt: -, –
    post_status: draft, inherit
    comment_status: open, open
    ping_status: open, open
    post_password: -, –
    post_name: -, 54-revision
    to_ping: -, –
    pinged: -, –
    post_modified: 2009-11-13 18:55:11, 2009-11-13 18:48:01
    post_modified_gmt: 2009-11-13 17:55:11, 2009-11-13 17:48:01
    post_content_filtered: -, –
    post_parent: 0, 54
    guid: http://myweb/blog/?p=54, http://myweb/blog/?p=55
    menu_order: 0, 0
    post_type: post, revision
    post_mime_type: -, –
    comment_count: 0, 0

    Mark Ratledge

    (@songdogtech)

    16 years, 7 months ago

    Clear cache and cookies, delete history, restart browser. Deactivate any cache plugins you might be using. Publish the post, too, to see if it appears OK.

    Thread Starter darko74

    (@darko74)

    16 years, 7 months ago

    It works!!

    I did clear the cache previously but didn’t delete any cookie. Now I’ve tried and it works!!

    Thanks a lot songdogtech!! 😀

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

The topic ‘BIG database problem!!! Please help!’ is closed to new replies.

Tags