Turkish locale problem

[Samed Beyribey]

Hi,
I'm using exaile 0.2.11, and my locale is tr_TR.utf8

I can run exaile without any problem but when i try to play a music file, a get an error dialog complaining about "ARTiST". When i click OK, music interrupts

So i decided to run exaile from console and i see that output:
<<<<<<<< Quote >>>>>>>>
 -----------------------
 play ( /usr/lib/exaile/xl/player.py @ 581):
-----------------------
Traceback (most recent call last):
  File "/usr/lib/exaile/xl/player.py", line 606, in play
    self.play_track(track, from_button=True)
  File "/usr/lib/exaile/xl/player.py", line 554, in play_track
    artist_id = library.get_column_id(self.exaile.db, 'artists', 'name', track.artist)
  File "/usr/lib/exaile/xl/common.py", line 182, in wrapper
    return func(self,*__args,**__kw)
  File "/usr/lib/exaile/xl/library.py", line 463, in get_column_id
    cols = globals()['%s%s' % (prep, table.upper())]
KeyError: 'ARTiSTS'
<<<<<<<< End Of Quote >>>>>>>>

I think this problem comes from Turkish alphabet, because we have i,İ,ı,I
i character uppercase => İ
ı character uppercase => I

So my locale tries to output "ARTİSTS" which is not "ARTISTS"

When i change my locale to en_US.utf8, this problem disappears. I can run exaile without any problems.

I hope this will be fixed
Thanks,

[Johannes Sasongko (sjohannes)]

Yes, it's because of the Turkish "i" problem.

Can you try something? In the file xl/library.py, find this line:

cols = globals()['%s%s' % (prep, table.upper())]

and change "table.upper()" to just "table"

[Samed Beyribey (ras0ir)]

-----------------------
 play ( /usr/lib/exaile/xl/player.py @ 581):
-----------------------
Traceback (most recent call last):
  File "/usr/lib/exaile/xl/player.py", line 606, in play
    self.play_track(track, from_button=True)
  File "/usr/lib/exaile/xl/player.py", line 554, in play_track
    artist_id = library.get_column_id(self.exaile.db, 'artists', 'name', track.artist)
  File "/usr/lib/exaile/xl/common.py", line 182, in wrapper
    return func(self,*__args,**__kw)
  File "/usr/lib/exaile/xl/library.py", line 463, in get_column_id
    cols = globals()['%s%s' % (prep, table)]
KeyError: 'artists'

same error but ARTiSTS changed to artists

[seqizz (gurkanGur) (seqizz-deactivatedaccount)]

FIXED!

i've replaced all "artists" words to "ARTISTS" in this files:
/usr/lib/exaile/xl/covers.py
/usr/lib/exaile/xl/common.py
/usr/lib/exaile/xl/player.py
/usr/lib/exaile/xl/library.py

(One of this files doesn't include this string, i forgot :)

Because of this bug like Johannes Sasongko's says:
Turkish language has 2 capital and 2 not "i"
Like I - ı - i - İ

Hope this helps.. :)

[heartsmagic (heartsmagic)]

IMHO, it is /usr/lib/exaile/xl/db.py

[heartsmagic (heartsmagic)]

Ok, i think it is just 4 files: covers.py db.py library.py player.py
I am attaching a patch for this. I successfuly packaged exaile with this patch for a distro.

[heartsmagic (heartsmagic)]

Sorry fot bothering the list but there is the same problem with PLAYLiSTS issue. When you want to create a new playlist, an error occures with the word PLAYLiSTS. I revised the previous patch, also i changed it a bit for the first problem.

[Adam Olsen (arolsen)]

Cleaning out old bugs.