jakewaldron / PlexEmail

This script aggregates all new TV, movie and music releases for the past configured time then optionally writes to your web directory and sends out an email.
206 stars 32 forks source link

Metadata db encrypted? #82

Open ghost opened 7 years ago

ghost commented 7 years ago

Trying to get PlexEmail up and running on a new install. Sending a test results in log below and not sure where to troubleshoot from here.

017-05-28 16:13:03,825 - INFO:Test flag is set to True 2017-05-28 16:13:04,262 - INFO:Executing DB query: SELECT MD.id, MD.parent_id, MD.metadata_type, MD.title, MD.title_sort, MD.original_title, MD.rating, MD.tagline, MD.summary, MD.content_rating, MD.duration, MD.user_thumb_url, MD.tags_genre, MD.tags_director, MD.tags_star, MD.year, MD.hash, MD.[index], MD.studio, ME.duration, MD.originally_available_at FROM metadata_items MD LEFT OUTER JOIN media_items ME ON MD.id = ME.metadata_item_id WHERE added_at >= datetime('now', 'localtime', '-7 days', '-0 hours', '-0 minutes') AND metadata_type >= 1 AND metadata_type <= 10 ORDER BY title_sort; 2017-05-28 16:13:04,262 - ERROR:Logging an uncaught exception Traceback (most recent call last): File "plexemail.py", line 977, in cur.execute(dbQuery) DatabaseError: file is encrypted or is not a database

jakewaldron commented 7 years ago

What OS? Sounds like it might be an issue with the sqlite dll file. Follow prerequisite step 2 if you haven't already.

On Sun, May 28, 2017 at 4:18 PM, aenyan notifications@github.com wrote:

Trying to get PlexEmail up and running on a new install. Sending a test results in log below and not sure where to troubleshoot from here.

017-05-28 16:13:03,825 - INFO:Test flag is set to True 2017-05-28 16:13:04,262 - INFO:Executing DB query: SELECT MD.id, MD.parent_id, MD.metadata_type, MD.title, MD.title_sort, MD.original_title, MD.rating, MD.tagline, MD.summary, MD.content_rating, MD.duration, MD.user_thumb_url, MD.tags_genre, MD.tags_director, MD.tags_star, MD.year, MD.hash, MD.[index], MD.studio, ME.duration, MD.originally_available_at FROM metadata_items MD LEFT OUTER JOIN media_items ME ON MD.id = ME.metadata_item_id WHERE added_at >= datetime('now', 'localtime', '-7 days', '-0 hours', '-0 minutes') AND metadata_type >= 1 AND metadata_type <= 10 ORDER BY title_sort; 2017-05-28 16:13:04,262 - ERROR:Logging an uncaught exception Traceback (most recent call last): File "plexemail.py", line 977, in cur.execute(dbQuery) DatabaseError: file is encrypted or is not a database

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/jakewaldron/PlexEmail/issues/82, or mute the thread https://github.com/notifications/unsubscribe-auth/AK0IAdCl8RBCaYCz3kT7uJGn3UAkjE34ks5r-gDGgaJpZM4Noyqy .

ghost commented 7 years ago

Windows 10. SQLlite3 and SQLlite3-64 are in DLL folder in Python 2.7 directory from previous installs. Closing all python instances and replacing SQLlite3 fixed it.