WP Database Error: duplicate entry

Resolved

(@senlin)

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:

[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
(@ashikurwp)

6 months, 1 week ago

Hi @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

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
(@senlin)

6 months, 1 week ago
Hi @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:
```
[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_migrations
NEW 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 6 months, 1 week ago by Pieter Bos.
Plugin Support Ashikur Rahman
(@ashikurwp)

6 months, 1 week ago

Hi @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
(@senlin)

6 months, 1 week ago

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
(@zebaafiashama)

6 months, 1 week ago

Hi @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? So, we can investigate more closely.
We appreciate your patience and cooperation while we look into this.

Best regards,

Thread Starter Pieter Bos
(@senlin)

6 months, 1 week ago

Done

Plugin Support Ashikur Rahman
(@ashikurwp)

6 months, 1 week ago

Hi @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
(@newmediologo)

6 months ago

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.