Issues with SickBeard

[ToneMoocat]

Is this a new Bug?

• [X] I checkd that the bug hasn't been reported before

Package Name

SickBeard Custom

Package Version

20200804-8

Device Model

Synology xs3415

Device Architecture

x86_64

Firmware Version

DSM 6.1.7

What happened?

Expected behaviour New Sickbeard Custom installation on Synology should work without issue.

Actual behaviour "SickBeard Custom" Stuck on "Checking Network TimeZones"

Reproduction steps

As I'm coming from a previous version of Sickbeard - I have backed up the var folder first.

1. Ensure Git is installed - Yes Latest version available 2.38.1-25
2. Ensure Python 3.8 is installed - Yes Latest version available 3.8.13-7
3. Launch Package Centre
4. Click Community, Search for SickBeard Custom (Diaoul) from the available apps and click INSTALL
5. Downloads starts and Vol1 is selected for installation (there is enough space over 200gb free)
6. Choose Fork, I change the fork URL from git://github.com/midgetspy/Sick-Beard.git to https://github.com/SickGear/SickGear.git
7. Fork branch = master
8. Click Next, Remove the option for "Run after installation" and then click Apply
9. Installation completes

Drop into an SSH session and move the backed up version of the var directotry to the new installation
Change ownership on these files to the same as the installation "sc-sickbeard-custom" & group as sickbeard-custom

START SickBeard

Log on when prompted via the SickBeard GUI and then a STARTING up page appears

It runs through a series of upgrades to the sickbeard.db, banners/posters, thumbnails, cache.db and failed.db (all OK)
but then gets stuck on the "Checking network timezones" - and there is no way to continue.

Checking back in Package Centre I can see the package has stopped.

Install Log

I have tailed the install log but all looks OK as installation completed successfully.

Service Log

I have tailed the service log and there isn't much in there tbh.

Other Logs

sickgear.log

File "/volume1/@appstore/sickbeard-custom/var/SickBeard/sickgear.py", line 509, in start
   network timezones.update_network_dict()
File "/volume1/@appstore/sickbeard-custom/var/SickBeard/sickbeard/network_timezones.py", line 325, in update_network_dict
   my_db.mass_action(cl)
File "/volume1/@appstore/sickbeard-custom/var/SickBeard/sickbeard/db.py", line 220, in mass_action
   sql_result.append(cursor.execute(*tuple(cur_query)).fetchall())
OperationalError: too many SQL variables

[BenjV]

That fork of sickbeard is very old and only runs with python 2

[hgy59]

duplicate of #3972

[ToneMoocat]

IMO, This is not a duplicate as this has nothing to do with SSL version etc. The version of SickBeard I installed required Python 3 and that #3972 doesn't mention anything about the Timezone.

[BenjV]

Sorry I did not red your post correctly. You where trying to use sickgear, which can run on python 3.

The real problem is that the package sickbeard-custom only works with sickbeard clones who run from source and sickgear needs some binary site packages.