#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
Main Support Forums
How-to and Troubles...
How to remove the S...
 
Share:
Share
Tweet
Share
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?

    Last Post
RSS

mplusplus
Posts: 124
 mplusplus
Topic starter
October 6, 2020 11:39 pm
(@mplusplus)
Estimable Member
Joined: 2 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
Alvina
Posts: 1873
Alvina - Facebook Alvina - Twitter
 Alvina
Moderator
October 7, 2020 10:04 am
(@alvina)
Member
Joined: 3 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
 Alvina
Moderator
(@alvina)
Joined: 3 years ago

Member
Posts: 1873
Alvina - Facebook Alvina - Twitter
October 8, 2020 11:42 am
Reply toAlvinaAlvina

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

mplusplus liked
  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • Pin a thread
    1 year ago
  • Sticky topic styling
    2 years ago
Topic Tags:  sticky topics (5),

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages wpforo-advanced-attachments-128x128 wpforo-embeds-128x128 wpForo User Custom Fields addon wpForo – Blog Cross Posting addon wpForo Ads Manager wpForo – WooCommerce Memberships Integration wpForo Emoticons wpForo – Tenor GIFs Integration
View all Addons »

Recent Topics

  • How to make new user to get approve manually before creating post and profile.

    By Adhyansh21, 1 day ago

  • Posts deleted in database still show up on front-end

    By nylex, 1 day ago

  • Not all links are automatically added with the "nofollow" attribute

    By st7878, 1 day ago

  • Editors assign users to groups

    By mike_netinfo, 2 days ago

  • Set password link opens forum login page instead of set password page

    By JanJan, 2 days ago

  • User banned for using icons?

    By JanJan, 2 days ago

Topic Tags

  • css52
  • translation50
  • plugin conflict48
  • seo47
  • new features45
  • buddypress43
  • avatar41
  • moderation40
  • ultimate member40
  • login40
  • forum40
  • registration37
  • threaded layout35
  • cache34
  • spam33
  • editor33
  • menu33
  • shortcode32
  • forum accesses30
  • widget29
View all tags (2192)

Recent Posts

  • RE: User banned for using icons?

    If you have security plugins that can ban users, try de...

    By Chris, 7 hours ago

  • RE: recover deleted forum categories

    @robert @chris could that upgrade message at the top of...

    By dimalifragis, 7 hours ago

  • RE: recover deleted forum categories

    Hi @asmadi1, Contact your hosting to get a backup.

    By Chris, 10 hours ago

  • RE: Posts deleted in database still show up on front-end

    @nylex, Copy the post content or part of it, the go-t...

    By Chris, 12 hours ago

  • RE: Problem with Block themes

    Works very well with those kind of themes. Here is MY...

    By dimalifragis, 12 hours ago

  • RE:

    By Anonymous, 53 years ago

  • RE: Not all links are automatically added with the "nofollow" attribute

    I have no idea, i guess not.

    By dimalifragis, 24 hours ago

Share:
Share
Tweet
Share
  Forum Statistics
21 Forums
9,935 Topics
50.3 K Posts
12 Online
48.2 K Members

Latest Post: User banned for using icons? Our newest member: Find Out About Job Openings Fi... Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2022 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation