never seen this in 10 years of WP

– 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

[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!

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 https://linuxcommand.org/man_pages/mysqlcheck1.html

Then restart the web server process

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

thanks sterndata

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

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

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. ??

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!

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.

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!

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

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

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.

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.

??
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!