GNOME Bugzilla – Bug 499505
Problems with spaces and %20 importing files
Last modified: 2007-11-25 11:30:02 UTC
1) Importing files with spaces in the filename. No problem. They are all right. 2) Restarting f-spot. Now F-Spot uses those %20 as spaces (in the sidepane on the left). 3) Now, if I want to import new files of the same folder (/home/paul/Photos/2007/11/25/ for example), f-spot does not recognize that the file stored there is in the database yet and it is imported another time. So I have "/home/paul/Photos/2007/11/25/test with spaces.jpg" and "/home/paul/Photos/2007/11/25/test%20with%20spaces.jpg" in the database deirecting to the same URL.
Just some more information on this bug from the mail list. --- The problem: If I convert some RAW files (with Bibble or any other RAW converter) I save them in the same directory as the RAW files. To get them into F-Spot I reimport all files in this directory. If I have any photo in there with spaces in the filename which is imported in F-Spot yet F-Spot tries to reimport this photo, too. The result are two photos in F-Spot refering to the same file. That's the problem. > And about the %20% things: were did you see that pattern ? in the 'Name' > on the left sidebar ? or elsewhere ? (I agree, the left sidebar is > wrong). Yes, in the left sidebar. But if I reimport the photo, the new one shows it right, without %20. > I suspect an encoding issue, does this command returns something ? > > select l.id, l.uri, r.uri from photos as l, photos as r where l.uri LIKE > r.uri AND r.id != l.id; Yes, it returns 20-30 rows approximately. (I have about 6000 photos in my photos.db.) Does this query returns all the duplicates? Matching the URI but not matching the ID?
*** This bug has been marked as a duplicate of 483779 ***