I was wondering if there were a quicker way.
Unfortunately, no. We plan on switching from "full path" storage to "relative path" storage, but it's still a couple of weeks away.
I hate for you to have to change every one of the references by hand, but unfortunately this isn't a 1 or 2 day fix.
Is it possible to postpone moving the files until after we've fixed this?