[slim] Scanner dies with SQL error on 6.5.3 Release
Since upgrading from a recent 6.5.3 nightly to 6.5.3 release (or 6.5.4 nightly) I am having the scanner die with a SQL error: ==> slimserver.log <== frame 13: Slim::Music::Import::runImporter (/usr/local/slimserver/Slim/Music/Import.pm line 265) frame 14: Slim::Music::Import::runScan (/usr/local/slimserver/scanner.pl line 175) frame 15: (eval) (/usr/local/slimserver/scanner.pl line 169) frame 16: main::main (/usr/local/slimserver/scanner.pl line 306) 2007-07-12 23:52:47.9572 ERROR: Scanner: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, Kenneth Gamble/Leon Huff, Kenneth Gamble/Leon Huff, Kenneth Gamble/Leon Huff)': DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Gamble/Leon Huff, Kenneth Gamble/Leon Huff, Kenneth Gamble/Leon at /usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 771. ] 2007-07-12 23:52:47.9593 ERROR: Scanner: Skipping post-process & Not updating lastRescanTime! This is happening on several songs. This sort of thing seems more and more common, perhaps LogiSlim needs a DB of real world tags. People could use a utility to strip out the music data, and submit trees of meta music to create a real world torture test to be run before releases go out. Such a test certainly would have run on the nightly and failed on the release in my case. Also as an aside moderation of the forums seems to have some new policies and people, I certainly don't recall threads ever being locked before recently. It's back to 6.5.2 for me I guess (which was broken in less serious ways)... Thanks, -Chris -- chrisla chrisla's Profile: http://forums.slimdevices.com/member.php?userid=1722 View this thread: http://forums.slimdevices.com/showthread.php?t=36789 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] more wood cases
So with the wood case other posts earlier in the week, I thought I would post some pics of my dedicated touchscreen softsqueeze boxes in Brazilian Mahogany cases. I had been holding off to take better pics, but when does one ever have time for that? Basic rundown: - Custom Mahogany cases done by David Mosby of Freightline Cases (contact info available upon request) David did a GREAT job, was very excited about my project, and in the end I paid him more than I owed him b/c I was so satisfied. - TC-10 Touchpanel computer from earthlcd.com Very happy with this aside from the sound chip quality. It does not have line out, so I am using speaker to line level converters from a car audio store. Even this setup is pretty noisy at low volume. - I have added a soundcard w/ digitial out on one box that is hooked to my good stereo setup. Sounds MUCH better than the stock. At some point I will get that working with an ART DI/O that I bought. - Boots from CF, and runs damnsmall linux. It took a couple of months for me to get it all working. I needed to compile a custom kernel for the touchscreen, and use a Kdive X binary from the driver author. - Boots, runs a modified slimp3slave, starts X, ssh's to my Linux server and runs softsqueeze with X displayback. This setup was required as the Geode CPU could not quite keep up with Softsqueeze and 320Mp3 playback. The combo works great. Slimp3slave was modified to allow uniq MAC addresses, so I can have four of these boxes on my network. - Running a custom woodgrain touchscreen skin that I did, that has been included with later betas of Softsqueeze. Overall it was a fun project, and it is nice to have music all over the house now. Some pics are attached. +---+ |Filename: skin.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=371| +---+ -- chrisla ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
