Title: never seen this in 10 years of WP Last modified: June 29, 2017 --- # never seen this in 10 years of WP * [igabc](https://wordpress.org/support/users/igabc/) * (@igabc) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/) * 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](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/page/2/?output_format=md) [→](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/page/2/?output_format=md) * Moderator [t-p](https://wordpress.org/support/users/t-p/) * (@t-p) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541142) * – 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 ](http://codex.wordpress.org/Debugging_in_WordPress) and post the results * Thread Starter [igabc](https://wordpress.org/support/users/igabc/) * (@igabc) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541270) * [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)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541272) * 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](http://linuxcommand.org/man_pages/mysqlcheck1.html) * Then restart the web server process * Thread Starter [igabc](https://wordpress.org/support/users/igabc/) * (@igabc) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541276) * I ran this line via SSH. All the tables returned as OK but nothing fixed * thanks sterndata * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541284) * 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](https://wordpress.org/support/users/igabc/) * (@igabc) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541333) * no I do not. are you saying there is not way to fix it? * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541334) * 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](https://wordpress.org/support/users/igabc/) * (@igabc) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541335) * 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)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541336) * 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](https://wordpress.org/support/users/igabc/) * (@igabc) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541350) * 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](https://wordpress.org/support/users/igabc/) * (@igabc) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541385) * Update… the images are not visible even in front end in the pages/posts/galleries * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541386) * do you get a 404? please post a link to a page showing the problem. * Thread Starter [igabc](https://wordpress.org/support/users/igabc/) * (@igabc) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541387) * This is what I get in the source of the post * `10mesi` * No src=”…..” in the tag, as you can see * No 404 errors. * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541388) * 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](https://wordpress.org/support/users/igabc/) * (@igabc) * [9 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/#post-7541389) * 🙁 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](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/page/2/?output_format=md) [→](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/page/2/?output_format=md) The topic ‘never seen this in 10 years of WP’ is closed to new replies. ## Tags * [media](https://wordpress.org/support/topic-tag/media/) * [updating](https://wordpress.org/support/topic-tag/updating/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 21 replies * 4 participants * Last reply from: [t-p](https://wordpress.org/support/users/t-p/) * Last activity: [8 years, 9 months ago](https://wordpress.org/support/topic/never-seen-this-in-10-years-of-wp/page/2/#post-9275141) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics