lost playlist on rescan after install of latest version

[wub868]

Hi i've been running squeezcenter for some time, running fairly smoothley. I was looking for an easier way to creat playlists, (see other post) so i decided against my better judgement (if it aint broke, dont fix it!)to install the lastest version of squeezcenter, version 7.5.1. After doing a complete rescan, it did'nt find any of my playlists. All my music and playlist are stored on a W/D 1TB hard drive and on the old version a complete rescan of music liberary would find all the music and my playlists. I've checked the correct paths are listed etc, tried 3 rescans but no joy. I've checked the harddrive and all the playlists are still there, thankfully! Any ideas? If not can i unistall the lastest version of squeezcentre and reinstall the older version? I just want all my playlists back, please!

Elmo

[wrecks69]

Having same problem

I'm having the same problem: I create and save a playlist in the web UI. The playlist works as expected until I re-scan playlists only. Then the playlist disappears from the (now empty) list of playlists. More troubling is that the alarm that was using that playlist is now completely silent (there seems to be a completely different problem with the backup alarm sound).

The playlist file is in the filesystem where Squeezebox server expects it. The server and scanner logs show nothing amiss. I did discover that Microsoft Security Essentials was interfering with MySQL, but I get the same behavior with MSE off.

I'm running 7.5.1 on Windows 7.

[Mnyb]

A long shot there is a bug I though only affected version 7.6 that is that if you have exceptions for m3u or pls files set for your audio files this setting also affect playlist scan even if they should not do that.

[wub868]

Can i get an older version of squeezebox then and reinstall that, as i find it unusable now, as i've spent hundreds of hours on my playlists!

[aubuti]

You can get all released versions of the server software, including very old versions, from http://downloads.slimdevices.com/ .

But there isn't anything generally wrong with playlists on 7.5.1 -- they work fine for most people so it's something with your setup (and wrecks69's and no doubt some others). What version did you upgrade from? If it was pre-7.4.x then it could be a permissions issue, since the username that SBS runs under changed between 7.3.x and 7.4. Or maybe something wrong with how you specified the playlist folder. It's hard to say with such little info.

[logman]

Same issue for different user

I have exactly the same issue. After multiple rescans, the playlists continue to show "Empty." I have double checked the file locations--all is well. I am using version 7.5.1/r30836 with iTunes (for playlists) version 10.1.056. The operating system is XP.

The scanner log is as follows:
Start
[10-12-11 18:32:45.3125] main::main (180) Starting Squeezebox Server scanner (v7.5.1, r30836, Tue Jun 1 06:02:45 PDT 2010) perl 5.010000
[10-12-11 18:32:45.8041] Slim::Music::Import::runImporter (566) Starting Slim::Music::PlaylistFolderScan scan
[10-12-11 18:32:46.8281] Slim::Music::Import::runScanPostProcessing (429) Starting merge of various artists albums
[10-12-11 18:33:00.9377] Slim::Music::Import::endImporter (700) Completed mergeVariousAlbums Scan in 14 seconds.
[10-12-11 18:33:00.9386] Slim::Music::Import::runScanPostProcessing (437) Starting artwork scan
[10-12-11 18:33:00.9880] Slim::Music::Import::endImporter (700) Completed findArtwork Scan in 0 seconds.
[10-12-11 18:33:00.9889] Slim::Music::Import::runScanPostProcessing (461) Starting cleanup of stale track entries
[10-12-11 18:33:34.4219] Slim::Music::Import::endImporter (700) Completed cleanupStaleEntries Scan in 33 seconds.
[10-12-11 18:33:34.4835] Slim::Music::Import::runScanPostProcessing (483) Starting Database optimization.
[10-12-11 18:33:46.0937] Slim::Music::Import::endImporter (700) Completed dbOptimize Scan in 11 seconds.
End

I will also provide in next posting a portion of the most recent server log--which appears to have re-scan issues.

Thanks much,

Logman

[logman]

Same issue for different user

Continuing with the post. Here is the server log, which seems to have a re-scan issue. I have had to use portions of the log, because the forum states I have 7 images (???)in the post (exceeding the permitted 4).
Start
[10-12-11 18:31:19.9845] Slim::Schema::Storage::throw_exception (82) Error: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver','slimserver',...) failed: Can't connect to MySQL server on '127.0.0.1' (10061) at /<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>DBIx/Class/Storage/DBI.pm line 950

[10-12-11 18:31:19.9855] Slim::Control::Request::execute (1945) Error: While trying to run function coderef [Slim::Control::Queries::rescanprogressQuery]: [Carp::Clan::__ANON__(): DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver','slimserver',...) failed: Can't connect to MySQL server on '127.0.0.1' (10061) at /<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>DBIx/Class/Storage/DBI.pm line 950
]
[10-12-11 18:31:19.9859] Slim::Web::JSONRPC::requestMethod (358) Request failed with error: Bad dispatch!
[10-12-11 18:31:21.0001] Slim::Schema::Storage::throw_exception (82) Error: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver','slimserver',...) failed: Can't connect to MySQL server on '127.0.0.1' (10061) at /<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>DBIx/Class/Storage/DBI.pm line 950
[10-12-11 18:31:21.0006] Slim::Schema::Storage::throw_exception (82) Backtrace:
End
I apologize for the length of this posting, but wanted to provide all possible information to gain a fix.
Can anyone assist?
Thanks much,
Logman

[aubuti]

I have exactly the same issue. After multiple rescans, the playlists continue to show "Empty." I have double checked the file locations--all is well. I am using version 7.5.1/r30836 with iTunes (for playlists) version 10.1.056.

So far the OP hasn't indicated using iTunes for playlists. So your problems may or may not be the same issue, because iTunes introduces another variable. I don't use iTunes for playlists, so I can't offer any help on that.

Fyi, the "images" in your log file are the forums software converting ordinary Perl code (such as a : next to a DBI) into annoying emoticons. You can avoid that in the future by putting the log output inside code brackets in your post. Start with the word "code" inside square brackets (no quotes) and end with "/code" inside square brackets (no quotes).

Good luck.

[Mnyb]

I would also check that the playlist directory is actually set in sbs and if not investigate from there ?

This directory has it any foreign characters in the name ?

[logman]

Checked the file designation

I checked to make sure the playlists location is properly designated and then pointed to the correct file again. So SBS is pointed to iTunes playlists--just can not seem to find them in the re-scan process.
I was doing ok until I downloaded the latest iTunes (version 10).
Problem continues.

Thanks for your inputs,

Logman

[burundi]

Same problem here

I'm having this same issue.

I am on 7.5.3 on a Windows 2003 server and the SqueezeBox Server process is running under the administrator user.

I have a standard installation with no additional plugins and no itunes support.

I have approx 11000 audio files and SS scanned these and indexed with a few issues but I've been playing them back fine and had created a few playlists.

I've tried converting existing playlists that worked under Twonky to work with SS by modifying the paths within them and gone so far as to using a bulk renaming utility to strip out all dashs from my music collection as research suggested this could be a problem, however I have still not been able to import any existing playlists by doing a rescan.

Further to this the playlists I have created in the WebUI, which I have saved in the configured playlists path of 'd:\music\playlists' are no longer picked up by SS, the scanner.log indicates it sees them but does not import them into the database.

To try and narrow down the issue I have re-installed SS, wiped the cache, set my music base folder to be just one folder out of the collection, so it is now 'd:\music\abba' instead of 'd:\music', now there are only now 19 tracks in my collection according to SS.

I created a playlist containing all these tracks and saved it as a file as well.

The playlists works fine until I try to do any sort of scan and then it disappears from the db. The .m3u file created by SS is still in the playlists folder and the scanner and server logs suggest that the rescan has found the file ok but nothing has been imported into the db.

Unless there are some deeply hidden settings somewhere I fail to see what's going wrong.

The administrator user has full control over the folders involved and there is no av software installed on the server to interfere.

I've just tried the rescan again to get a clean log file:

[11-03-13 22:32:17.5443] main::main (180) Starting Squeezebox Server scanner (v7.5.3, r31792, Mon Jan 24 07:32:03 PST 2011) perl 5.010000
[11-03-13 22:32:17.5466] Slim::Utils::Misc::addFindBinPaths (149) adding C:\PROGRA~1\SQUEEZ~1\server\Bin\MSWin32-x86-multi-thread
[11-03-13 22:32:17.5490] Slim::Utils::Misc::addFindBinPaths (155) not adding C:\PROGRA~1\SQUEEZ~1\server\Bin\MSWin32 - does not exist
[11-03-13 22:32:17.5501] Slim::Utils::Misc::addFindBinPaths (149) adding C:\PROGRA~1\SQUEEZ~1\server\Bin
[11-03-13 22:32:17.5515] Slim::Utils::Misc::addFindBinPaths (149) adding C:\Perl\bin
[11-03-13 22:32:18.8412] Slim::Music::Import::addImporter (546) Adding Slim::Music::PlaylistFolderScan Scan
[11-03-13 22:32:18.8426] Slim::Music::Import::countImporters (615) Found importer: Slim::Music::PlaylistFolderScan
[11-03-13 22:32:19.2397] Slim::Music::Import::runImporter (566) Starting Slim::Music::PlaylistFolderScan scan
[11-03-13 22:32:19.2409] Slim::Music::PlaylistFolderScan::startScan (82) Starting playlist folder scan
[11-03-13 22:32:19.2417] Slim::Music::PlaylistFolderScan::startScan (85) Clearing internal ssp playlists
[11-03-13 22:32:19.2526] Slim::Utils::Scanner::scanDirectory (289) About to look for files in D:\Music\Playlists
[11-03-13 22:32:19.2566] Slim::Utils::Scanner::scanDirectory (290) For files with extensions in: lnkwplm3u8m3ucuewaxasxplsxspflnk
[11-03-13 22:32:19.2749] Slim::Utils::Scanner::findFilesForRescan (224) Generating file list from disk & database for file:///D:/Music/Playlists...
[11-03-13 22:32:19.2857] Slim::Utils::Scanner::findNewAndChangedFiles (243) Comparing file list between disk & database to generate rescan list...
[11-03-13 22:32:19.2906] Slim::Utils::Scanner::scanDirectory (320) Found 1 files in D:\Music\Playlists
[11-03-13 22:32:19.2943] Slim::Utils::Scanner::scanDirectory (333) Scanning: D:\Music\Playlists\Abba Gold.m3u
[11-03-13 22:32:19.3047] Slim::Music::PlaylistFolderScan::doneScanning (105) Finished background scan of playlist folder.
[11-03-13 22:32:19.3056] Slim::Music::Import::runScanPostProcessing (429) Starting merge of various artists albums
[11-03-13 22:32:19.4562] Slim::Music::Import::endImporter (700) Completed mergeVariousAlbums Scan in 0 seconds.
[11-03-13 22:32:19.4582] Slim::Music::Import::runScanPostProcessing (437) Starting artwork scan
[11-03-13 22:32:19.4905] Slim::Music::Import::endImporter (700) Completed findArtwork Scan in 0 seconds.
[11-03-13 22:32:19.4926] Slim::Music::Import::runScanPostProcessing (461) Starting cleanup of stale track entries
[11-03-13 22:32:19.4935] Slim::Schema::cleanupStaleTrackEntries (1292) Starting db garbage collection..
[11-03-13 22:32:19.5621] Slim::Schema::cleanupStaleTrackEntries (1317) Finished with stale track cleanup.
[11-03-13 22:32:19.5730] Slim::Schema::DBI::removeStaleDBEntries (70) Starting stale cleanup for class Slim::Schema::Contributor / contributorTracks
[11-03-13 22:32:19.5939] Slim::Schema::DBI::removeStaleDBEntries (95) Finished stale cleanup for class Slim::Schema::Contributor / contributorTracks
[11-03-13 22:32:19.5949] Slim::Schema::DBI::removeStaleDBEntries (70) Starting stale cleanup for class Slim::Schema::Album / tracks
[11-03-13 22:32:19.6261] Slim::Schema::DBI::removeStaleDBEntries (95) Finished stale cleanup for class Slim::Schema::Album / tracks
[11-03-13 22:32:19.6273] Slim::Schema::DBI::removeStaleDBEntries (70) Starting stale cleanup for class Slim::Schema::Genre / genreTracks
[11-03-13 22:32:19.6471] Slim::Schema::DBI::removeStaleDBEntries (95) Finished stale cleanup for class Slim::Schema::Genre / genreTracks
[11-03-13 22:32:19.6524] Slim::Music::Import::endImporter (700) Completed cleanupStaleEntries Scan in 0 seconds.
[11-03-13 22:32:19.6599] Slim::Music::Import::runScanPostProcessing (483) Starting Database optimization.
[11-03-13 22:32:19.6608] Slim::Schema::optimizeDB (428) Start schema_optimize
[11-03-13 22:32:22.4193] Slim::Schema::optimizeDB (442) End schema_optimize
[11-03-13 22:32:22.4203] Slim::Music::Import::endImporter (700) Completed dbOptimize Scan in 2 seconds.
[11-03-13 22:32:22.4223] Slim::Music::Import::runScanPostProcessing (491) Finished background scanning.

and this is the server log for the same time period.

[11-03-13 22:32:08.4328] Slim::Web::Settings::Server::Basic::handler (70) Initiating scan of type: rescan playlists
[11-03-13 22:32:08.4371] Slim::Music::Import::countImporters (615) Found importer: Slim::Music::PlaylistFolderScan
[11-03-13 22:32:08.4378] Slim::Music::Import::countImporters (615) Found importer: Slim::Music::MusicFolderScan
[11-03-13 22:32:23.6854] Slim::Schema::wipeCaches (1593) Wiped all in-memory caches.

[burundi]

These are my server details, please can someone else whose playlists are working fine post theirs to compare?

Version: 7.5.3 - r31792 @ Mon Jan 24 07:32:03 PST 2011
Hostname: server
Server IP Address: 192.168.123.100
Server HTTP Port Number: 9000
Operating system: Windows Server 2003 - EN - cp1252
Platform Architecture: 586
Perl Version: 5.10.0 - MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt
Total Players Recognized: 1

[prob]

me too

Looks like similar problem here except I have Itunes support enabled, and Itunes playlist importer is failing. Rather than starting a new thread....

Help.

Running latest build (v7.5.4, r32171) on on Windows xp with latest Itunes 10.2.1.1

Slim::Music::Import::runImporter (566) Starting Slim::Plugin::iTunes::Importer scan
[11-04-03 19:01:02.7612] Slim::Music::Import::countImporters (615) Found importer: Slim::Music::PlaylistFolderScan
[11-04-03 19:01:02.7615] Slim::Music::Import::countImporters (615) Found importer: Slim::Plugin::iTunes::Importer::Artwork::Win32
[11-04-03 19:01:02.7619] Slim::Music::Import::countImporters (615) Found importer: Slim::Music::MusicFolderScan
[11-04-03 19:01:02.7622] Slim::Music::Import::countImporters (615) Found importer: Slim::Plugin::iTunes::Importer
[11-04-03 19:04:43.2271] Slim::Utils::SoundCheck::commentTagTodB (51) Warning: Argument "1.#J" isn't numeric in addition (+) at /<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Utils/SoundCheck.pm line 51.