Notifications
Clear all

wpForo 1.x.x [Solved] How to remove the Sticky status from all topics and convert them to regular topics? SQL query or any other automatic way?

3 Posts
2 Users
1 Reactions
691 Views
Posts: 124
Topic starter
(@mplusplus)
Reputable Member
Joined: 4 years ago

Hi there

How to remove the Sticky status from all topics and convert them to regular topics?
Is there a SQL query or any other automatic way to do this, please? I have a whole lot of sticky topics and doing this one by one will be very time-consuming.

Thanks.

Topic Tags
2 Replies
Alvina
Posts: 1868
Moderator
(@alvina)
Member
Joined: 5 years ago

Hi @mplusplus,

I've just asked our developers if they can provide any  SQL solution for you. Please wait a bit I'll update the topic once I get some news for you.

1 Reply
Alvina
Moderator
(@alvina)
Joined: 5 years ago

Member
Posts: 1868

@mplusplus,

Please follow the steps below:

1. Please execute the following SQL commands in Hosting Service cPanel > phpMyAdmin > Your Website Database > SQL tab:

UPDATE `wp_wpforo_topics` SET `type` = 0

wp_ is just a WordPress database tables default prefix. In your case, the prefix can be different.

3.Navigate to the Dashboard > Forums > Dashboard admin page click on the "Delete all caches" button.
4.Go to the frontend page press CTRL+F(5)twice and check.