Email status settings don’t save

Any update on this please? I’m wondering if this is because I’m on WordPress 5.6 but can’t verify because I’d already updated before installing the plugin. I’d really love to get this working and would happily pay for this plugin if it meant continued development.

Hello – The plugin continues to be maintained, but I’m not always able to provide one-on-one support.

Unsaved settings could have a number of sources. Things to try:

– Check to see whether the database tables have been properly created. There should be two: wp_bpges_queued_items and wp_bpges_subscriptions. The latter is responsible for saving subscription settings. If it hasn’t been created, try using the wp bpges install-database utility.

– If the database table does exist, check to see whether there’s an entry corresponding to your group and user, and see whether the setting is correct. This would help to distinguish between a problem *saving* the setting and a problem *displaying* the setting.

– There could be a conflict with the way that your theme works and the way the plugin saves settings. What theme are you using?

Thank you for your help ??

I looked and yes, both those tables are in the database but when I drilled down into the latter, there was only one entry which corresponded to the one group where the settings are saving.

I copied that entry and added the group id for the other groups that weren’t saving and now it works however, it looks like this is only working for me. (I’m assuming “user_id” 1 is me because I was the first user on the site.)

I tried accessing as one of the members and those settings still aren’t saving. Does this mean my only option is to manually add entries for each member for each group in order for their settings to save? (Sorry if this is a dumb question. I’ve never played with the database this specifically before.)

I’m using the BuddyBoss theme.

Thanks for the details. This helps to narrow down the issue. The database tables exist, and it sounds like the system is able to read the values from the database. The problem is that the save routine is not working.

Can you say more about how exactly you are saving your settings? Are you using the AJAX-powered tool for changing your subscription level? Or are you submitting a form somewhere? Screenshots and/or URL formats would be helpful.

If it’s the AJAX interface, it may also be helpful if you opened your JS console (usually F12 to open developer tools in your browser) to see if there are any obvious errors during the save process.

My hunch is that BuddyBoss is doing something different with the way pages are loaded, which is preventing BPGES from properly saving its settings. Because BuddyBoss is a commercial product, I am unable to do deep debugging into it – you’d have to ask their team for help – but perhaps we can narrow down the possibilities a bit.

The database tables exist but it seems like they’re not being written to (if that’s the correct terminology??) when a new user is added or a new group created.

To test this theory, I went ahead and manually added the rows for each user and each group and then tested logging in as one of them and I was able to save the settings.

But, I then created a new user using a different email address with that new user auto-added to the groups and when I try and save settings when logged in as that new user, it doesn’t work. But, when I went back to the database I can see why … no new rows have been created for this new user account so it’s like there’s nothing for the plugin to “read” when it’s told to save settings.

“Can you say more about how exactly you are saving your settings? Are you using the AJAX-powered tool for changing your subscription level? Or are you submitting a form somewhere?”

I’ve tried saving the settings from the main “groups” page and also from the individual groups page. I’m afraid I don’t know what the AJAX tool is so can’t tell you if I’m using that.

Screengrabs of those two pages: https://drive.google.com/file/d/1OFuwMSGDLEyq3KVRqpAUF680wQoTxiw0/view?usp=sharing
https://drive.google.com/file/d/14C-VegJ7rc_OCS_PVHD66DGl56E8xQa9/view?usp=sharing

I’ll send in a support message to BuddyBoss and also my hosts (EasyWP) to see if either have come across this before (although my instinct is they’ll probably try and blame each other! ?? ) because I can’t believe I’m the only person to have run into this. It’s not like I have anything particularly custom on there and the membership is still tiny right now.

And thank you for your help. I have at least found a manual work around for now. Not a long term solution (manually adding those rows to the DB) but at least something that means it works in the meantime ??

You say something about a user being “auto-added”. Can you say more about this? BP doesn’t support “auto-adding” to groups out of the box, and whatever technique you’re using may not be triggering the appropriate parts of BPGES.

Regarding the settings UI, sorry to be pedantic, but could you provide more information about how you’re saving your settings? Your screenshots show ‘All Mail’ with a blue ‘Change’ button. Are you clicking that? If so, what do you see next? Could you run through the process of changing (attempting to change) the subscription level while keeping your browser console open, so that we can look at the AJAX request that ought to take place? Either it’s not happening at all because of some broken selectors or other broken JS in BuddyBoss (my guess) or the AJAX request is reaching the server but something on the server is preventing it from working properly.

Ah, I wondered about that for the briefest of moments yesterday. I’m using a plugin “BP Auto Join Group” made by BuddyBoss to auto-join folks to certain groups when they register.

That said, in case that plugin was what was causing the issue, I ran a test. Deactivated the plugin and created a new user on the site, logged in as that user and still the issue persisted. (I checked again on the database and no row was created for that new user.)

To show you how I’m saving those settings I recorded you a quick Loom: https://www.loom.com/share/8f969532691c425da0c2441c23b143df

In the meantime, support from both BuddyBoss and WPEasy have replied and they’re looking into it from their side. No news as yet.

Thanks for the video, and thanks for opening the developer tools. Could you please do the same thing, but this time do the following in the developer tools:

– First, click the ‘Console’ tab at the bottom of the page (instead of “What’s New”)
– Then, click the Network tab near the top, and find and click the ‘XHR’ filter.

Then, record yourself attempting to change the setting.

(For the record, there is no Save button by design. The change should be saved as soon as you click the new setting, with the saving taking place over AJAX.)

Ah, my apologies (and thank you for your patience!)

New video with the settings as you asked above: https://www.loom.com/share/9676f64f71644786baa9d3e726610a73

I’ve also shown you in this video what I’m seeing in the database in case that’s of any help.

And in the meantime, I’ve had a reply from my hosts, most of which went right over my head but I’ll copy and paste their reply. The action they’re asking me to take next in the database, I don’t know how to do so I’ve taken them up on their offer and asked them to do it for me.

Here’s what they said:

We have examined the logs related to the plugins and have found the following errors:
[04-Feb-2021 03:47:50] WARNING: [pool default-one] child 18326 said into stderr: “NOTICE: PHP message: WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_bpges_subscriptions (id, user_id, group_id, type) VALUES (0, 30, 9, ‘dig’) made by edit_user, wp_insert_user, do_action(‘user_register’), WP_Hook->do_action, WP_Hook->apply_filters, BP_Auto_Group_Join_Base->auto_group_join_new_user, groups_join_group, BP_Groups_Member->save, do_action_ref_array(‘groups_member_after_save’), WP_Hook->do_action, WP_Hook->apply_filters, ass_set_default_subscription, ass_group_subscription, BPGES_Database_Object->save”
[04-Feb-2021 03:47:50] WARNING: [pool default-one] child 18326 said into stderr: “NOTICE: PHP message: WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_bpges_subscriptions (id, user_id, group_id, type) VALUES (0, 30, 4, ‘supersub’) made by edit_user, wp_insert_user, do_action(‘user_register’), WP_Hook->do_action, WP_Hook->apply_filters, BP_Auto_Group_Join_Base->auto_group_join_new_user, groups_join_group, BP_Groups_Member->save, do_action_ref_array(‘groups_member_after_save’), WP_Hook->do_action, WP_Hook->apply_filters, ass_set_default_subscription, ass_group_subscription, BPGES_Database_Object->save”

It appears that the issue is caused by the fact that the “ID” column does not autoincrement and the plugin fails to save the data in the database due to duplicate entries existing.

To resolve the issue, we suggest clearing the wp_bpges_subscriptions table and configuring the ID column to autoincrement. If you wish, we can make those adjustments for you.

That said, I’m not sure if they’re right because the entries in the table right now are ones that I added manually by copying from the one line that was already there. (I reminded them of that in my reply to them.)

Thanks for posting this info, and sorry for the delay. Your host’s diagnosis is almost certainly correct, and you should take them up on their offer to fix the table schema so that the ‘id’ column is autoincrement.

It could be that your manual entries into the table have caused the autoincrementer to fail for some reason, but that’s something that only your host will be able to determine.

I wonder whether this is the root issue, or if it is something that came up only after your manual entries. Once they’ve fixed the database table schema, do another round of testing and let us know what happens.

Unfortunately, the fix with the database didn’t help. I did take them up on their offer but it made no difference. I cleared cache etc. etc. but nope, nothing. And then they declared themselves out.

Sorry, that was about 3 weeks ago, I forgot to come back here and update you.

In the meantime, the team at BuddyBoss continued to work on it until it was decided that this is only an issue with my site and they escalated it to their developers.

It’s in a queue (undoubtedly behind the work they’re doing on the new BuddyBoss app) and so whilst my ticket is still open, I’m not holding my breath.

For now I’ll simply have to manually add the relevant details to the table when new people signup. It’s a bit of a pain but it’s a paid community so definitely worth doing since it makes it so much easier for members to keep on top of all that’s going on.

Quick update: I had a reply from BuddyBoss and it’s not good news, unfortunately. They too are giving up. Will copy and paste what they said …

“Our developer team investigated issue with the “Email subscriptions for BuddyPress Groups” plugin conflict and summarized that Email subscriptions for BuddyPress Groups plugin integration is developed and maintained by Deryk Wenaus, Boone Gorges, r-a-y.

It is the responsibility of this developer to keep the integration updated to ensure it continues to work as intended and address major security concerns.

As this integration is not customized for BuddyBoss, there is no guarantee it will continue to work with the latest versions of BuddyBoss products. For support with this integration, please contact the developer.”

It’s daft because BuddyBoss doesn’t include email notifications as standard so they recommend your plugin to make it happen.

I still really like BuddyBoss, just wish the notifications options were more robust because not all members check in every day and they’d appreciate email notifications but it is what it is ??

Thanks for following up, and sorry for the bad experience with BuddyBoss integration. Unfortunately, I don’t have the resources to ensure integration with a paid, non-free platform like BuddyBoss.

I understand ?? It still makes no sense because they’re saying my site is the only one to have this option but it is what it is. I suggested they might consider making the email notification functionality baked into their platform therefore but I doubt that that will happen since no-one else is having a problem.

At least I have the manual workaround and that’s only thanks to you so, thank you! ??