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.