I'm running SqueezeCenter Version: 7.1 - 21630 @ Thu Jul 10 08:30:22 PDT
2008 - Red Hat - EN - utf8 on a Fedora 9 box.
At some point in the past month, the web UI stopped displaying genres
sorted according to the 'namesort' column. I'm seeing this in the
SBC's display too.
Here are some of my the genres in the order displayed in the web UI and
the SBC:
Code:
--------------------
A_Medieval
B_Renaissance
C_Early_Baroque
D_Engligh_Italian_Baroque
F_French_Baroque
H_Classical
G_German_Baroque
E_Spanish_Latin_American_Baroque
I_Romantic
..etc.
--------------------
As you can see the results are not correctly sorted.
This is what I get from a "select * from genres;" query:
Code:
--------------------
id name namesort namesearch customsearch
musicmagic_mixable
1 A_Medieval A MEDIEVAL A MEDIEVAL
2 B_Renaissance B RENAISSANCE B RENAISSANCE
3 C_Early_Baroque C EARLY BAROQUE C EARLY BAROQUE
4 No Genre NO GENRE NO GENRE
5 D_English_Italian_Baroque D ENGLISH ITALIAN BAROQUE D
ENGLISH ITALIAN BAROQUE
6 F_French_Baroque F FRENCH BAROQUE F FRENCH BAROQUE
7 H_Classical H CLASSICAL H CLASSICAL
8 G_German_Baroque G GERMAN BAROQUE G GERMAN BAROQUE
9 E_Spanish_Latin_American_Baroque E SPANISH LATIN AMERICAN
BAROQUE E SPANISH LATIN AMERICAN BAROQUE
10 I_Romantic I ROMANTIC I ROMANTIC
11 R_Modern_Latin-American R MODERN LATIN AMERICAN R MODERN LATIN AMERICAN
12 N_Modern_French N MODERN FRENCH N MODERN FRENCH
13 J_Post-Romantic J POST ROMANTIC J POST ROMANTIC
14 P_Modern_Scandinavian P MODERN SCANDINAVIAN P MODERN SCANDINAVIAN
15 O_Modern_Russian O MODERN RUSSIAN O MODERN RUSSIAN
16 K_Post-Romantic-Nationalist K POST ROMANTIC NATIONALIST K POST
ROMANTIC NATIONALIST
17 S_Modern_American-English S MODERN AMERICAN ENGLISH S
MODERN AMERICAN ENGLISH
18 M_Modern_German M MODERN GERMAN M MODERN GERMAN
19 L_Modern_Central_European L MODERN CENTRAL EUROPEAN L
MODERN CENTRAL EUROPEAN
20 T_Post Modern Contemporary T POST MODERN CONTEMPORARY T POST
MODERN CONTEMPORARY
21 Q_Modern_Italian-Spanish Q MODERN ITALIAN SPANISH Q
MODERN ITALIAN SPANISH
22 U_Post Modern Aleatoric U POST MODERN ALEATORIC U POST MODERN ALEATORIC
23 V_Post Modern Minimalist V POST MODERN MINIMALIST V POST
MODERN MINIMALIST
24 W_World_Classical W WORLD CLASSICAL W WORLD CLASSICAL
25 X_Jazz and Blues X JAZZ AND BLUES X JAZZ AND BLUES
26 W_Jazz W JAZZ W JAZZ
27 Y_French Pop & Jazz Y FRENCH POP JAZZ Y FRENCH POP JAZZ
28 Y_Funk Y FUNK Y FUNK
29 Y_Pop Y POP Y POP
30 Y_Rockabilly Y ROCKABILLY Y ROCKABILLY
31 Y_World_Pop Y WORLD POP Y WORLD POP
32 Yy_Techno YY TECHNO YY TECHNO
33 Z_Folk Z FOLK Z FOLK
34 Zzz_AudioBook ZZZ AUDIOBOOK ZZZ AUDIOBOOK
35 Zzz_Environmental ZZZ ENVIRONMENTAL ZZZ ENVIRONMENTAL
36 Zzz_Meditation ZZZ MEDITATION ZZZ MEDITATION
--------------------
And here is "select * from genres order by namesort;" :
Code:
--------------------
id name namesort namesearch customsearch
musicmagic_mixable
1 A_Medieval A MEDIEVAL A MEDIEVAL
2 B_Renaissance B RENAISSANCE B RENAISSANCE
3 C_Early_Baroque C EARLY BAROQUE C EARLY BAROQUE
5 D_English_Italian_Baroque D ENGLISH ITALIAN BAROQUE D
ENGLISH ITALIAN BAROQUE
9 E_Spanish_Latin_American_Baroque E SPANISH LATIN AMERICAN
BAROQUE E SPANISH LATIN AMERICAN BAROQUE
6 F_French_Baroque F FRENCH BAROQUE F FRENCH BAROQUE
8 G_German_Baroque G GERMAN BAROQUE G GERMAN BAROQUE
7 H_Classical H CLASSICAL H CLASSICAL
10 I_Romantic I ROMANTIC I ROMANTIC
13 J_Post-Romantic J POST ROMANTIC J POST ROMANTIC
16 K_Post-Romantic-Nationalist K POST ROMANTIC NATIONALIST K POST
ROMANTIC NATIONALIST
19 L_Modern_Central_European L MODERN CENTRAL EUROPEAN L
MODERN CENTRAL EUROPEAN
18 M_Modern_German M MODERN GERMAN M MODERN GERMAN
12 N_Modern_French N MODERN FRENCH N MODERN FRENCH
4 No Genre NO GENRE NO GENRE
15 O_Modern_Russian O MODERN RUSSIAN O MODERN RUSSIAN
14 P_Modern_Scandinavian P MODERN SCANDINAVIAN P MODERN SCANDINAVIAN
21 Q_Modern_Italian-Spanish Q MODERN ITALIAN SPANISH Q
MODERN ITALIAN SPANISH
11 R_Modern_Latin-American R MODERN LATIN AMERICAN R MODERN LATIN AMERICAN
17 S_Modern_American-English S MODERN AMERICAN ENGLISH S
MODERN AMERICAN ENGLISH
20 T_Post Modern Contemporary T POST MODERN CONTEMPORARY T POST
MODERN CONTEMPORARY
22 U_Post Modern Aleatoric U POST MODERN ALEATORIC U POST MODERN ALEATORIC
23 V_Post Modern Minimalist V POST MODERN MINIMALIST V POST
MODERN MINIMALIST
26 W_Jazz W JAZZ W JAZZ
24 W_World_Classical W WORLD CLASSICAL W WORLD CLASSICAL
25 X_Jazz and Blues X JAZZ AND BLUES X JAZZ AND BLUES
27 Y_French Pop & Jazz Y FRENCH POP JAZZ Y FRENCH POP JAZZ
28 Y_Funk Y FUNK Y FUNK
29 Y_Pop Y POP Y POP
30 Y_Rockabilly Y ROCKABILLY Y ROCKABILLY
31 Y_World_Pop Y WORLD POP Y WORLD POP
32 Yy_Techno YY TECHNO YY TECHNO
33 Z_Folk Z FOLK Z FOLK
34 Zzz_AudioBook ZZZ AUDIOBOOK ZZZ AUDIOBOOK
35 Zzz_Environmental ZZZ ENVIRONMENTAL ZZZ ENVIRONMENTAL
36 Zzz_Meditation ZZZ MEDITATION ZZZ MEDITATION
--------------------
It looks as though the UIs are pulling the genres in there raw,
unsorted order.
Is this by design? Does some new aspect of the UI depend on this? Or
is genre sorting broken?
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=49737
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta
