Aug 30, 2018 6:39 am
We have transferred the site from http://site.com/members to http://members.site.com. Is there a way to change all the old urls in the forum in bulk or in one go? We have 25k posts it would be hassle to edit manually. You help and suggestion is much appreciated.
1 Reply
Aug 30, 2018 8:53 am
Use phpMyAdmin Database Manager of your hosting service cPanel. backup the wp_wpforo_posts table, then execute this SQL:
UPDATE `wp_wpforo_posts` SET `body` = REPLACE( `body`, 'http://site.com/members', 'http://members.site.com' );
Change the sites and the red marked 'wp_' table prefix if your database table prefix is not 'wp_'. After executing this SQL, please navigate to Dashboard > Forums > Dashboard and click on [Delete all caches] button.
