SQLite duplicate column name errors

Cloud9Developer / Jellyfin-Newsletter-Plugin

GNU General Public License v3.0

66 stars 7 forks source link

SQLite duplicate column name errors #115

Open paulbaird87 opened 2 weeks ago

paulbaird87 commented 2 weeks ago

Fresh convert to Jelly after 5 years with Plex. Loving it so far, though finally come across my first hurdle.

Newsletter installed fine, SMTP settings test fine, Didn't touch the HTML format, Scraper config set to 'Local JF Hosting' with my public address eg: https://jellyfin.myserver.com

Filesystem Scraper seems to work but when I run task Email Newsletter I get thes errors (in image). SQLite errors saying it has duplicate columns. No newsletter email gets sent.

Any help would be much appreciated.

Cloud9Developer commented 2 weeks ago

Those WARNINGS are expected, not errors.

paulbaird87 commented 2 weeks ago

Those WARNINGS are expected, not errors.

Thank you for such a quick response. The scraper may be the issue then? I didn't think these were errors but may be the cause of this not working for me. I see now these are errors and the others where warnings, sorry.

Cloud9Developer commented 2 weeks ago

Yeah, those are the cause. looks like it tries scanning, and fails completely on the first few items? My next couple weeks are gonna be busy (going on vacation), so I won't be able to look into it until after.

If you can get me a snippet of some debug logs (turn on debug mode in the plugin's settings) that'd help for when I get back!

paulbaird87 commented 1 week ago

With Debug on both the scrapper and email tasks produce huge amounts of logs. Here is the end of both. Couldn't find the top of either, was scrolling for ages.

Email, end (debug on)

Scrapper, end (debug on)

Scrapper, error (debug off)

Plugin details