[borgs]

Hello all,

I have just started using SqueezeCenter (version 7.2 official release) on my new QNAP 509 Pro.

But I see major problem with the sort order under "Album" and "Genres".

It is totaly mixed with no order at all, if I choose the letter "G" under ALbums I get the following list:
- Gorillaz
- La Revance del Tango
- The Message
- Fuzzy
- American Idiot
- Dookie
- Bee Thousands

Same under Genres, I choose the letter "M":
- Motown
- Hardcore Punk
- Chillout
- Grunge
- Blue Grass

Have anyone seen this bug before??

Artist are correct listed and works as it should.

Have been running SqueezeCenter on a ReadyNAS NV+ and also on my PC before and have not seen this issue then with the exact same music library.


It works just fine on the ReadyNAS NV+. Have the exact same data on both of my NAS devices. If I connect to the ReadyNAS everything looks ok but if I connect to the QNAP the sorting under "Album" and "Genres" are totaly wrong.

Have alos tried later nightly builds of 7.2 and also 7.3 nightly build but nothing helps.

[borgs]

Just found this in the F.A.Q on SSODS/SSOTS webpage:


"Apparently, there is also a MySQL sort bug with certain versions of MySQL. It leads to wrong (random?) sort order of the Browse Genre list. Synology promised to fix it in an upcoming firmware release. It looks like the MySQL server that comes with SSODS is not affected. So you can fix it using this instead of the built-in server. However, please note that this may or may not work and may or may not have other side-effects. Officially, SSODS uses the built-in server. So, if it works, you are lucky, if not, your problem."


This sound like the cause of the problem I see. But how can I fix it?????????

[borgs]

Ok, I think I can say that it is definatly a BUG in the MySQL Server that is included in the QNAP firmware.

If I am not remembering wrong I saw te following in the SequeezeCenter scan logpage:
MySQL-version: 5.0.51 (could be mistaken on the last number (51)

What I did now was to follow instructions on SSODS/SSOTS webpage to use the MySQL version that was included in SSODS/SSOTS instead of using the one that is in the System (QNAP Firmware).

And now it says:
MySQL-version: 5.0.45

What I did was the following in a telnet session to the QNAP 509:
cd /volume1/SSODS/bin
mv mysqld _mysqld
ln -s /volume1/SSODS/libexec/mysqld .
/volume1/SSODS/bin/ssctrl restart

And after doing the above the sorting problem is gone, without doing anything more. did not have to rescan the music library it started to work at once.


Have reported this on the QNAP forum, lets hopw that QNAP fixes this issue!

[Aylwin]

Thanks very much for sharing the solution! I'm a Squeezebox user so this is good for me to know. I'm just waiting for my 509 to be delivered.

[Aylwin]

I got my TS-509 yesterday and the first thing I did was install SSOTS. I followed your instructions and everything works fine. Thanks!