david at kineticode
Jun 25, 2010, 9:16 AM
Post #2 of 2
On Jun 25, 2010, at 8:58 AM, Nick Legg wrote:
> Is it possible to simply write some SQL and update the media_uri table in the database without affecting anything negatively? I'm thinking something like this: "UPDATE media_uri SET uri = replace(uri, ' ', '%20');" to fix white spaces. I'll have to perform a similar operation for other characters that should be encoded, too.
> Any other ideas on repairing this issue?
No, that seems like a good one. You might also have to correct it in media_instance.uri and story.primary_uri.