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] How to remove the Sticky status from all topics and convert them to regular topics? SQL query or any other automatic way?

Summarize Topic

How-to and Troubleshooting - wpForo 2.0

Last Post by Alvina 6 years ago

3 Posts

2 Users

1 Reactions

1,334 Views

RSS

Posts: 127

mplusplus

Topic starter

Translate ▼

Oct 07, 2020 3:39 am

(@mplusplus)

Reputable Member

Joined: 6 years ago

[#14817]

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: 1857

Alvina

Moderator

Translate ▼

Oct 07, 2020 2:04 pm

(@alvina)

Member

Joined: 7 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: 7 years ago

Member

Posts: 1857

Oct 08, 2020 3:42 pm

Reply to

Alvina

Translate ▼

@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