Wordpress Issue Unexpected Response from the server The file may have been uploaded successfully.
I started facing this error after migrating my wordpress website to a new server: Unexpected Response from the server The file may have been uploaded successfully. Check in the Media Library or reload the page.
In the error logs, I was greeted with these errors:
mod_fcgid: stderr: WordPress database error Duplicate entry '0' for key 'wp_postmeta.PRIMARY' for query INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES
and
mod_fcgid: stderr: WordPress database error Duplicate entry '0' for key 'wp_posts.PRIMARY' for 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, '2021-07-28 22:13:14'