500 Internal Server Error

[jacekglebocki]

It just appeared. I tried restarting, didnt help.

`500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

Traceback (most recent call last):
  File "lib/cherrypy/_cprequest.py", line 670, in respond
    response.body = self.handler()
  File "lib/cherrypy/lib/encoding.py", line 217, in __call__
    self.body = self.oldhandler(*args, **kwargs)
  File "lib/cherrypy/_cpdispatch.py", line 61, in __call__
    return self.callable(*self.args, **self.kwargs)
  File "/share/CACHEDEV1_DATA/.qpkg/QHeadPhones/headphones-master/headphones/webserve.py", line 70, in home
    artists = myDB.select('SELECT * from artists order by ArtistSortName COLLATE NOCASE')
  File "/share/CACHEDEV1_DATA/.qpkg/QHeadPhones/headphones-master/headphones/db.py", line 83, in select
    sqlResults = self.action(query, args).fetchall()
OperationalError: Could not decode to UTF-8 column 'MetaCritic' with text '5dc10f9f-cae4-47c8-84c3-346d948e9b8a'
Powered by CherryPy 3.6.0`

[Mister-42]

Got a similar error, but on a different action (choose specific download).

Traceback (most recent call last):
  File "lib/cherrypy/_cprequest.py", line 670, in respond
    response.body = self.handler()
  File "lib/cherrypy/lib/encoding.py", line 217, in __call__
    self.body = self.oldhandler(*args, **kwargs)
  File "lib/cherrypy/_cpdispatch.py", line 61, in __call__
    return self.callable(*self.args, **self.kwargs)
  File "/opt/headphones/headphones/webserve.py", line 442, in choose_specific_download
    results = searcher.searchforalbum(AlbumID, choose_specific_download=True)
  File "/opt/headphones/headphones/searcher.py", line 232, in searchforalbum
    results = do_sorted_search(album, new, losslessOnly, choose_specific_download=True)
  File "/opt/headphones/headphones/searcher.py", line 313, in do_sorted_search
    choose_specific_download)
  File "/opt/headphones/headphones/searcher.py", line 1570, in searchTorrent
    releasetype=album_type)['results'])
  File "lib/pygazelle/api.py", line 382, in search_torrents
    response = self.request(action='browse', **kwargs)
  File "lib/pygazelle/api.py", line 143, in request
    raise e
RequestException

[rembo10]

I think (hope is maybe a better word) all this stuff is sorted in the develop branch, which now runs on python 3. Strings now default to unicode, and the encoding to utf-8 all happens with cherrypy itself.

[raymondjstone]

Is the db structure compatible with the master branch? if so I can maybe switch and run for a while to help test.

[rembo10]

That would be really very much appreciated! There haven't been any changes to the db schema itself, but you can back up the db and config just in case because it's a pretty big change and there may have been some things I've missed