3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.

New User Posts : 4 Join date : 2010-09-10

First I have to give a massive thanks to Billy for the product... It's really helping me get my shows together. Since I have been adding and cleansing my shows, I have had no issues with the "Check (showname) for missing episodes" function, until I ran it against Modern Marvels. The search runs for about 10-15 seconds, the pops the exception dialogue.

Here is the dialogue I am presented with when the error occurs:

Microsoft .NET Framework
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

Conversion from string "0000-00-00" to type 'Date' is not valid.

Of course, I get the Details, Continue and Quit buttons.

Here is the text contained in the details portion of the error box:

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

************** Exception Text **************
System.InvalidCastException: Conversion from string "0000-00-00" to type 'Date' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions.ToDate(String Value)
at Media_Companion.Form1.findmissingepisodes(List`1 showslist, Boolean ignorelocked)
at Media_Companion.Form1.MissingepisodesToolStripMenuItem_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.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: 2.0.0.0
Win32 Version: 2.0.50727.4206 (VistaSP2GDR.050727-4200)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Media Companion
Assembly Version: 3.3.1.7
Win32 Version: 3.3.1.7
CodeBase: file:///C:/Program%20Files/Media%20Companion/Media%20Companion.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4205 (VistaSP2GDR.050727-4200)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
imdb
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Media%20Companion/imdb.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
TVDB
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Media%20Companion/TVDB.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:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

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.

I did not know if a workaround existed for this or if you had any advice.

My system is running Windows Server 2008 (32 bit) with Service Pack 2, if this makes any difference.

Again, this seems to be the only show, "acting the fool."

-Phil

Can you provide an example of the directory structure and folder/file names you have?

New User Posts : 4 Join date : 2010-09-10

AnthonyB wrote:: Can you provide an example of the directory structure and folder/file names you have?

Sure thing.

All my TV shows are stored under e:\shares\video\TV, using a "Showname", then "Season XX" structure, with episodes residing in the "Season XX" folders.

Here is a tree of season 1:

Code:: E:\>tree "e:\shares\video\tv\Modern Marvels" /F
Folder PATH listing for volume Storage (RAID 6)
Volume serial number is XXXXXXXXXXXXXXXXX
E:\SHARES\VIDEO\TV\MODERN MARVELS
│ fanart.jpg
│ folder.jpg
│ season01.tbn
│ season02.tbn
│ season03.tbn
│ season04.tbn
│ season05.tbn
│ season06.tbn
│ season07.tbn
│ season08.tbn
│ season09.tbn
│ season10.tbn
│ season11.tbn
│ season12.tbn
│ season13.tbn
│ season14.tbn
│ tvshow.nfo
│
├───Season 1
│ Modern Marvels - S01E03 - The Panama Canal.avi
│ Modern Marvels - S01E03 - The Panama Canal.nfo
│ Modern Marvels - S01E03 - The Panama Canal.tbn
│ Modern Marvels - S01E05 - Golden Gate Bridge.avi
│ Modern Marvels - S01E05 - Golden Gate Bridge.nfo
│ Modern Marvels - S01E05 - Golden Gate Bridge.tbn
│ Modern Marvels - S01E06 - Silver Mines.avi
│ Modern Marvels - S01E06 - Silver Mines.nfo
│ Modern Marvels - S01E06 - Silver Mines.tbn
│ Modern Marvels - S01E09 - Oil.avi
│ Modern Marvels - S01E09 - Oil.nfo
│ Modern Marvels - S01E09 - Oil.tbn

Hope this helps.

Thanks,

-Phil

New User Posts : 4 Join date : 2010-09-10

Just a quick extra note:

It appears the parsing stops around season 12 of Modern Marvels. The reason I say this is that I see blue (missing) episodes in Season 11, but I see no missing episodes for Season 12 (Despite that I am missing several episodes). Additionally, Seasons 13-16 do not show up as missing at all (I have only gotten to season 12 in my sorting efforts, so I have no folders beyond Season 12).

I am not sure, but it may (I know little about programming outside of T-SQL) have something to do with the way TheTVDB has some Season 12 episodes setup. If I look here: Modern Marvels - Season 12, then I see two initial episode "0"s. Neither have an episode title, but the second "0" episode has an air date of 0000-00-00.

I have to say, Modern Marvels has been an interesting one as their air dates rarely go in any particular order when compared to the seasons/episode numbers.

Again, thanks for the help!

-Phil

Edit: Attaching screenshot

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Exc_er12

Admin Posts : 1326 Join date : 2008-09-20

Seems to be a glitch when TVDB returns the main info for this show.

Some of the episodes listed are episode "0" with a date of "0000-00-00" and a title of "0"

The exception has been fixed for the next build and all episodes are located through to season 15.

New User Posts : 4 Join date : 2010-09-10

Awesome. Glad to know I wasn't crazy (much).

I look forward to the next release. Keep up the good work!

-Phil

Junior Member Posts : 18 Join date : 2011-05-09

All my TV shows are stored under e:\shares\video\TV, using a "Showname", then "Season XX" structure, with episodes residing in the "Season XX" folders.
Pearl Earrings

Junior Member Posts : 25 Join date : 2011-05-12

crystal earringsWhen I calculate my Body Mass Index it reads that I have a higher percent of body fat when I am more in shape, although I know this can not be correct. Is there a available that can determine what is muscle and what is fat?
crystal necklacecrystal bracelet

Senior Member Posts : 81 Join date : 2011-05-09

You might on top of that love quite a few nominal selling prices for shore wedding gowns internet, hence you can aquire the ideal seek the most perfect setting up plus along at the perfect cost!Scoop Wedding Dresses
Wedding Dresses 2011

» Unhandled Exception - String to Integer conversion version 1.986
» v1.911 Unhandled exception - Parameter is not valid:
» Exception Error when folder is anot available
» Poster Browser Exception Error (2.113)
» Unhandled exception error while trying to add a Movie folder