--- squeezeboxserver-7.6.1-33110/Slim/Utils/SQLiteHelper.pm 2011-08-15 15:57:58.000000000 +0200 +++ SqueezeboxServer/Slim/Utils/SQLiteHelper.pm 2011-08-19 21:52:40.213206876 +0200 @@ -134,7 +134,12 @@ # Default temp_store is to create disk files to save memory # Highmem we'll let it use memory push @{$sql}, 'PRAGMA temp_store = MEMORY'; + } else { + # Temporary workaround for bug #17471 (temp_store_directory pragma is deprecated!) + push @{$sql}, 'PRAGMA temp_store = FILE'; + push @{$sql}, 'PRAGMA temp_store_directory = "'.$prefs->get('librarycachedir').'"'; } + # We create this even if main::STATISTICS is not false so that the SQL always works # Track Persistent data is in another file