collection update problem (utf8)

[Aleksandar Simic]

Out of the blue, by collection stopped to update itself properly. When i start Exaile from terminal, i get the following error:

Created db for thread Thread-1
{'Thread-1': <sqlite3.Connection object at 0x85754d0>}
Using multimedia keys from: mmkeys
loading tracks...
Starting scan timer at 25.0
-----------------------
 select ( /usr/lib/exaile/xl/db.py @ 178):
-----------------------
Traceback (most recent call last):
  File "/usr/lib/exaile/xl/db.py", line 191, in select
    row = cur.fetchone()
/usr/lib/exaile/xl/xlmisc.py:703: GtkWarning: gtk_text_buffer_emit_insert: assertion `g_utf8_validate (text, len, NULL)' failed
  self.buf.insert(iter, text)
OperationalError: Could not decode to UTF-8 column 'name' with text '/home/hide/muzika/maud/Isolee - We Are Monster [Tech House] [Minimal] [Electro]/Isolee - We Are Monster - 04 - M�dchen Mit Hase.mp3'

Closed db for thread Thread-1
done loading tracks...
loading songs
Traceback (most recent call last):
  File "/usr/lib/exaile/xl/panels/collection.py", line 545, in load_tree
    songs = self.search_tracks(self.keyword, self.all)
  File "/usr/lib/exaile/xl/panels/collection.py", line 561, in search_tracks
    self.keyword, None, self.where)
  File "/usr/lib/exaile/xl/library.py", line 232, in search_tracks
    for row in cur.fetchall():
sqlite3.OperationalError: Could not decode to UTF-8 column 'name' with text '/home/hide/muzika/maud/Isolee - We Are Monster [Tech House] [Minimal] [Electro]/Isolee - We Are Monster - 04 - M�dchen Mit Hase.mp3'
-----------------------
 load_tracks ( /usr/lib/exaile/xl/library.py @ 262):
-----------------------
Traceback (most recent call last):
  File "/usr/lib/exaile/xl/library.py", line 321, in load_tracks
    row = cur.fetchone()
OperationalError: Could not decode to UTF-8 column 'name' with text '/home/hide/muzika/maud/Isolee - We Are Monster [Tech House] [Minimal] [Electro]/Isolee - We Are Monster - 04 - M�dchen Mit Hase.mp3'

The thing is, I deleted the problematic song from the location, reloaded the collection, and the program still manages to return with the same error. I deleted that folder from the library, readded it, and the problem persists.
What minds me the most is that from time to time, collection starts appearing, but only to a random letter.

[kenden (kenden)]

Hi, thanks for the bug report!
Which version of Exaile are you using?
Do you have the same problem with the last one, version 0.2.13 ?
thanks,

[santix (santiar)]

I've got the same problem with version 0.2.11.
Also the GTK error message shows up empty, it should show the cause of the problem so that the user knows which file/files to rename.

[reacocard (reacocard)]

inactive bug, probably fixed in trunk.