PDA

View Full Version : 6.5.3 Error scanning library



peter69
2007-07-19, 12:52
I too get the same error that is described in this post:
http://forums.slimdevices.com/showthread.php?t=36789

I haven't had any problems scanning my files in the past so I'm pretty sure it has something to do with my upgrade to 6.5.3.

Should I downgrade to 6.5.2 or is a fix in the works?

Thanks in advance!

/Peter

Spies
2007-07-19, 16:17
There is a bug about this at http://bugs.slimdevices.com/show_bug.cgi?id=5166

Do you happen to have more than one ALBUMARTIST tag in any of your files?

peter69
2007-07-20, 01:52
There is a bug about this at http://bugs.slimdevices.com/show_bug.cgi?id=5166


Sorry, I didn't know that.



Do you happen to have more than one ALBUMARTIST tag in any of your files?

Not that I'm aware of.
The log doesn't have any info on which file caused the problem,
just that there was an error inserting into "contributors".

It seems like the error is caused by missing quotes around the contributors name, "Bo Diddley" in this case.

2007-07-20 03:06:26.1761 ERROR: Error executing 'INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, Bo Diddley, Bo Diddley, Bo Diddley)': 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 'Diddley, Bo Diddley, Bo Diddley)' at line 1 at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 782.


Thanks!