Bug 10242 - SC 7.2.1 sometimes adds malformed first record to albums query
: SC 7.2.1 sometimes adds malformed first record to albums query
Status: NEW
Product: Logitech Media Server
Classification: Unclassified
Component: CLI
: 7.2.1
: PC Other
: -- normal (vote)
: Future
Assigned To: Joerg Schwieder
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2008-12-06 15:46 UTC by Joerg Schwieder
Modified: 2009-01-08 09:51 UTC (History)
3 users (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Joerg Schwieder 2008-12-06 15:46:10 UTC
I've got some trouble with malformed album query results in 7.2.1
The problem is, that a list of all albums contains the following first record:

Code:

[08-12-06 16:36:15.8434] Slim::Web::JSONRPC::writeResponse (224) JSON response: {
  id => 1,
  method => "slim.request",
  params => ["", ["albums", 0, 100, "sort:album", "tags:ljywag"]],
  result => {
        albums_loop => [
              { album => undef, id => 337 },
              {...

After that, the albums table looks as expected.
Comment 1 Blackketter Dean 2008-12-06 16:24:11 UTC
Opinions?
Comment 2 Michael Herger 2008-12-06 16:43:10 UTC
Do you see the same issue in 7.3 too?
Comment 3 Joerg Schwieder 2008-12-06 16:53:01 UTC
I didn't see the issue myself, but I have several reports of it from users.
At least two reproducibly have this issue, one sent me a log file today so that's what I've got.
AFAIK, all reports I've had so far are from 7.2.1
I never saw this but then I don't use 7.2.1
I would just want to make sure that this is not in 7.3 since it can have some nasty side effects.
Comment 4 Joerg Schwieder 2008-12-07 06:39:04 UTC
This
http://forums.slimdevices.com/showpost.php?p=367373&postcount=339
looks a lot like 7.3 also has the problem.
Comment 5 James Richardson 2008-12-08 09:38:20 UTC
Andy thinks this may be due to an album that has been changed to null in the database.  It would cause the app to crash when scanning the database.

Joerg: Can you repo this if you edit the database to change the title of an album to null?

Comment 6 Joerg Schwieder 2008-12-08 10:26:35 UTC
Can you tell me how to do this?
Mac preferred, but I don't think I've got a standalone MySQL on there. I could also reach my Linux servers which do have MySQL but there I also use the standard SC builds.
Comment 7 James Richardson 2009-01-08 09:51:47 UTC
Moving to future for now, as the plugin is not tied to a specific SC release version.  if you feel differently, please comment