Notifications
Clear all

wpForo 1.x.x [Solved] Database errors log

11 Posts
2 Users
1 Reactions
3,857 Views
Posts: 1602
Topic starter
(@anonymous20)
Noble Member
Joined: 9 years ago

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

10 Replies
Posts: 1602
Topic starter
(@anonymous20)
Noble Member
Joined: 9 years ago

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.

Posts: 1602
Topic starter
(@anonymous20)
Noble Member
Joined: 9 years ago
Robert
Posts: 10587
Admin
(@robert)
Support Team
Joined: 9 years ago

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:

1 Reply
(@anonymous20)
Joined: 9 years ago

Noble Member
Posts: 1602

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.

Robert
Posts: 10587
Admin
(@robert)
Support Team
Joined: 9 years ago

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.

Page 1 / 2