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?

How-to and Troubleshooting

Last Post by Alvina 3 years ago

3 Posts

2 Users

1 Likes

608 Views

RSS

Posts: 124

mplusplus

Topic starter

Oct 06, 2020 11:39 pm

(@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

sticky topics

2 Replies

Posts: 1870

Alvina

Moderator

Oct 07, 2020 10:04 am

(@alvina)

Member

Joined: 4 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.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

1 Reply

Alvina

Moderator

(@alvina)

Joined: 4 years ago

Member

Posts: 1870

Oct 08, 2020 11:42 am

Reply to

Alvina

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

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Forum Jump:

Previous Topic

Next Topic