| # |
Post Title |
Result Info |
Date |
User |
Forum |
|
RE: Members List - Export to csv?
|
5 Relevance |
6 months ago |
ffooccuuss |
How-to and Troubleshooting |
| |
Here is what I envision. A developer, or one of the people here who are very familiar with the database structure here, would compose an SQL query that would do the following:
Join the appropriate tables that would contain all the fields in the members list.
Select all the users
Display the fields that are in the members list, the sort doesn't matter, I'll do that in the csv or a spreadsheet.
Execute that query and let me export that list to a csv.
As a bonus, select all users more than 2 years since last login (or never) AND who have zero posts.
For those users add them to the usergroup "Flagged".
Execute that query and let me export that list to a csv.
Then I can modify that query to delete all those users after I review in a spreadsheet.
I would test this query in my mirror website before doing this in my main production website.
For someone familiar with the database tables, and with SQL, this shouldn't be that difficult or even time-consuming. I understand SQL and phpmyadmin I just don't have a mind to write code.
There is some implied context and knowledge, for example, there is no 'users' table with the 'wpforo' table prefix, so I assume it uses the Wordpress users tables (users and meta). But how is the wpforo ID related? IDK. How do you display the "Display Name", "Login", "Email"? And then display the wpforo info (I think) such as "Group", "Status", "Last Login", and "Forum Posts"? You have to 'join' the appropriate tables and I don't know all the relationships and contents (fields within the tables).
This is the secret sauce that I need someone to figure out and build the SQL query. It should be relatively easy for someone familiar but impossible for a mere mortal like me.
With tons of respect,
Jerry in Houston, Texas |
|
Members List - Export to csv?
|
5 Relevance |
6 months ago |
ffooccuuss |
How-to and Troubleshooting |
| |
I don't see any option to export the members list. Can someone build an SQL query I can run in phpmyadmin to export the entire members list to a csv file?
My goal is to review that list and modify the query to change the usergroup to "flagged" for any member who has not logged in within 2 years and has never posted. Once I have those in that usergroup, and do a final review, I would like to delete them all.
Is this a reasonable approach to cleaning out old members? |
|
Auto close topics after specified time period
|
5 Relevance |
7 months ago |
Wendell |
How-to and Troubleshooting |
| |
I could not find a way to automatically close topics after a certain time period, so I'm suggesting the idea here.
One way to help initiate discussions in a community forum is by encouraging new topics to be created by the users. New topics get more attention, especially if you are sharing new topics in various social media channels. In my experience running a forum since 2010, if a user adds a post to an old topic from years ago, it doesn't get the attention that a brand new topic on the same subject would generate.
My suggestion would be to have settings for allowing topics to close after a specified time period. Even better, it would be great if that time period could be based upon the date of the last reply in the topic, rather than the original topic date. Perhaps there would be a secondary setting that would allow the admin to set the time period from the original topic date or the latest reply date.
For example: let's say a topic is started today, 2025-08-01 and is followed by several replies over the course of a week or so. The last reply is posted on 2025-08-09. A couple of example scenarios could be:
Set the auto-close date to 1 year after the original topic date. This would mean that the topic closes on 2026-08-01.
Set the auto-close date to 1 year after the last reply date. This would mean that the topic closes on 2026-08-09.
Using example scenario #2 above would allow the topic to prove its staleness for one year after the last reply, thus making it feasible to close it permanently.
Thank you for your consideration! 😊 |
|
Header Block vs Standard Header on Kadence Theme when using wpForo
|
5 Relevance |
10 months ago |
Jupiter |
How-to and Troubleshooting |
| |
I have been using the standard Kadence Theme header on my site for a few years now. The wpForo links within the menu work great. But now I am wanting to use the Kadence Block Header that is build a bit different. I have it built on my staging site, but I am having problems with wpForo menu shortcodes for menu links.
For instance on my current site using the old school theme menu, the login link (and other wpForo dynamic links) will properly populate the /%wpforo-login%/ dynamic link. So that link will look like this on the live site.
But on my staging site in my attempt to use the Kadence Header Block instead of the standard menu, the /%wpforo-login%/ dynamic link does not populate and the link ends up looking like this.
This obviously bring a user to a page that gives a 404 Bad Request error.
So I thought I would start here and see if there is anything I can do on the wpForo side. Has anyone troubleshooted a Block Header vs a standard WP header? The Kadence Block Header allows much more customization vs the standard one which is why I would love to use it.
Thoughts?
Main site link:
Stanging site link:
More info on the Kadence Header Block |
|
Is it possible to have 2 seperate forums embeded in completely different style pages?
|
5 Relevance |
10 months ago |
Jodie-1SmartChic |
How-to and Troubleshooting |
| |
I am trying to create 2 separate forums for two completely separate membership levels. I need to embed each forum inside the page for each level as each one has it's own style and navigation menu.
I have created the 2 forums and 2 different usergroups. I can get each forum to display for each level. BUT when you click any, and I do mean anything, from profile links to posts, you leave the member level styled page layout and go to the plain default forum style page (which in this case is pretty blank with minimal navigation).
I tried using boards instead of forums but when you click on anything that way you go to a totally blank screen.
Is what I am trying to do not possible with WPforo? If it is walk me through it like I am 5 years old. I have been fighting with this for a week.
Do you need more info? Just ask. I am begging here. Please help me or tell me it can't be done. |
|
My forum duplicates responses, doesn't send notifications, and has some issues.Any suggestions?
|
5 Relevance |
11 months ago |
Jaroslav-Lachky |
How-to and Troubleshooting |
| |
Hello. I have a question, can anyone advise me what the problem could be. Something has changed on my forum, which I have been using for years, in the last 2 months. My opinion is that it must be something related to the update. I have the current version of Wpforo, and also WordPress (I think the WP Embeds addon is out of date, my license has expired, but that probably won't be the problem).
The thing is that in the last 2 months, when creating a topic or adding a reply, it often happens that the post is doubled and the reply and topic are created twice. Also, after adding a reply, the forum takes a very long time to load, and I usually have to refresh the page to get it to load at all.
At the same time, email notifications after adding replies to me, the administrator, and also to members, because some of them wrote to me.
Thanks in advance for any tips or ideas. |
|
Users cannot attach PDFs
|
5 Relevance |
12 months ago |
kthoven |
How-to and Troubleshooting |
| |
Hi WPForo,
Users are unable to attach PDFs in WPForo on my site even though they are part of the Registered usergroup, which, through Standard access, has the ability to upload files checked. I have searched through all of WPForo's settings, accesses, and usergroups without seeing anything about allowing PDF uploads. I ran into this problem a couple of years ago and had it solved through WPForo's Accesses and Usergroups pages, but those seem to have changed and now there is nowhere to see which file types are permitted for the usergroups. I have already tried checking the global setting on WP with the User Role Editor plugin, but there was no section for WPForo specifically.
Can you please direct me on how to allow users to upload PDFs in WPForo specifically? The documentation on User Role Editor is not helpful in this regard as I need to allow for WPForo in particular. When I corrected this in the past, I did NOT have to change any global settings, only WPForo ones. Thanks! |
|
Insert picture feature
|
5 Relevance |
1 year ago |
Plantje |
How-to and Troubleshooting |
| |
Currently I am running a website that is only hosting a Simple Machines Forum. I want to migrate this to a Wordpress site with a forum attached to it.
One of the main downsides of the SMF (and a highly requested feature to add!) is the lack of user friendliness in adding pictures to a post! The users have to add a picture as attachment and then other users can click on it to open it.
In the best case a user knows how to upload a picture to some image website, get the URL from that and add the URL to the post. That way embedding the picture in the post.
It would be really nice to have forum in which I can directly upload pictures, so they get inserted in the forum post. Or even better: drag and drop a picture from another app (in Android/iOS) or from Windows Explorer (in Windows) directly to the post.
Yesterday, I did a search here on the forum and found posts of about round 2016. I cannot imagine this has not been added in almost 10 years of requesting it.
What are my options here? |
|
RE: Is my structure correct for Google.
|
5 Relevance |
1 year ago |
Blade |
How-to and Troubleshooting |
| |
@sofy @owork138 I have gone over the link. The only option difference is i have disabled members profile. I have also resubmitted the site map. Can google read the threaded forums? Its been over 2 years now so not a new forum. I am checking with SEO spider and it gives a high warning for missing return links.
Attachment : Missing-Return-Links.jpg |
|
Following up on "Reply by email" topic
|
5 Relevance |
1 year ago |
Freeman |
How-to and Troubleshooting |
| |
The following topic was closed 3 years ago but there is still very much a need for it:
At the time @robert mentioned such an email system within Wordpress was impossible but a lot has changed since then (although I think it could've been done back then as well) especially with Fluent SMTP and other mailing server plugins.
@vinnyusestrict you mentioned you were working on a solution. I take it you shelved that idea? |
|
RE: No auto update on newly added forums or topics or posts. Admin must manually click on update. How to solve this problem?
|
5 Relevance |
1 year ago |
Tutrix |
How-to and Troubleshooting |
| |
Hi @spacetalk
What topic are you mentioning?
And give us a link to your forum |
|
No auto update on newly added forums or topics or posts. Admin must manually click on update. How to solve this problem?
|
5 Relevance |
1 year ago |
spacetalk |
How-to and Troubleshooting |
| |
Newly added forums or topics or posts will not been seen until admin pushes the updates on "Overview" page in backend. That sucks. How to solve this fundamental issue with this plugin? You can't just hire someone to push the update manually and constantly. That would be way too crazy. I saw this issue posted in the FAQ 2 years ago. How come this basic thing is still lingering? Anyone have a quick-fix? |
|
Update on Unsubscribe link redirect
|
5 Relevance |
1 year ago |
Freeman |
General Discussions |
| |
Found this post from 7 years ago:
And was wondering if this had been updated (or if we can update with a code snippet)?
When I unsubscribe from an email link in this forum I still get redirected to the home page instead of the subscription settings. |
|
Is my structure correct for Google.
|
5 Relevance |
1 year ago |
Blade |
How-to and Troubleshooting |
| |
Hi.
I have been using wpforo for about 1 or 2 years but when i go a site search only a few pages are getting indexed. Is my structure correct, layout? |
