AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Solved] What is the name of the table that controls the subscribe ON option?

6 Posts
2 Users
0 Reactions
549 Views
Posts: 30
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@support)
Eminent Member
Joined: 2 years ago
[#73163]

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. 


5 Replies
Posts: 30
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@support)
Eminent Member
Joined: 2 years ago

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. 

 


Reply
Sofy
Posts: 5873
 Sofy
Admin
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@sofy)
Support Team
Joined: 9 years ago

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


Reply
Posts: 30
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@support)
Eminent Member
Joined: 2 years ago

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


Reply
Posts: 30
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@support)
Eminent Member
Joined: 2 years ago

** 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.


Reply
Page 1 / 2
Share: