All pastes #443257 Raw Edit

Mine

public text v1 · immutable
·published 2007-04-16 18:33 UTC
rendered paste body
[wladek@thewire /home/ices/ices/dev]$ python index_music31.py
<br />DEBUG: QUERY: SELECT PATH_GENRE FROM GENRES
<br />DEBUG: QUERY: SELECT PATH_ALBUM FROM ALBUMS
<br />DEBUG: QUERY: SELECT FUNC_GET_OPTION('BasePath') AS PATH_BASE
<br />DEBUG: QUERY: SELECT PATH_GENRE FROM GENRES
<br />DEBUG: QUERY: SELECT PATH_ALBUM FROM ALBUMS
<br />DEBUG: QUERY: SELECT ID_GENRE FROM GENRES WHERE PATH_GENRE LIKE LCASE('%el
ectronic%')
<br />DEBUG: PATH_ALBUM: Funkstörung - Oszillator
<br />DEBUG: type(PATH_ALBUM): <type 'str'>
<br />DEBUG: repr: 'Funkst\xf6rung - Oszillator'
<br />DEBUG: QUERY: INSERT INTO ALBUMS (ID_GENRE, PATH_ALBUM) VALUES (1, 'Funkst
örung - Oszillator')
Traceback (most recent call last):
  File "index_music31.py", line 297, in ?
    print "\n".join([   '<html>',
  File "index_music31.py", line 111, in scan
    id_album = self._insert_album(id_genre, path_components['album'])
  File "index_music31.py", line 153, in _insert_album
    return self._db.run_query("INSERT INTO ALBUMS (ID_GENRE, PATH_ALBUM) VALUES
(%s, '%s')"%(str(id_genre), mysqldb.escape_string(str(path_album))), self._db.LA
ST_ID)
  File "index_music31.py", line 253, in run_query
    count = curs.execute(query)
  File "/usr/local/lib/python2.4/site-packages/MySQLdb/cursors.py", line 146, in
 execute
    query = query.encode(charset)
  File "/usr/local/lib/python2.4/encodings/iso8859_9.py", line 18, in encode
    return codecs.charmap_encode(input,errors,encoding_map)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xf6 in position 60: ordinal not in range(128)