We get that you do not offer an option for admins to subscribe a member. So we will edit the field in the table to subscribe on the members behalf. What is the table and related field to do that? Thanks.
This issue we found is that it is not enough to subscribe to a forum you must subscribe to each topic/thread. So for example we have a forum on future campouts (subscribed) then under that forum we have each individual topic (a single campout for the month of X) one must also subscribe to that topic. So when we have a campout each month (x12) just for future campouts the member must subscribe (x12) to get the notifications from each monthly campout.
Hi,
Thank you for explaining your use case. Just to clarify how wpForo subscriptions work:
A forum subscription notifies the user when new topics are created in that forum. It does not automatically subscribe the user to replies within those topics.
A topic subscription is separate and is used to receive notifications when new replies are posted to that specific topic.
Therefore, in your example, if you have 12 monthly campout topics and want a member to receive notifications about replies to all 12 topics, the member would need to be subscribed to each topic individually.
wpForo has a built-in Subscription Manager tool that makes subscription easy. It can be found in My Profile > Subscriptions page:
Documentation for the wpForo Forum / Topic Subsciption: https://wpforo.com/docs/wpforo-v3/topics-posts/forum-topic-subsciption/?utm_source=chatgpt.com
Thanks Sofy for the info however our members (campers) are elderly and I have hit a stone wall with them walking each one through the process. Thus, it would be a big help for me to just directly manage the table (database) in the phpMyAdmin. Could you please provide the database info. Thanks
** RESOLVED **
📋 Community Guide: How to Bulk-Subscribe All Members to All Topics/Forums in wpForo Natively via phpMyAdminThe Problem: By default, wpForo's built-in subscriptions operate on a multi-tier system. If a user subscribes to a parent Forum, they only get an alert when a brand-new topic is posted. They do not automatically get email updates for replies inside those topics unless they go in and manually subscribe to every single thread. For elderly users or less tech-savvy communities, walking members through this setup can be impossible.
The Solution: You can bypass this restriction completely by interacting directly with your WordPress database using phpMyAdmin. By running a few clever INSERT queries with CROSS JOIN and safety filters, you can globally link every registered member to every parent forum and internal topic simultaneously—without creating duplicates or disrupting existing subscriptions.
⚠️ Step 0: Create a Safety Backup First: Before touching any live database, always export a safety backup of your subscription table:
In phpMyAdmin, click on your wp_wpforo_subscribes table. Click the Export tab at the top menu. Keep the export method as Quick and format as SQL, then click Go/Export to download the backup file.🚀 Step 1: The "One-Pass" Universal Sync ScriptClick the SQL tab at the top of your phpMyAdmin screen while inside your database. Paste the following two query blocks together into the text window and hit Go. This script maps every single user account to every single topic and forum category in your database. It automatically generates the random confirmation hash keys that wpForo requires, sets the light switch to Active (1), maps their login names and emails so they never miss an alert, and uses a safety filter (WHERE NOT EXISTS) to completely skip any data that is already matched up.
-- PASS A: Link all members to all internal topics (Forces reply email notifications)
INSERT INTO wp_wpforo_subscribes (userid, itemid, type, active, confirmkey, user_name, user_email)
SELECT u.ID, t.topicid, 'topic', 1, MD5(CONCAT(u.ID, '-', t.topicid, '-', RAND())), u.user_login, u.user_email
FROM wp_users u
CROSS JOIN wp_wpforo_topics t
WHERE NOT EXISTS (
SELECT 1 FROM wp_wpforo_subscribes s
WHERE s.userid = u.ID
AND s.itemid = t.topicid
AND s.type = 'topic'
);
-- PASS B: Link all members to all parent forums (Forces new topic creation email alerts)
INSERT INTO wp_wpforo_subscribes (userid, itemid, type, active, confirmkey, user_name, user_email)
SELECT u.ID, f.forumid, 'forum', 1, MD5(CONCAT(u.ID, '-', f.forumid, '-', RAND())), u.user_login, u.user_email
FROM wp_users u
CROSS JOIN wp_wpforo_forums f
WHERE NOT EXISTS (
SELECT 1 FROM wp_wpforo_subscribes s
WHERE s.userid = u.ID
AND s.itemid = f.forumid
AND s.type = 'forum'
);
🧼 Step 2: Clean Up Legacy Blanks (Optional but Recommended): If users have previously managed to manually subscribe to things on the front end of your website, wpForo natively leaves their user_name and user_email database text columns entirely blank to save physical table room. To clean up your table look and prevent potential server-side mailer hitches, run this final query to copy across real usernames and emails into any blank database fields:
UPDATE wp_wpforo_subscribes s
JOIN wp_users u ON s.userid = u.ID
SET s.user_name = u.user_login, s.user_email = u.user_email
WHERE s.user_email IS NULL OR s.user_email = '';
🔄 Future Maintenance: Because the queries use a strict safety check, this entire guide turns into a reusable Maintenance Routine. Whenever you launch a new forum category, create a fresh monthly topic thread, or register a new wave of community members, you can simply run the script in Step 1 again. It will automatically pinpoint the newest changes, fill in the blanks instantly, and leave all your historical data perfectly untouched.
