diff options
author | Brice Maron <brice@bmaron.net> | 2012-06-24 15:58:51 +0000 |
---|---|---|
committer | Brice Maron <brice@bmaron.net> | 2012-06-24 15:58:51 +0000 |
commit | 6da926f1c395526dddecda660b8b6972e04ba85e (patch) | |
tree | 31e346c43bdad0cac7d06386378433940491fedf /apps/media | |
parent | 5b908209de49dad257e016567821a8a5bd018f94 (diff) | |
download | nextcloud-server-6da926f1c395526dddecda660b8b6972e04ba85e.tar.gz nextcloud-server-6da926f1c395526dddecda660b8b6972e04ba85e.zip |
Resolve scanning issue case comparison of songs
Diffstat (limited to 'apps/media')
-rw-r--r-- | apps/media/lib_collection.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/apps/media/lib_collection.php b/apps/media/lib_collection.php index bf82e65e62b..598c08d32e2 100644 --- a/apps/media/lib_collection.php +++ b/apps/media/lib_collection.php @@ -104,7 +104,7 @@ class OC_MEDIA_COLLECTION{ return self::$albumIdCache[$artistId][$albumId][$name]; }else{ $uid=$_SESSION['user_id']; - $query=OCP\DB::prepare("SELECT song_id FROM *PREFIX*media_songs WHERE song_user=? AND song_name LIKE ? AND song_artist=? AND song_album=?"); + $query=OCP\DB::prepare("SELECT song_id FROM *PREFIX*media_songs WHERE song_user=? AND lower(song_name) LIKE ? AND song_artist=? AND song_album=?"); $songs=$query->execute(array($uid,$name,$artistId,$albumId))->fetchAll(); if(is_array($songs) and isset($songs[0])){ self::$albumIdCache[$artistId][$albumId][$name]=$songs[0]['song_id']; |