BuddyPress.org

Thanks,

It seems I was able to get some help here too:

https://wordpress.org/support/topic/hello-guys-how-to-exclude-a-single-page-from-redirect/#post-8800781

The think is that I want the activity page to show be visible menu for logged out users as well.

But the activity page is only selectable for logged in users as you can see here: https://snag.gy/Am1gph.jpg

Thanks for the tip!

WORDPRESS 4.7.2
BUDDYPRESS 2.7.4

i am not using multisite, the other instance of wordpress is working independently on a different location of the same server, completely isolated from one another.
Wordpress v4.7.2

Thanks for the responses.

I do not need any Easy WP SMTP plugin running on any WordPress site to send mail. I am only adding it because I want email sent from a specific site to use my preferred return email. Also, not all of my domains are setup to sign outgoing emails so with Easy SMTP I can determine from which domain emails will be sent from.

I will close this subject for now while I investigate more.

Thanks, everyone for valuable feedback.

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