Since the upgrade i get the following;
[19-May-2024 11:04:37 UTC] WordPress database error Duplicate entry ‘0’ for key ‘wp_postmeta.PRIMARY’ for query INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES (5411, ‘_oembed_038bd0fc5d14aa5cc1550aa5c38953bc’, ‘{{unknown}}’) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/td-composer/legacy/Newspaper/index.php’), require_once(‘/plugins/td-standard-pack/Newspaper/loop.php’), td_module_15->render, td_module_single_base->get_content, apply_filters(‘the_content’), WP_Hook->apply_filters, WP_Embed->autoembed, preg_replace_callback, WP_Embed->autoembed_callback, WP_Embed->shortcode, update_post_meta, update_metadata, add_metadata
Suggestions?
[19-May-2024 11:04:37 UTC] WordPress database error Duplicate entry '0' for key 'wp_postmeta.PRIMARY' for query INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES (5411, '_oembed_038bd0fc5d14aa5cc1550aa5c38953bc', '{{unknown}}') made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/td-composer/legacy/Newspaper/index.php'), require_once('/plugins/td-standard-pack/Newspaper/loop.php'), td_module_15->render, td_module_single_base->get_content, apply_filters('the_content'), WP_Hook->apply_filters, WP_Embed->autoembed, preg_replace_callback, WP_Embed->autoembed_callback, WP_Embed->shortcode, update_post_meta, update_metadata, add_metadata
take two.
Hi Steve Johnson, according to that message seems to be a problem with the id, this is not set as auto-increment to can add an unique key for each post in post meta.
Here is a guide that can help you – https://www.newzealandgoonline.co.nz/how-to-fix-wordpress-database-error-duplicate-entry-0-for-key-primary-for-query-insert-into-wp_usermeta/ but before taking any action make sure that you have a full backup for database.
Thank you!
