From the list: Other ✔ Match file URLs to new site so links aren't broken Veronica A. added this on Oct 01, 2019 Completed Oct 02, 2019 by Ryan R. Assigned to Ryan R. Notes Run find & replace to remove multisite & site ID Comments & Events Veronica Alvarado, Project Manager Old Site URL: https://www.dosp.org/communications/wp-content/uploads/sites/29/Live-with-Spirit.jpgNew Site URL: https://dosp2.diocesanweb.com/wp-content/uploads/29_Live-with-Spirit.jpgNote: Main site files are now uploads/0_ 🥇 Oct 01, 2019 at 8:26 PM Notified 1 person Ryan Ross, Developer This is done.Naturally with this sort of database sweep, there are chances for human error (mainly misspelling). Additionally, there may be uploads that were not moved and now result in a 404.Basically, check to see if the file exists in uploads first, as that will help determine any course of action.Sidenote - Better Search and Replace struggled for some reason, so I handled these via cPanel PHP myAdmin, ie...UPDATE `wpsp_posts`SET `post_content` = REPLACE(`post_content`, 'www.dosp.org/apa/wp-content/uploads/sites/4/', 'dosp2.diocesanweb.com/wp-content/uploads/4_'),`post_content` = REPLACE(`post_content`, 'www.dosp.org/blackcatholic/wp-content/uploads/sites/5/', 'dosp2.diocesanweb.com/wp-content/uploads/5_'),`post_content` = REPLACE(`post_content`, 'www.dosp.org/boyscouts/wp-content/uploads/sites/6/', 'dosp2.diocesanweb.com/wp-content/uploads/6_') Oct 02, 2019 at 8:31 PM Notified 1 person Ryan Ross completed this to-do. Oct 02, 2019 at 8:31 PM
Veronica Alvarado, Project Manager Old Site URL: https://www.dosp.org/communications/wp-content/uploads/sites/29/Live-with-Spirit.jpgNew Site URL: https://dosp2.diocesanweb.com/wp-content/uploads/29_Live-with-Spirit.jpgNote: Main site files are now uploads/0_ 🥇 Oct 01, 2019 at 8:26 PM Notified 1 person
Ryan Ross, Developer This is done.Naturally with this sort of database sweep, there are chances for human error (mainly misspelling). Additionally, there may be uploads that were not moved and now result in a 404.Basically, check to see if the file exists in uploads first, as that will help determine any course of action.Sidenote - Better Search and Replace struggled for some reason, so I handled these via cPanel PHP myAdmin, ie...UPDATE `wpsp_posts`SET `post_content` = REPLACE(`post_content`, 'www.dosp.org/apa/wp-content/uploads/sites/4/', 'dosp2.diocesanweb.com/wp-content/uploads/4_'),`post_content` = REPLACE(`post_content`, 'www.dosp.org/blackcatholic/wp-content/uploads/sites/5/', 'dosp2.diocesanweb.com/wp-content/uploads/5_'),`post_content` = REPLACE(`post_content`, 'www.dosp.org/boyscouts/wp-content/uploads/sites/6/', 'dosp2.diocesanweb.com/wp-content/uploads/6_') Oct 02, 2019 at 8:31 PM Notified 1 person
https://www.dosp.org/communications/wp-content/uploads/sites/29/Live-with-Spirit.jpg
New Site URL:
https://dosp2.diocesanweb.com/wp-content/uploads/29_Live-with-Spirit.jpg
Naturally with this sort of database sweep, there are chances for human error (mainly misspelling).
Additionally, there may be uploads that were not moved and now result in a 404.
Basically, check to see if the file exists in uploads first, as that will help determine any course of action.
Sidenote - Better Search and Replace struggled for some reason, so I handled these via cPanel PHP myAdmin, ie...
UPDATE `wpsp_posts`
SET `post_content` = REPLACE(`post_content`, 'www.dosp.org/apa/wp-content/uploads/sites/4/', 'dosp2.diocesanweb.com/wp-content/uploads/4_'),
`post_content` = REPLACE(`post_content`, 'www.dosp.org/blackcatholic/wp-content/uploads/sites/5/', 'dosp2.diocesanweb.com/wp-content/uploads/5_'),
`post_content` = REPLACE(`post_content`, 'www.dosp.org/boyscouts/wp-content/uploads/sites/6/', 'dosp2.diocesanweb.com/wp-content/uploads/6_')