[WINDOWS] SABSync - TV Show Syncing

[Ionitor]

That gives a new error - some kind of SQL version mismatch? It might be my configuration, but I can't tell how I would fix it on my end.


---------------------------

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: [A]System.Data.SQLite.SQLiteConnection cannot be cast to System.Data.SQLite.SQLiteConnection. Type A originates from 'System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' in the context 'Default' at location 'C:\utils\SABSync\System.Data.SQLite.dll'. Type B originates from 'System.Data.SQLite, Version=1.0.61.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' in the context 'Default' at location 'C:\Windows\assembly\GAC_32\System.Data.SQLite\1.0.61.0__db937bc2d44ff139\System.Data.SQLite.dll'.
  at System.Data.SQLite.SQLiteCommand.set_DbConnection(DbConnection value)
  at System.Data.Common.DbCommand.set_Connection(DbConnection value)
  at System.Data.Common.Utils.CommandHelper.SetStoreProviderCommandState(EntityCommand entityCommand, EntityTransaction entityTransaction, DbCommand storeProviderCommand)
  at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
  at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
  at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
  at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
  at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
  at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
  at SABSync.FrmMain.GetShows() in C:\Users\mark.mcdowall\Documents\Visual Studio 2010\Projects\sabscripts\SABSync\SABSync\FrmMain.cs:line 178
  at SABSync.FrmMain.Program_Load(Object sender, EventArgs e) in C:\Users\mark.mcdowall\Documents\Visual Studio 2010\Projects\sabscripts\SABSync\SABSync\FrmMain.cs:line 50
  at System.Windows.Forms.Form.OnLoad(EventArgs e)
  at System.Windows.Forms.Form.OnCreateControl()
  at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
  at System.Windows.Forms.Control.CreateControl()
  at System.Windows.Forms.Control.WmShowWindow(Message& m)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
  at System.Windows.Forms.Form.WmShowWindow(Message& m)
  at System.Windows.Forms.Form.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
SABSync
    Assembly Version: 0.9.9.1
    Win32 Version: 0.9.9.1
    CodeBase: file:///C:/utils/SABSync/SABSync.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Data.Entity
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.Entity/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Entity.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
ObjectListView
    Assembly Version: 2.4.1.37818
    Win32 Version: 2.4.1.0
    CodeBase: file:///C:/utils/SABSync/ObjectListView.DLL
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Data.OracleClient
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data.OracleClient/v4.0_4.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
----------------------------------------
System.Data.SQLite
    Assembly Version: 1.0.66.0
    Win32 Version: 1.0.66.0
    CodeBase: file:///C:/utils/SABSync/System.Data.SQLite.DLL
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Web
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
RSS.NET
    Assembly Version: 0.86.3627.40828
    Win32 Version: 0.86.3627.40828
    CodeBase: file:///C:/utils/SABSync/RSS.NET.DLL
----------------------------------------
System.Xml.Linq
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
System.Runtime.Serialization
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Data.SQLite.Linq
    Assembly Version: 2.0.38.0
    Win32 Version: 2.0.38.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.SQLite.Linq/2.0.38.0__db937bc2d44ff139/System.Data.SQLite.Linq.dll
----------------------------------------
System.Data.SQLite
    Assembly Version: 1.0.61.0
    Win32 Version: 1.0.61.0
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data.SQLite/1.0.61.0__db937bc2d44ff139/System.Data.SQLite.dll
----------------------------------------
Anonymously Hosted DynamicMethods Assembly
    Assembly Version: 0.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:


   


When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[markus101]

This is with 0.9.9.2? (The EXE will incorrectly show version 0.9.9.1 since I screwed up and didn't change it last night, sorry again)
When you downloaded this version did you overwrite the old version? Try extracting it to a fresh location (or delete the files first, just in-case).
Does a SABSync.db file get created?
When do you get the error, on start?
Which OS version do you have? 32/64bit?
Do you happen to have Visual Studio installed and previously installed "System.Data.SQLite"? (http://sqlite.phxsoftware.com/) - it looks like Version 1.0.61.0 is installed and being referenced, possibly something else installed it, which appears to be the source of the issue.
You could also try deleting the settings which for Windows 7/Vista will be here:

Code: Select all

C:\Users\<username>\AppData\Local\sabscripts.googlecode.com

I currently have it running on my laptop and desktop both Win7 x64 and my Windows Home Server v1 (32-bit) and things are looking good.

-Markus

[Vodka2]

Hi there.

Are you going to be adding nzbmatrix support soon to the next release as from what i have read this is a solid program that works 100%

Thanks

[markus101]

Hi Vodka,

I'm not sure I understand what you issue is. Currently I (and I imagine a number of other users) am/are using nzbmatrix without issue, though you will need to ensure you have added your username and apikey to the RSS URL for nzbmatrix:

Code: Select all

http://rss.nzbmatrix.com/rss.php?page=download&username=<my_username>&apikey=<my_apikey>&subcat=6&english=1

You would replace "" & "" (without quotes) with your username and apikey respectively.

If you have any further issues, please let me know.

-Markus

[Vodka2]

thanks for the reply. i am going to test this today.

Ok well i installed the app. setup the feed. let is scan my folders BUT what next? it stayed blank.

[deniax]

Hi,

I'm not sture what I'm doing wrong.
SABSync tells me:

Code: Select all

Verifying 'Supernatural S05E21 720p HDTV x264 IMMERSE'
'Supernatural' is being watched.
Quality is not wanted

But I have set my download quality to 720;xvid , so I'm not really sure why SABSync tells "Quality is not wanted"

It does this only for all SuperNatural series, other series don't seem to have this problem.

Any ideas?

[markus101]

It sounds like that particular show could be set to xvid only. Please go to the shows tab and confirm that under quality it shows "0" (zero) which will download xvid or 720p.

if you double-click on that cell you will be able to edit it's value.

EDIT: I'm having a similar issue with a couple shows (Quality is not wanted even though it is), so I'm digging into it further.

-Markus

[markus101]

@deniax, What is the folder name of the show on disk? (The same name as the show name in the Shows view). I've found an issue with comparing shows that SABnzbd has renamed (B To D) on disk and in the Shows view, but the actual name is B to D (shown in the feed this way) and SABSync was comparing the exact case.

0.9.9.3 will address this and should be released soon, just fixing up a couple other things.

Markus

[markus101]

0.9.9.3 Released, a couple bug fixes (one was pretty major).

Fixed:
File -> Exit will now work
Shows that SABnzbd renames to begin words with upper-case were not properly getting matched when looking for show quality (Skipping them even though they were wanted)

Added:
History will sort by Date Decending (Newest on top)
Log files also sorted by Date Decending (Newest on top)
Both the adds above really only apply to new installs due to GUI settings being saved between exiting and opening.

-Markus

[Ionitor]

The SQL version cast problem I mentioned at the top of the page still shows up with the latest version (.9.9.3). I deleted the entire install and settings directories, and I don't recall installing SQLite before (I haven't installed Visual Studio, either). I'm on the x64 version of Windows 7.

The error shows up on start, but the sabsync.db file is still created.

I hope that helps!

[Ionitor]

Hey - I was able to fix this myself by editing the .config file to add the bit described at http://sqlite.phxsoftware.com/forums/p/ ... .aspx#9302. Looks like this is a known bug with a known workaround!

[markus101]

Awesome news Ionitor, and thanks for posting the link, I'll do some testing on my end and include it moving forward as long as everything goes smoothly. Enjoy SABSync.

-Markus

[Ionitor]

It's working great. Two suggestions (apologies if they've already been brought up):

1) Give some way to delete shows from the show list. It doesn't look like shows in directories I've deleted will get downloaded, but they still show up in the list and confuse me a bit. Also, hitting scan twice in a row (accidently) produced a duplicate that I'd like to be able to get rid of...

2) Let us specify an episode number to start on. I've added a few mid-season shows that I don't want the early episodes downloaded, so it'd be nice to be able to specify "start on season 2, episode 11" or something like that.

[markus101]

1) Give some way to delete shows from the show list. It doesn't look like shows in directories I've deleted will get downloaded, but they still show up in the list and confuse me a bit. Also, hitting scan twice in a row (accidently) produced a duplicate that I'd like to be able to get rid of...

Yes, this needs to be added, it will also have to delete the episodes for that show from the episodes table and the History records (since they are linked to the Show and Episodes - they would appear with that information missing otherwise). Shouldn't be too difficult to do though.

2) Let us specify an episode number to start on. I've added a few mid-season shows that I don't want the early episodes downloaded, so it'd be nice to be able to specify "start on season 2, episode 11" or something like that.

I don't plan on adding this soon as it takes away from the simplicity of adding a new show (though it could be defaulted to S00E00 to start at the beginning) and I don't see a big use for this. An immediate work-around is to create a file for each episode you wish to ignore with your acceptable extensions (defaults: avi, mkv, wmv) so SABSync will think it already exists. For example: "Show Name - S01E10.avi"

-Markus

[LarzJG]

Ey Markus, just updated to .993, and it's good.

My old version showed 0 in all the "quality"-fields, now it shows Best Possible - I'm pretty sure they're the same value, just different displayed value now, yeah?

I can't for the life of me figure out how this relates to the Download Quality in Options? If I add Xvid in download quality, I'm imagining that "Best Possible" means Xvid - or does the individual show values override the download quality-value? I can see that it's the latter, but that kinda just means that me setting "Xvid only" in Download quality is essentially meaningless?

I'd suggest that you remove the Download Quality switch altogether, and just focus on doing stuff in the main screen to make it way faster and easier for us to set these values on the shows - we really don't need the value in two places, do we? Add buttons above the list of shows that set "all shows" to Best Quality, Xvid or 720, and we'll adjust the individual shows as we need to?

I've got a bit of a usability gripe with the listview in general too, and it might just be a minor thing - but it's counter-intuitive to have to double-click this list to edit stuff. We're conditioned to see various things as "clickable" because that's just how it's done in most programs, and lists like the one you're using is usually just not clickable to edit. There's usually the downwardfacing pyramid arrow to signify a drop-down or something like that, and input fields like the one for Alias is shown in a typical way too - if you really wanna make this thing easier to use and make sure that all users get the most out of it, I'd consider spending some time on that.

Still love your program btw, it's absolutely awesome.