[ubuntu-mono] [Bug 83133] f-spot: "Export to Folder" breaks when the folder name contains a single quote (')

[edschofield]

Public bug reported:

Binary package hint: f-spot

F-Spot 0.3.2 gives an error when trying to export photos to a folder
with a single quote like "Gallery - Fred's wedding":

Mono.Data.SqliteClient.SqliteSyntaxException: unrecognized token: "1.JPG"
  at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart,
System.IntPtr& pzTail, System.IntPtr& pStmt) [0x00000]
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior
behavior, Boolean want_results, System.Int32& rows_affected) [0x00000]
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000]
...

Exporting the same photos to a folder with a simpler name works fine.

I reported this upstream earlier this week. Stephane Delcroix has
confirmed this bug and provided a patch: see
http://bugzilla.gnome.org/show_bug.cgi?id=403619. Please apply this to
Feisty! :)

** Affects: f-spot (Ubuntu)
     Importance: Undecided
         Status: Unconfirmed

** Summary changed:

- f-spot: "Export to Folder" breaks when the folder name contains a single quote (')
+ [Feisty] f-spot: "Export to Folder" breaks when the folder name contains a single quote (')

** Description changed:

  Binary package hint: f-spot
  
  F-Spot 0.3.2 gives an error when trying to export photos to a folder
  with a single quote like "Gallery - Fred's wedding":
  
  Mono.Data.SqliteClient.SqliteSyntaxException: unrecognized token: "1.JPG"
    at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart,
  System.IntPtr& pzTail, System.IntPtr& pStmt) [0x00000]
    at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior
  behavior, Boolean want_results, System.Int32& rows_affected) [0x00000]
    at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000]
  ...
  
  Exporting the same photos to a folder with a simpler name works fine.
  
  I reported this upstream earlier this week. Stephane Delcroix has
  confirmed this bug and provided a patch: see
- http://bugzilla.gnome.org/show_bug.cgi?id=403619.
+ http://bugzilla.gnome.org/show_bug.cgi?id=403619. Please apply this to
+ Feisty! :)

-- 
[Feisty] f-spot: "Export to Folder" breaks when the folder name contains a single quote (')
https://launchpad.net/bugs/83133