Limited Support
Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.
We appreciate your patience and understanding while our team is away. Thank you for being part of the wpForo community!
Merry Christmas and Happy Holidays! 🎄
Checking today i found some db errors in errors.log.
[31-Jul-2018 14:27:02 UTC] WordPress database error Duplicate entry '43-topic-3-' for key 'fld_group_unq' for query INSERT INTO `wp_wpforo_subscribes` (`itemid`, `type`, `confirmkey`, `userid`, `active`, `user_name`, `user_email`) VALUES (43, 'topic', '064e6f402d56f294ff2a2951671520c3', 3, 1, '', '') made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo_actions, wpForoTopic->add, do_action('wpforo_after_add_topic'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo_topic_auto_subscribe, wpForoSubscribe->add
[31-Jul-2018 14:29:34 UTC] WordPress database error Duplicate entry '44-topic-3-' for key 'fld_group_unq' for query INSERT INTO `wp_wpforo_subscribes` (`itemid`, `type`, `confirmkey`, `userid`, `active`, `user_name`, `user_email`) VALUES (44, 'topic', '9b2627fa40ed0a46609062e26ae6b9a8', 3, 1, '', '') made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo_actions, wpForoTopic->add, do_action('wpforo_after_add_topic'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo_topic_auto_subscribe, wpForoSubscribe->add
Any ideas what is wrong ?
Thanks
It seems that this error is not new to me:
https://wpforo.com/community/how-to-and-troubleshooting-2/db-error-in-debug-log/#post-8920
It has been there for a year and happens from time to time.
Could those two be related ?
https://wpforo.com/community/how-to-and-troubleshooting-2/topic-delete-error/
You have some old duplicated data in database, you should find and remove those and make sure the wp_wpforo_subscriptions table unique indexes are correct:
I don't have any wp_wpforo_subscriptions table, all i see is wp_wpforo_subscribes.
If this is what you mean, then here it comes. Seems right, some things are different as Cardinality (no idea what that is).
So nothing to do with that table structure.
I will try to find those dups as you say. Not sure how, but i will try.
Sorry, i meant wp_wpforo_subscribes table. And as far as i see the keys are wrong. And you still have some duplicated content with itemid, type, userid, user_email '43' , 'topic' , '3' , ''. Please remove those. also remove the fld_group_unq index and create it again with itemid, type, userid, user_email fields.
