Title: WP Database Error: duplicate entry
Last modified: September 20, 2025

---

# WP Database Error: duplicate entry

 *  Resolved [Pieter Bos](https://wordpress.org/support/users/senlin/)
 * (@senlin)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/)
 * Hi, doing some debugging work on the site of a client and came across errors 
   in the EmbedPress plugin, filling the `php_errorlog` with thousands upon thousands
   of errors (it’s a high-traffic site), all of the duplicate entry type:
 *     ```wp-block-code
       [20-Sep-2025 16:56:31 UTC] WordPress database error Duplicate entry '0-34b869fa' for key 'wp_embedpress_analytics_browser_info.unique_user_fingerprint' for query INSERT INTO wp_embedpress_analytics_browser_info (user_id, session_id, browser_fingerprint, browser_name, browser_version, operating_system, device_type, screen_resolution, language, timezone, country, city, user_agent, created_at) VALUES (0, 'ep-user-1758386808890-yq2au2em1p', '34b869fa', 'Unknown', 'Unknown', 'macOS', 'mobile', '393x852', 'en-US', 'America/Chicago', 'US', 'Spring', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148', '2025-09-20 12:56:31') made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, EmbedPress\Includes\Classes\Analytics\REST_API->store_browser_info
       ```
   
 * I tried to turn off Analytics, but for some reason that doesn’t hold and upon
   a refresh, the button returns to the on position.
   Can you fix this please asap?
 * Let me know if you need more info.
 * Cheers!

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Support [Ashikur Rahman](https://wordpress.org/support/users/ashikurwp/)
 * (@ashikurwp)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/#post-18650102)
 * Hi [@senlin](https://wordpress.org/support/users/senlin/) , 
   Greetings. Sorry
   for any inconvenience that you faced. We’ve recently made some updates that address
   this problem. Could you please try the updated development version by downloading
   it here: [https://d.pr/f/jw51R1](https://d.pr/f/jw51R1)Kindly check it and let
   me know how it goes—your feedback is valuable in helping us ensure everything
   is working as expected.
 * Thank you!
 *  Thread Starter [Pieter Bos](https://wordpress.org/support/users/senlin/)
 * (@senlin)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/#post-18650110)
 * Hi [@ashikurwp](https://wordpress.org/support/users/ashikurwp/)
 * Thanks, I already had 4.4.1 installed, but downloaded the version you linked 
   to and uploaded that to the site.
 * Analytics button still cannot be turned off.
 * So unfortunately this did not do it for me.
 * Also errors in `php_errorlog` persist and an additional has come up:
 *     ```wp-block-code
       [21-Sep-2025 12:13:11 UTC] WordPress database error Duplicate key name 'idx_referrer_domain' for query ALTER TABLE wp_embedpress_analytics_referrers ADD INDEX idx_referrer_domain (referrer_domain(191)) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, EmbedPress\Includes\Classes\Analytics\Analytics_Manager->ensure_tables_exist, EmbedPress\Includes\Classes\Database\Analytics_Schema::create_tables, EmbedPress\Includes\Classes\Database\Analytics_Schema::run_migrationsNEW ONE: [21-Sep-2025 12:13:11 UTC] WordPress database error Can't DROP 'idx_utm_campaign'; check that column/key exists for query ALTER TABLE wp_embedpress_analytics_referrers DROP INDEX idx_utm_campaign made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, EmbedPress\Includes\Classes\Analytics\Analytics_Manager->ensure_tables_exist, EmbedPress\Includes\Classes\Database\Analytics_Schema::create_tables, EmbedPress\Includes\Classes\Database\Analytics_Schema::run_migrations[21-Sep-2025 12:13:11 UTC] WordPress database error Duplicate key name 'idx_utm_campaign' for query ALTER TABLE wp_embedpress_analytics_referrers ADD INDEX idx_utm_campaign (utm_campaign(191)) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, EmbedPress\Includes\Classes\Analytics\Analytics_Manager->ensure_tables_exist, EmbedPress\Includes\Classes\Database\Analytics_Schema::create_tables, EmbedPress\Includes\Classes\Database\Analytics_Schema::run_migrations
       ```
   
 * I added “**NEW ONE:**” in front of the new error
    -  This reply was modified 8 months, 2 weeks ago by [Pieter Bos](https://wordpress.org/support/users/senlin/).
 *  Plugin Support [Ashikur Rahman](https://wordpress.org/support/users/ashikurwp/)
 * (@ashikurwp)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/#post-18650119)
 * Hi [@senlin](https://wordpress.org/support/users/senlin/),
 * Sorry to hear you’re still experiencing this issue.
 * May I ask if you’re using a caching plugin? If so, could you please try clearing
   the plugin cache as well as your server cache, and then check again?
 * Let us know how it goes—we’re here to help!
   Best regards,
 *  Thread Starter [Pieter Bos](https://wordpress.org/support/users/senlin/)
 * (@senlin)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/#post-18650125)
 * no not using any caching plugin, host’s caching is quite aggressive, but I am
   clearing that between sessions.
 * Also, caching or not, the fact that analytics cannot be turned off has nothing
   to do with caching and everything with a bug in the code.
 * And the database errors are a clear sign something is “not quite right”…
 *  Plugin Support [Zeba Afia Shama](https://wordpress.org/support/users/zebaafiashama/)
 * (@zebaafiashama)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/#post-18650796)
 * Hi [@senlin](https://wordpress.org/support/users/senlin/)
 * Thank you for clarifying the details. We understand your concern regarding the
   analytics setting and the database errors. We will check this issue further from
   our end.
 * Could you please reach out to us [here?](https://wpdeveloper.com/new-ticket) 
   So, we can investigate more closely.
   We appreciate your patience and cooperation
   while we look into this.
 * Best regards,
 *  Thread Starter [Pieter Bos](https://wordpress.org/support/users/senlin/)
 * (@senlin)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/#post-18650977)
 * Done
 *  Plugin Support [Ashikur Rahman](https://wordpress.org/support/users/ashikurwp/)
 * (@ashikurwp)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/#post-18651070)
 * Hi [@senlin](https://wordpress.org/support/users/senlin/) , 
   Thank you for reaching
   out to us. We’re closing this topic for now, but please feel free to reopen it
   anytime if you need further assistance here. Best regards,
 *  [Francesco d’Elia](https://wordpress.org/support/users/newmediologo/)
 * (@newmediologo)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/#post-18651974)
 * We have no time to waste please fix the issue..
 * Thanks..

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘WP Database Error: duplicate entry’ is closed to new replies.

 * ![](https://ps.w.org/embedpress/assets/icon-128x128.gif?rev=3419899)
 * [EmbedPress – PDF Embedder, Embed PDF viewer, YouTube Videos, 3D FlipBook, Social feeds & more](https://wordpress.org/plugins/embedpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/embedpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/embedpress/)
 * [Active Topics](https://wordpress.org/support/plugin/embedpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/embedpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/embedpress/reviews/)

 * 8 replies
 * 5 participants
 * Last reply from: [Francesco d’Elia](https://wordpress.org/support/users/newmediologo/)
 * Last activity: [8 months, 2 weeks ago](https://wordpress.org/support/topic/wp-database-error-duplicate-entry/#post-18651974)
 * Status: resolved