Error when importing from plexWatch db

[ooii]

Hi,

I have a 2 year database from plexWatch which I want to keep. As soon as the import starts, I have the following error:

23-jul-2015 15:34:30 - DEBUG :: Thread-18 : PlexPy Importer :: PlexWatch data import in progress...
23-jul-2015 15:34:30 - DEBUG :: Thread-18 : PlexPy Importer :: Disabling monitoring while import in progress.
23-jul-2015 15:34:30 - INFO :: Thread-18 : Requesting users list refresh...
23-jul-2015 15:34:32 - INFO :: Thread-18 : Users list refreshed.
23-jul-2015 15:34:32 - DEBUG :: Thread-18 : PlexPy Importer :: Item has bad rating_key: http://www.canalplus.fr/c-sport/c-football/pid6597-c-enquetes-de-foot.html?vid=992848
23-jul-2015 15:34:32 - ERROR :: Thread-18 : Uncaught exception: Traceback (most recent call last):
  File "/private/tmp/plexpy/plexpy/logger.py", line 210, in new_run
    old_run(*args, **kwargs)
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/threading.py", line 763, in run
    self.__target(*self.__args, **self.__kwargs)
  File "/private/tmp/plexpy/plexpy/plexwatch_import.py", line 363, in import_from_plexwatch
    if str(row[2]).isdigit():
UnicodeEncodeError: 'ascii' codec can't encode characters in position 51-52: ordinal not in range(128)

Traceback (most recent call last):
  File "/private/tmp/plexpy/plexpy/logger.py", line 210, in new_run
    old_run(*args, **kwargs)
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/threading.py", line 763, in run
    self.__target(*self.__args, **self.__kwargs)
  File "/private/tmp/plexpy/plexpy/plexwatch_import.py", line 363, in import_from_plexwatch
    if str(row[2]).isdigit():
UnicodeEncodeError: 'ascii' codec can't encode characters in position 51-52: ordinal not in range(128)

Note that I have a lot of french content which may cause this issue.

[drzoidberg33]

Thanks for the report. I think I can see what the issue is and will push a fix in my next commit.

[ooii]

Thanks. I'm expecting it.

[drzoidberg33]

Please check if the latest commit b394ebc helps with this issue.

[ooii]

No, it does not.
Here is the output (seems the same):

24-jul-2015 08:48:58 - DEBUG :: Thread-13 : PlexPy Importer :: Item has bad rating_key: http://www.canalplus.fr/c-sport/c-football/pid6597-c-enquetes-de-foot.html?vid=992848
24-jul-2015 08:48:58 - ERROR :: Thread-13 : Uncaught exception: Traceback (most recent call last):
  File "/private/tmp/plexpy/plexpy/logger.py", line 210, in new_run
    old_run(*args, **kwargs)
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/threading.py", line 763, in run
    self.__target(*self.__args, **self.__kwargs)
  File "/private/tmp/plexpy/plexpy/plexwatch_import.py", line 363, in import_from_plexwatch
    if str(row[2]).isdigit():
UnicodeEncodeError: 'ascii' codec can't encode characters in position 51-52: ordinal not in range(128)

Traceback (most recent call last):
  File "/private/tmp/plexpy/plexpy/logger.py", line 210, in new_run
    old_run(*args, **kwargs)
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/threading.py", line 763, in run
    self.__target(*self.__args, **self.__kwargs)
  File "/private/tmp/plexpy/plexpy/plexwatch_import.py", line 363, in import_from_plexwatch
    if str(row[2]).isdigit():
UnicodeEncodeError: 'ascii' codec can't encode characters in position 51-52: ordinal not in range(128)

[drzoidberg33]

Hmm, very difficult for me to figure out what's causing this then without having the database. Is it possible you could share the database with me via dropbox, etc?

If you don't have issues with it you can share to my email address timvdwest (at) gmail.com

This would be the fastest solution otherwise I have to do a bunch of trial and error.

[ooii]

I understand. I can, of course, share it with you: https://www.dropbox.com/s/0ypqu0cyctox5wt/plexWatch.db?dl=0

Farid.

Le 24 juil. 2015 à 09:58, drzoidberg33 notifications@github.com a écrit :

Hmm, very difficult for me to figure out what's causing this then without having the database. Is it possible you could share the database with me via dropbox, etc?

If you don't have issues with it you can share to my email address timvdwest (at) gmail.com

This would be the fastest solution otherwise I have to do a bunch of trial and error.

—
Reply to this email directly or view it on GitHub.

[drzoidberg33]

Thank you, I'll look at this later today and provide a fix.

[ooii]

Thanks. Can I delete the file from dropbox?

Farid.

Le 24 juil. 2015 à 11:35, drzoidberg33 notifications@github.com a écrit :

Thank you, I'll look at this later today and provide a fix.

—
Reply to this email directly or view it on GitHub.

[drzoidberg33]

Yes thanks I have already added it to my Dropbox account.

[drzoidberg33]

Thanks so much for sharing the file, I have fixed the problem and some other issues along the way.

Please update to 5a92570, shut PlexPy down and delete any database files in your plexpy folder (plexpy.db, plexpy.db-wal, plexpy.db-shm) - this will delete any history logged in PlexPy already. Then restart again and try to import, or you can just do a clean install.

Let me know if you run into any more issues.

[ooii]

Thanks, it's OK now.

[drzoidberg33]

Confirmed fixed. Closing.