BuddyPress.org

Found the issue !!

As per the logs (how to enable logs ? check below ), it states that its unable to DELETE the group entry in database. At cpanel level, the mysql user did not ahve permissions hence the error.

had this error in log file :
[05-Feb-2017 19:57:50 UTC] WordPress database error DELETE command denied to user ‘mysql user’@’999-144-214-244.wkbox.net’ for table ‘wp_options’ for query DELETE FROM wp_options WHERE option_name = ‘_transient__bp_activation_redirect’ made by do_action(‘admin_init’), call_user_func_array, bp_admin_init, do_action(‘bp_admin_init’), call_user_func_array, bp_do_activation_redirect, get_transient, delete_option
[05-Feb-2017 19:57:50 UTC] WordPress database error DELETE command denied to user ‘mysql user ‘@’99.4444.444.sfa.net’ for table ‘wp_options’ for query DELETE FROM wp_options WHERE option_name = ‘_transient_timeout__bp_activation_redirect’ made by do_action(‘admin_init’), call_user_func_array, bp_admin_init, do_action(‘bp_admin_init’), call_user_func_array, bp_do_activation_redirect, get_transient, delete_option

Thanks
Prasad.

how to enable logs in WP :
Check your dashboard

The current error_log value error_log is not supported. Please change it to an absolute path.

To enable error logging, create an empty file named “php-errors.log”. Place it in a directory that is not publicly accessible (preferably outside your web root) and ensure it is writable by the web server. Then add the following code to wp-config.php:

ini_set(‘log_errors’, ‘On’);
ini_set(‘error_log’, ‘/full/path/to/php-errors.log’);
For reference, the full path of the WordPress directory is:
/home/blurover/medinall.blurover.com/

Thanks for the response, djsteveb.

Every thing is using my own dedicated server. Therefore, I have access to all functions.

With buddypress deactivated all works and its the same theme that is working on the old site. Also, I do not think it could be a theme issue since that I can resend the activation email from the backend but it is still not coming. Also, I see not error message in my log unless that I am missing the message, which I am going back to test again.

I suggestion that I have in mind could be a compatible issue between Buddypress 2.7.4
and WordPress 4.7.2 but since buddypress was set-up on the old site when wordpress was version 3 and when through the many upgrades it still works on that old site.

I am just having thoughts since I cannot see the issue and from the searches this issue goes back a long time and there seems to be no one fix.

I have tried with and without Easy WP SMTP.

Thanks

Fred

Example of error logs:
[Sat Feb 04 21:43:29.117033 2017] [:error] [pid 10835] [client 92.19.41.202:36229] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY ID DESC LIMIT 1 /* From [lettermo.com/2017-badge/postal-explorer/] in [‘ at line 1 for query SELECT ID FROM wp_posts WHERE post_status=’draft’ AND post_type=’attachment’ AND post_author = 22943 AND post_parent = ORDER BY ID DESC LIMIT 1 /* From [lettermo.com/2017-badge/postal-explorer/] in [/nas/content/live/maryrobinette/wp-content/plugins/badgeos/includes/submission-actions.php:1783] */ made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/buddypress/bp-themes/bp-default/single.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, call_user_func_array, badgeos_achievement_submissions, badgeos_submission_form, badgeos_get_submission_form, get_attachment_from_draft_submission, referer: http://lettermo.com/quests-and-badges/

hi shane i really appreciate your reply such a relief to hear from someone who knows buddypress cold its a very scary thing messing with the database on a site that is so important

…quick update i actually got the pending friend requests on my own account to display but still is extremely slow ….other than moving the site to a totally new server does deleting is_confirmed field value = 0 seem like a good idea to try in your opinion to speed it up ?

this is not a dedicated server but is supposed to handle spikes its not on a cheap hosting plan its supposed to scale on demand…..really managed wordpress hosting

in general is this friends table something that is going to get out of control if you have 50,000 members?

…i already every couple months trim the activity table … buddypress changed over the years i’m not sure i need to do it anymore honestly but was absolutely necessary like 3-4 years ago do you have people deleting activity table on larger sites still?

thanks for your help on my db situation and how to keep it running

why time activity under the nickname does not respond to the time change in WordPress settings? And in the time of the tape activity responds to changes.

You added recently a new plugin.
Deactivate it. Personal unchanged in activity((, but WordPress has changed in the settings, the time was correct.
You added recently a custom function.
Deactivate it. Nothing change.
You haven’t tested with a twenty theme.
Change on twenty theme. Nothing change.

but under the nickname activity time independent of time, changes in WordPress settings

Did you checked your WordPress time settings ?
yes
if i change on UTC its
Universal time (UTC) is 2017-02-02 10:10:22. Local time is 2017-02-02 10:10:22.
if i change on Moscow its
Universal time (UTC) is 2017-02-02 13:11:50. Local time is 2017-02-02 16:11:50.
if i change on UTC+3 its
Universal time (UTC) is 2017-02-02 12:14:27. Local time is 2017-02-02 15:14:27.

What is your server time ?
10:08:27 02.02.2017
On my computer its (my local timezone 13:09)
Do you use a new plugin ?
yes
Have you changed your theme ?
no
Have you add a custom function somewhere ?
yes
Have you tested by using a twenty theme ?
no

I assume that the problem is hidden in WordPress, but plug-ins that change the time I did not install. Who faced with podobonoy problem?