Under SQLite a few albums can't be browsed using SqueezePlay after a
successful scan, whereas under MySQL no albums whatsoever can be
browsed using SqueezePlay or iPeng. Both DB backends allow the webUI to
browse albums, add to tracks to playlists and perform all other related
operations correctly. It's just SqueezePlay and iPeng that fail to get
track lists when they need them.
Code:
--------------------
Version: 7.6.0 - r30469 @ Sat Apr 3 01:03:43 PDT 2010
Hostname: charles-laptop
Server IP Address: 192.168.1.32
Server HTTP Port Number: 9000
Operating system: Debian - EN - utf8
Platform Architecture: i686-linux
Perl Version: 5.10.1 - i486-linux-gnu-thread-multi
Database Version: MySQL 5.0.83-0ubuntu3
Total Players Recognized: 1
--------------------
typical error message under MySQL:
Code:
--------------------
[10-04-03 19:12:06.4556] Slim::Schema::Storage::throw_exception (119) Error:
DBI Exception: DBD::mysql::db selectrow_array failed: Duplicate column name
'name' [for Statement "
SELECT COUNT(*) FROM ( SELECT albums.title,
contributors.name, genres.name, tracks.coverid, tracks.id,
tracks.musicmagic_mixable, tracks.secs, tracks.title, tracks.tracknum FROM
tracks JOIN genre_track ON genre_track.track = tracks.id JOIN genres ON
genres.id = genre_track.genre JOIN contributor_track ON contributor_track.track
= tracks.id JOIN contributors ON contributors.id =
contributor_track.contributor JOIN albums ON albums.id = tracks.album WHERE
(tracks.content_type != "cpl" AND tracks.content_type != "src" AND
tracks.content_type != "ssp" AND tracks.content_type != "dir") AND tracks.album
= ? AND contributor_track.role IN (?, ?) GROUP BY tracks.id ORDER BY
tracks.disc, tracks.tracknum, tracks.titlesort COLLATE utf8_general_ci ) AS t1
"]
[10-04-03 19:12:06.4680] Slim::Schema::Storage::throw_exception (119)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 119)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(/usr/share/perl5/Slim/Control/Queries.pm line 6372)
frame 3: Slim::Control::Queries::_getTagDataForTracks
(/usr/share/perl5/Slim/Control/Queries.pm line 4336)
frame 4: Slim::Control::Queries::titlesQuery
(/usr/share/perl5/Slim/Control/Request.pm line 1931)
frame 5: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1931)
frame 6: Slim::Control::Request::execute (/usr/share/perl5/Slim/Web/Cometd.pm
line 809)
frame 7: Slim::Web::Cometd::handleRequest
(/usr/share/perl5/Slim/Web/Cometd.pm line 548)
frame 8: Slim::Web::Cometd::handler (/usr/share/perl5/Slim/Web/Cometd.pm line
108)
frame 9: Slim::Web::Cometd::webHandler (/usr/share/perl5/Slim/Web/HTTP.pm
line 487)
frame 10: Slim::Web::HTTP::processHTTP
(/usr/share/perl5/Slim/Networking/IO/Select.pm line 139)
frame 11: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 123)
frame 12: Slim::Networking::IO::Select::__ANON__
(/usr/share/perl5/Slim/Networking/IO/Select.pm line 183)
frame 13: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 183)
frame 14: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line
684)
frame 15: main::idle (/usr/sbin/squeezeboxserver line 634)
frame 16: main::main (/usr/sbin/squeezeboxserver line 1127)
--------------------
Typical error message under SQLite:
Code:
--------------------
[10-04-03 19:28:42.2414] Slim::Control::Request::execute (1935) Error: While
trying to run function coderef [Slim::Control::Queries::titlesQuery]: [Can't
use an undefined value as an ARRAY reference at
/usr/share/perl5/Slim/Control/Queries.pm line 4443.]
--------------------
I don't know for sure that both these are the same bug.
SqueezePlay reports itself as 7.5.0 r8669M (even though it was freshly
compiled today from the svn 7.6 trunk.)
--
dsdreamer
----------------------
"Dreamer, easy in the chair that really fits you..."
------------------------------------------------------------------------
dsdreamer's Profile: http://forums.slimdevices.com/member.php?userid=12588
View this thread: http://forums.slimdevices.com/showthread.php?t=76785
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
