[FORK DELETED] SickBeard ThePirateBay Edition

For discussion and support of mr-orange's ThePirateBay branch

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby scythe000 » Tue Apr 22, 2014 10:45 am

If you didn't see it, it's official. Mr. 0range is quitting development. He recommends we switch to this branch:
http://sickbeard.com/forums/viewtopic.php?f=9&t=8725

I've got the branch installed, now I just need to know how to import my DB and all my settings. Anybody got any tips?
scythe000
 
Posts: 49
Joined: Mon Nov 22, 2010 11:04 pm

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby echel0n » Tue Apr 22, 2014 11:08 am

scythe000 wrote:If you didn't see it, it's official. Mr. 0range is quitting development. He recommends we switch to this branch:
viewtopic.php?f=9&t=8725

I've got the branch installed, now I just need to know how to import my DB and all my settings. Anybody got any tips?


Copy your .db and .ini files into your new SB folder of my fork and then start SB up to have it auto-migrate the files, make sure you backup before proceeding as nothing in life is for sure :)
echel0n
 
Posts: 328
Joined: Sun Feb 16, 2014 8:19 pm

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby Vaikin » Tue Apr 22, 2014 11:09 am

You can almost never just import a db from a different branch. There are too many differences, you end up with errors all over the place. Best to start with a clean db.
Vaikin
 
Posts: 166
Joined: Thu Mar 01, 2012 4:27 pm

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby echel0n » Tue Apr 22, 2014 11:29 am

Vaikin wrote:You can almost never just import a db from a different branch. There are too many differences, you end up with errors all over the place. Best to start with a clean db.


Agreed best to always start fresh, config.ini should be no issue but .db can always lead to more problems down the road.
I did write in a fairly comprehensive migration routine but nothing ever is for sure.
echel0n
 
Posts: 328
Joined: Sun Feb 16, 2014 8:19 pm

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby rascalli » Tue Apr 22, 2014 12:00 pm

echel0n wrote:
Agreed best to always start fresh, config.ini should be no issue but .db can always lead to more problems down the road.
I did write in a fairly comprehensive migration routine but nothing ever is for sure.


DB indeed gives problems ...

Code: Select all
Starting up Sick Beard master from /share/HDA_DATA/.qpkg/SickBeard/config.ini
19:58:46 INFO::MAIN :: Checking database structure...
19:58:46 INFO::MAIN :: Database upgrade required: Convert Shows To Indexer Scheme
19:58:46 INFO::MAIN :: Backing up database before upgrade
19:58:46 INFO::MAIN :: Proceeding with upgrade
19:58:46 INFO::MAIN :: Converting TV Shows table to Indexer Scheme...
19:58:46 INFO::MAIN :: Removing temp tables left behind from previous updates...
19:58:47 ERROR::MAIN :: DB error: no such column: tvdb_id
Error in ConvertTVShowsToIndexerScheme: no such column: tvdb_id
Traceback (most recent call last):
  File "SickBeard.py", line 354, in <module>
    main()
  File "SickBeard.py", line 274, in main
    sickbeard.initialize(consoleLogging=consoleLogging)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/__init__.py", line 927, in initialize
    db.upgradeDatabase(db.DBConnection(), mainDB.InitialSchema)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 249, in upgradeDatabase
    _processUpgrade(connection, schema)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 271, in _processUpgrade
    _processUpgrade(connection, upgradeSubClass)
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 262, in _processUpgrade
    instance.execute()
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/databases/mainDB.py", line 565, in execute
    "INSERT INTO tv_shows(show_id, indexer_id, show_name, location, network, genre, runtime, quality, airs, status, flatten_folders, paused, startyear, air_by_date, lang, subtitles, notify_list, imdb_id, last_update_indexer, dvdorder) SELECT show_id, tvdb_id, show_name, location, network, genre, runtime, quality, airs, status, flatten_folders, paused, startyear, air_by_date, lang, subtitles, notify_list, imdb_id, last_update_tvdb, dvdorder FROM tmp_tv_shows")
  File "/share/HDA_DATA/.qpkg/SickBeard/sickbeard/db.py", line 168, in action
    sqlResult = self.connection.execute(query)
sqlite3.OperationalError: no such column: tvdb_id
NL newsserver starting €44,40 a year

Image

Hope you will use my refereal link
rascalli
 
Posts: 4913
Joined: Tue Aug 10, 2010 2:26 pm

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby echel0n » Tue Apr 22, 2014 2:28 pm

Latest version may resolve that issue now, my guess is just bad db
echel0n
 
Posts: 328
Joined: Sun Feb 16, 2014 8:19 pm

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby akshay2000 » Wed Apr 23, 2014 9:47 am

Is it just me or this branch has suddenly vanished out of Github? I cant seem to find it here: https://github.com/mr-orange I loved this branch.
akshay2000
 
Posts: 2
Joined: Wed Apr 23, 2014 9:45 am

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby rascalli » Wed Apr 23, 2014 9:50 am

Please read back .. Mr_orange decided to stop with the branche
NL newsserver starting €44,40 a year

Image

Hope you will use my refereal link
rascalli
 
Posts: 4913
Joined: Tue Aug 10, 2010 2:26 pm

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby akshay2000 » Wed Apr 23, 2014 9:57 am

rascalli wrote:Please read back .. Mr_orange decided to stop with the branche

Sorry about that - the thread has gone a bit long. Do we have any good alternatives?
akshay2000
 
Posts: 2
Joined: Wed Apr 23, 2014 9:45 am

Re: SickBeard ThePirateBay Edition (Torrent branch+Subtitle)

Postby rascalli » Wed Apr 23, 2014 10:05 am

akshay2000 wrote:Sorry about that - the thread has gone a bit long. Do we have any good alternatives?


Have a look here : viewtopic.php?f=9&t=8725
NL newsserver starting €44,40 a year

Image

Hope you will use my refereal link
rascalli
 
Posts: 4913
Joined: Tue Aug 10, 2010 2:26 pm

PreviousNext

Return to ThePirateBay (mr-orange)

Who is online

Users browsing this forum: No registered users and 1 guest

cron