never seen this in 10 years of WP

  • igabc

    (@igabc)


    9 years, 9 months ago

    I have almost 10 WP installations that are perfectly working on my dedicated server.

    The problem with one installation…

    1) unable to publish/save new pages/posts (only send for review button is available)
    2) unable to update existing posts/pages
    3) unable to upload media (progress bar stuck on 0%)
    4) unable to update wordpress (message: an update is ongoing (or similar)

    Thank you!
    G

Viewing 15 replies - 1 through 15 (of 21 total)
1 2
  • Moderator t-p

    (@t-p)

    9 years, 9 months ago

    – Please check the error logs on your server for a more specific error message and see why it’s failing. If you need help locating them, ask your hosting provider to help you with that.
    – If you cannot find error logs or if you don’t find any helpful info in the error logs, try Enabling debugging and post the results

    Thread Starter igabc

    (@igabc)

    9 years, 9 months ago

    [Mon Jul 04 02:02:48 2016] [warn] [client 78.46.81.XX] mod_fcgid: stderr: WordPress errore sul database Duplicate entry ‘0’ for key ‘PRIMARY’ per la query INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, post_type, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type, guid) VALUES (1, ‘2016-07-04 02:02:48’, ‘0000-00-00 00:00:00’, ”, ”, ‘Bozza automatica’, ”, ‘auto-draft’, ‘post’, ‘open’, ‘open’, ”, ”, ”, ”, ‘2016-07-04 02:02:48’, ‘0000-00-00 00:00:00’, 0, 0, ”, ”) fatta da wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_quick_press, get_default_post_to_edit, wp_insert_post

    Thanks Tara!

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 9 months ago

    Your database is corrupt. You may be able to repair it. Do you have access to phpMyAdmin or mysqlcheck from a command line?

    Since it’s a dedicated server, here’s what I’d do:

    1. shut down the web server process to no one is using the DB

    2. mysqlcheck -u root -p –auto-repair databasename

    See http://linuxcommand.org/man_pages/mysqlcheck1.html

    Then restart the web server process

    Thread Starter igabc

    (@igabc)

    9 years, 9 months ago

    I ran this line via SSH. All the tables returned as OK but nothing fixed

    thanks sterndata

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 9 months ago

    Do you have a backup from before this started happening? Restoring your database may be easier than hacking at the auto-update indexes.

    Thread Starter igabc

    (@igabc)

    9 years, 9 months ago

    no I do not.
    are you saying there is not way to fix it?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 9 months ago

    igabc: as someone who’s been using WP for 10 years, I’d expect you to have good backups. Anyhow….

    It seems mysql has lost track of what the next post ID should you. You need to set the next post ID (the auto-increment value) for that table to something higher that the last used ID. Do a query, get the highest ID, and set the auto-increment value to that plus 100 or so.

    Back up the database first. 🙂

    Thread Starter igabc

    (@igabc)

    9 years, 9 months ago

    It’s a new website I made 2 weeks ago. It wasn’t actually finished when I realized I couldn’t add new posts/pages. SO I didn’t bother making any backups yet.

    ok I’ll try. Thanks!

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 9 months ago

    Just a thought on how this got messed up

    1) a mysql crash, so check your logs (both /var/log/mysql or /var/log/mariadb and /var/log/messages) or
    2) you have more than one WP site using this database. Go do quick grep of your wordpress sites to make sure you see the db name in only one of them.

    Thread Starter igabc

    (@igabc)

    9 years, 9 months ago

    I use one db for each website. No shared DBs

    Ok it looks I fixed something…

    1) unable to publish/save new pages/posts (only send for review button is available) – FIXED
    2) unable to update existing posts/pages – FIXED
    3) unable to upload media (progress bar stuck on 0%) – UPLOAD and STORES the media file but the preview thumbnail is not visible in the media admin page (only a document icon)
    4) unable to update wordpress (message: an update is ongoing (or similar) – STILL NOT FIXED

    Thanks!

    Thread Starter igabc

    (@igabc)

    9 years, 9 months ago

    Update… the images are not visible even in front end in the pages/posts/galleries

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 9 months ago

    do you get a 404? please post a link to a page showing the problem.

    Thread Starter igabc

    (@igabc)

    9 years, 9 months ago

    This is what I get in the source of the post

    <img class="alignright size-large wp-image-242" alt="10mesi" />

    No src=”…..” in the tag, as you can see

    No 404 errors.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 9 months ago

    Interesting. Going back to your first post, your database is corrupt. If I were you, I’d realize I’m in a hole and stop digging. Rebuild the site. Make backups.

    Thread Starter igabc

    (@igabc)

    9 years, 9 months ago

    🙁
    ok.

    Let me ask you… do you think it will work if I export all the posts/pages/media via the TOOLS > EXPORT or it will cause the bad sh.. to end up on the new site?

    thanks meow!

Viewing 15 replies - 1 through 15 (of 21 total)
1 2

The topic ‘never seen this in 10 years of WP’ is closed to new replies.