Bugzilla – Bug 9504
Scanning broken with SqueezeCenter Version: 7.2.1 - 23177 and recent versions of MySQL
Last modified: 2008-09-16 14:17:09 UTC
Please see http://forums.slimdevices.com/showthread.php?t=52569 Verified on two different systems running Fedora 9, one running MySQL-server-enterprise-gpl-5.0.62-0 and the other using MySQL Version: 5.0.67-community. Scanning dies (even when starting from an empty schema with no tables defined) before a single track record gets committed to the db. It would be nice to be able to use these versions of MySQL as they have fixed a group by query bug which resulted in out of order genre, album, etc. display in SC.
OK, with my testing, it looks like the last 7.2 nightly that could successfully scan with these versions of MySQL was the 8/31 one: squeezecenter-7.2-0.1.22983.noarch.rpm. I'll try to narrow this down to a specific svn.
Ok, it was svn 22991 that broke scanning with these versions of MySQL. I check with every svn from 22984 through 22991. All the other versions scan just fine. Quoting from the 22991 checkin: "Update Class::C3 to latest, include Class::C3::XS for 5.8 speedups" I think there is some utility in tracking down and fixing C3 that breaks scanning with these versions of MySQL. Fedora 10 is coming out next month and it will include MySQL 5.0.67. I imagine other distros will include the up-to-date community release of MySQL as well. As it stands, SqueezeCenter will be broken on those platforms.
*** This bug has been marked as a duplicate of bug 9434 ***