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.
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
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.
Thank you very much. Topics have become open. But now everyone has become fixed. Is there the same request to unpin the topics.
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.
