I got problems with my Squeezebox Touch a while back.
I currently run Squeezebox Server version 7.6.1 / r33110
on an iMac under Snow Leopard (10.6.8).
Since the last update on my Squeezebox Touch (7.6.1 / r9486), it has
been
unable to display ANY of the music in my Library, it
just displays "Empty" on Artists, Albums, etc. etc.
I also lost any of the radio stations, but these came back after
adding some new ones and "fiddling about a bit" (power cycling, etc.)
My page on www.mysqueezebox.com says "Status: Not connected".
The Squeezebox Server seems normal - it displays a believable number of
tracks,
albums, etc.
When inspecting the server logs, I found this:
[11-09-21 20:17:34.7293] Slim::Control::Request::execute (1883) Error:
While trying to run function coderef
[Slim::Control::Queries::albumsQuery]:
[Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectrow_array
failed: near ",": syntax error
[for Statement "SELECT COUNT(*) FROM ( SELECT albums.discc AS
'albums.discc', contributors.name AS
'contributors.name', albums.disc AS 'albums.disc', albums.titlesort AS
'albums.titlesort',
albums.titlesearch AS 'albums.titlesearch', albums.contributor AS
'albums.contributor',
albums.id AS 'albums.id', albums.title AS 'albums.title',
albums.artwork AS 'albums.artwork', albums.year AS 'albums.year'
FROM albums JOIN contributors ON contributors.id = albums.contributor
GROUP BY albums.id ORDER BY albums.titlesort COLLATE
, albums.disc ) AS t1"] at
/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm
line 123
]
[11-09-21 20:17:34.7297] Slim::Menu::BrowseLibrary::_generic (808) Bad
dispatch!
Is this just a stupid bug caused by a typo in some SQL???
I CAN browse the Music folder, but not any of the categories.
I tried to do a clean install of the Squeezebox Server (7.6.1),
but it made no difference.
When I try to use the remote control in the control panel, the
page shows "Empty" for albums, artists, etc.
No change there.
Similar error in the server log:
[11-09-21 21:21:41.4105] Slim::Control::Request::execute (1883) Error:
While trying to run function coderef
[Slim::Control::Queries::artistsQuery]: [Carp::Clan::__ANON__(): DBI
Exception: DBD::SQLite::db selectrow_array failed: near ")":
syntax error [for Statement "SELECT COUNT(*) FROM ( SELECT
contributors.id, contributors.name, contributors.namesort,
contributors.musicmagic_mixable FROM contributors JOIN
contributor_album ON contributor_album.contributor = contributors.id
JOIN
albums ON contributor_album.album = albums.id WHERE
contributor_album.role IN (1,5) AND (albums.compilation IS NULL OR
albums.compilation = 0)
GROUP BY contributors.id ORDER BY contributors.namesort COLLATE ) AS
t1
"] at
/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm
line 123
]
[11-09-21 21:21:41.4109] Slim::Menu::BrowseLibrary::_generic (808) Bad
dispatch!
Yep - EVERY single time I try to select any category like albums or
artists,
the log generates the same entry about a syntax error.
The player remains "Not connected" on MySqueezebox.com.
Anyone else experienced this?
So - How do I fix this - any ideas?
--
LemonSqueezer
------------------------------------------------------------------------
LemonSqueezer's Profile: http://forums.slimdevices.com/member.php?userid=49939
View this thread: http://forums.slimdevices.com/showthread.php?t=90503
_______________________________________________
Touch mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/touch
