Notifications
Clear all

wpForo 1.x.x [Solved] mass editing of forum topics

7 Posts
2 Users
1 Reactions
2,236 Views
Posts: 21
Topic starter
(@vasiliy)
Eminent Member
Joined: 6 years ago

Hello! My forum was converted (migrated) from bitrix forum to wpforo forum. After migration, all topics are closed. Is there a possibility of mass opening of themes, for example, using sql query or something else. And if there is such an sql query, could you give it. The forum functionality does not allow mass editing of topics, such as opening or moving, which would be convenient. Thanks.

6 Replies
Posts: 21
Topic starter
(@vasiliy)
Eminent Member
Joined: 6 years ago

also, the problem is that all the topics after the migration were not only closed, but fixed. A forum displays the latest topics at the end of the list. I will be grateful if you help to solve the problem

Robert
Posts: 10591
Admin
(@robert)
Support Team
Joined: 9 years ago

Please backup the _wpforo_topics and _wpforo_posts tables and execute these two SQLs. Make sure the wp_ prefix matchs to your database table prefix.:

UPDATE `wp_wpforo_topics` SET closed = 0;
UPDATE `wp_wpforo_posts` SET is_answer = 0;

Then navigate to Dashboard > Forums > Dashboard admin page and click on the [Delete all caches] button.

Posts: 21
Topic starter
(@vasiliy)
Eminent Member
Joined: 6 years ago

Thank you very much. Topics have become open. But now everyone has become fixed. Is there the same request to unpin the topics.

Robert
Posts: 10591
Admin
(@robert)
Support Team
Joined: 9 years ago

I don't think all issues of your migration can be fixed with SQLs. I see the migration was done without understanding wpForo topic and post table column means. I'm afraid all your topics and posts are also private and unapproved. So I provide these SQL commands to set all topics and posts not-sticky, public and approved. Please backup topic and post tables and use these SQLs:

UPDATE `wp_wpforo_posts` SET private = 0, status = 0;
UPDATE `wp_wpforo_topics` SET private = 0, status = 0, type = 0, has_attach = 0;

Then navigate to Dashboard > Forums > Dashboard admin page and click on the [Delete all caches] button.

Page 1 / 2