It turns out this is a MySQL bug.  One of the classes used by
squeezecentre includes a redundant 'group by' in some SQL queries and
MySQL then gets the order of the result set wrong.

The MySQL bug is http://bugs.mysql.com/bug.php?id=32202

Unfortunately the latest MySQL build in debian (5.0.51a) has the bug. 
One possible solution is to upgrade the mysql packages to the ones from
experimental - 5.1.23rc-1.

There is more info in the bug report
http://bugs.slimdevices.com/show_bug.cgi?id=6748


-- 
Fozzy
------------------------------------------------------------------------
Fozzy's Profile: http://forums.slimdevices.com/member.php?userid=8592
View this thread: http://forums.slimdevices.com/showthread.php?t=46537

_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta

Reply via email to