Notifications
Clear all

Limited Support

Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.

We appreciate your patience and understanding while our team is away. Thank you for being part of the wpForo community!

Merry Christmas and Happy Holidays! 🎄

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
1,242 Views
Posts: 127
Topic starter
(@mplusplus)
Reputable Member
Joined: 6 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: 1860
Moderator
(@alvina)
Member
Joined: 6 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: 6 years ago

Member
Posts: 1860

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