AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant
Notifications
Clear all

[Solved] mass editing of forum topics

7 Posts
2 Users
1 Reactions
3,775 Views
Posts: 21
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@vasiliy)
Eminent Member
Joined: 8 years ago
[#6264]

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
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@vasiliy)
Eminent Member
Joined: 8 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: 10716
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 2 months 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
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@vasiliy)
Eminent Member
Joined: 8 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.

111111111111

Robert
Posts: 10716
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 2 months 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
Share: