utf-8 error being reported
Posted: October 19th, 2019, 6:12 pm
Hi everybody,
So about 2 weeks ago an error started showing up on the main web page that there is a utf-8 error when parsing a URL. The URL happens to be one of my indexing site addresses that has somehow become corrupted. The problem is that I don't know where this configuration file that contains the indexing URL is. The downloads still continue fine and NZB Unity in FireFox seems to be working as well allowing me to one click to add to the SABnzbd queue. The problem is that the error is preventing me from being able to get to the configuration pages. When I try I get the same URL utf-8 parsing error and it hard stops with the error being shown. I can then go back to the main page but as it is right now I can't change my configuration. I don't need to do anything the config at this point but I do need to have this working going forward. So I need to know where the indexing URL's are stored so I can manually fix the corrupted URL.
Here is the error:
------------------------------------------------------------------------------------
OperationalError: Could not decode to UTF-8 column 'stage_log' with text 'Download:::Downloaded in 29 seconds at an average of 11.4 MB/s<br/>Age: 279d
Source:::https://nzb\F0lanet.net/getnzb/<HASH>d
2019-10-19 09:14:33,685::ERROR::[_cplogging:219] [19/Oct/2019:09:14:33]
Traceback (most recent call last):
File "/usr/share/sabnzbd/cherrypy/_cprequest.py", line 589, in run
self.respond(pi)
File "/usr/share/sabnzbd/cherrypy/_cprequest.py", line 690, in respond
self.handle_error()
File "/usr/share/sabnzbd/cherrypy/_cprequest.py", line 767, in handle_error
self.error_response()
File "/usr/share/sabnzbd/cherrypy/_cperror.py", line 394, in set_response
message=self._message)
File "/usr/share/sabnzbd/cherrypy/_cperror.py", line 400, in get_error_page
return get_error_page(*args, **kwargs)
File "/usr/share/sabnzbd/cherrypy/_cperror.py", line 537, in get_error_page
return result.encode('utf-8')
UnicodeDecodeError: 'utf8' codec can't decode byte 0xf0 in position 2342: invalid continuation byte
---------------------------------------------------------------------------------------
The error is in the Source line and the "\F0" should be "p" so the URL reads "nzbplanet.net".
Here are the system details:
Latest up to date Centos 7
Intel 12 core proc
32G RAM
FireFox 67.0.4
SABnzbd 2.3.9
Any help locating the file location that contains these URL's would be great.
Thanks in advance,
John
So about 2 weeks ago an error started showing up on the main web page that there is a utf-8 error when parsing a URL. The URL happens to be one of my indexing site addresses that has somehow become corrupted. The problem is that I don't know where this configuration file that contains the indexing URL is. The downloads still continue fine and NZB Unity in FireFox seems to be working as well allowing me to one click to add to the SABnzbd queue. The problem is that the error is preventing me from being able to get to the configuration pages. When I try I get the same URL utf-8 parsing error and it hard stops with the error being shown. I can then go back to the main page but as it is right now I can't change my configuration. I don't need to do anything the config at this point but I do need to have this working going forward. So I need to know where the indexing URL's are stored so I can manually fix the corrupted URL.
Here is the error:
------------------------------------------------------------------------------------
OperationalError: Could not decode to UTF-8 column 'stage_log' with text 'Download:::Downloaded in 29 seconds at an average of 11.4 MB/s<br/>Age: 279d
Source:::https://nzb\F0lanet.net/getnzb/<HASH>d
2019-10-19 09:14:33,685::ERROR::[_cplogging:219] [19/Oct/2019:09:14:33]
Traceback (most recent call last):
File "/usr/share/sabnzbd/cherrypy/_cprequest.py", line 589, in run
self.respond(pi)
File "/usr/share/sabnzbd/cherrypy/_cprequest.py", line 690, in respond
self.handle_error()
File "/usr/share/sabnzbd/cherrypy/_cprequest.py", line 767, in handle_error
self.error_response()
File "/usr/share/sabnzbd/cherrypy/_cperror.py", line 394, in set_response
message=self._message)
File "/usr/share/sabnzbd/cherrypy/_cperror.py", line 400, in get_error_page
return get_error_page(*args, **kwargs)
File "/usr/share/sabnzbd/cherrypy/_cperror.py", line 537, in get_error_page
return result.encode('utf-8')
UnicodeDecodeError: 'utf8' codec can't decode byte 0xf0 in position 2342: invalid continuation byte
---------------------------------------------------------------------------------------
The error is in the Source line and the "\F0" should be "p" so the URL reads "nzbplanet.net".
Here are the system details:
Latest up to date Centos 7
Intel 12 core proc
32G RAM
FireFox 67.0.4
SABnzbd 2.3.9
Any help locating the file location that contains these URL's would be great.
Thanks in advance,
John