GNOME Bugzilla – Bug 624531
Banshee media player can not work normally in Netherlands (NL) language in MeeGo
Last modified: 2010-07-18 03:36:30 UTC
BUG DETAILED DESCRIPTIONS =========================================================== Banshee media player can not work normally in Nederland (NL) language, when install meego image choose default language is Nederland. If default language is Nederland, after launch Banshee, when click lift list item or after import data will auto close or crash. EXACT STEPS LEADING TO PROBLEM: (Explain in detail what you do (e.g. tap on OK) and what you see (e.g. message Connection Failed appears)) =========================================================== 1. Dash Nederlands (NL) image from server and go through OOBE. 2. Go to Task item panel \ Media to launch Banshee media player. 3. Click any item on the left list panel or import data of Banshee. 4. Will auto close or crash. P.S. Nederland Videos is call the Video's, may be the Video" ' "s caused the exception.
*** Bug 624583 has been marked as a duplicate of this bug. ***
Max found the following SQL exception in log: [2 Debug 10:33:37.337] Exception executing command: BEGIN; DELETE FROM CorePlaylistEntries WHERE TrackID IN (SELECT TrackID FROM CoreTracks WHERE PrimarySourceID = 2 AND Uri LIKE 'file:///home/linux/Video's/%' AND LastSyncedStamp IS NOT NULL AND LastSyncedStamp < 1279294417); DELETE FROM CoreSmartPlaylistEntries WHERE TrackID IN (SELECT TrackID FROM CoreTracks WHERE PrimarySourceID = 2 AND Uri LIKE 'file:///home/linux/Video's/%' AND LastSyncedStamp IS NOT NULL AND LastSyncedStamp < 1279294417); The Nl use "Video's" is video folder name it need add escape char. The problem there need a escape char in Video's like Video\'s, when source code new a SaftUri, need take care this: // Delete tracks that are under the BaseDirectory and that weren't rescanned just now string condition = String.Format ( "WHERE PrimarySourceID = ? AND Uri LIKE '{0}%' AND LastSyncedStamp IS NOT NULL AND LastSyncedStamp < ?", new SafeUri (psource.BaseDirectoryWithSeparator).AbsoluteUri );
Created attachment 166100 [details] [review] Untested patch using SQL parameters This is a completely untested patch. Gabriel, it seems you were using proper SQL parameters for some parts of the condition, so I'm not sure why you didn't do this for the Uri column. Would you please review and test this patch?
I pushed a slightly different version (adding StringUtil.EscapeLike for URIs that might contain % or _), thanks Aaron. Also pushed to stable-1.6.
muchas gracias, señor