Comment 5 for bug 469334

Revision history for this message
Mary Strimel (mary-strimel) wrote : Re: [Bug 469334] Re: F-Spot crashes on start-up

Thank you, that is helpful. It turns out that several years ago,
gthumb put a : in one of my file paths without my knowing it. So this
must be the same bug.

On Sat, Jan 2, 2010 at 5:52 PM, C W Whittle <email address hidden> wrote:
> *** This bug is a duplicate of bug 289732 ***
>    https://bugs.launchpad.net/bugs/289732
>
> I can confirm that it's a duplicate of 289732. I followed a work-around
> similar to that described in the upstream report
> (https://bugzilla.gnome.org/show_bug.cgi?id=559093) mentioned in bug
> #289732.
>
> I used the following SQL query to identify the folders on my computer that contained a colon:
>  select distinct base_uri from photos where base_uri like "file:///%:%";
>
> I renamed these folders by hand to change ": " to "- "
>
> I then use the following SQL statements to update the F-Spot database:
>  update photos set base_uri = replace(base_uri, ": ", "- ") where base_uri like "file:///%: %";
>  update photo_versions set base_uri = replace(base_uri, ": ", "- ") where base_uri like "file:///%: %";
>
> It seems that we should avoid importing folders with a : in their name.
>
> I hope that helps.
>
> ** Bug watch added: GNOME Bug Tracker #559093
>   https://bugzilla.gnome.org/show_bug.cgi?id=559093
>
> --
> F-Spot crashes on start-up
> https://bugs.launchpad.net/bugs/469334
> You received this bug notification because you are a direct subscriber
> of the bug.
>