My observation is that the ids indicate the sequence of insertion in the database, which should reflect the order that the files were returned by the readdir_r() in scanner.c
My wild-ass guess is that the readdir and/or the OS is returning the files in a “random” order, perhaps creation date/last update date. What filesystem are you using? When you say “did a reinstall on the server”, do you mean firefly, or “the works” (debian+firefly)? What filesystem are the files on?
And another question:
sqlite> select id, fname, title, artist from songs where id < 17;
1|11 – Toast and Bananas.mp3|Toast and Bananas|11 – Blink182 – Cheshire Cat
2|14 – Ben Wah Balls.mp3|Ben Wah Balls|14 – Blink182 – Cheshire Cat
Looking at the select and the values returned, something looks odd – are these really your artist names?
Can you try
sqlite> select id, path, album, track from songs where id < 17;I’d like to see the values of the track field. Even if FF was returning everything in a wildly random order, the Soundbridge orders songs within an album correctly if you are browsing an album with correct ‘track’ tags.
Cheers,
Michael