Media Companion
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Media Companion

Discussion and development board for the program Media Companion.
 
HomeHome  Latest imagesLatest images  SearchSearch  RegisterRegister  Log inLog in  

 

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

Go down 
+2
AnthonyB
Philstuf
6 posters
AuthorMessage
Philstuf
New User
New User



Posts : 4
Join date : 2010-09-10

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject: 3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.   3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitimeFri Sep 10, 2010 5:09 am

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


Back to top Go down
AnthonyB
Senior Member
Senior Member



Posts : 122
Join date : 2008-11-08
Location : Sydney, Australia

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject: Re: 3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.   3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitimeSat Sep 11, 2010 4:14 am

Can you provide an example of the directory structure and folder/file names you have?
Back to top Go down
Philstuf
New User
New User



Posts : 4
Join date : 2010-09-10

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject: Re: 3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.   3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitimeMon Sep 13, 2010 5:16 pm

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
Back to top Go down
Philstuf
New User
New User



Posts : 4
Join date : 2010-09-10

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject: Re: 3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.   3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitimeMon Sep 13, 2010 10:22 pm

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


Last edited by Philstuf on Mon Sep 13, 2010 10:28 pm; edited 1 time in total (Reason for editing : Attached Screenshot)
Back to top Go down
billyad2000
Admin
billyad2000


Posts : 1326
Join date : 2008-09-20

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject: Re: 3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.   3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitimeSun Oct 03, 2010 12:37 pm

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.
Back to top Go down
http://billyad2000.co.uk
Philstuf
New User
New User



Posts : 4
Join date : 2010-09-10

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject: Re: 3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.   3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitimeTue Oct 05, 2010 4:40 am

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

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

-Phil
Back to top Go down
gztuitui
Junior Member
Junior Member



Posts : 18
Join date : 2011-05-09

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject:    3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitimeMon May 09, 2011 12:15 pm

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
Back to top Go down
wedd123
Junior Member
Junior Member



Posts : 25
Join date : 2011-05-12

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject: crystal bracelet   3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitimeThu May 19, 2011 12:10 pm

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
Back to top Go down
Johnson75
Senior Member
Senior Member



Posts : 81
Join date : 2011-05-09

3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject: Re: 3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.   3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitimeFri Jun 10, 2011 6:08 am

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
Back to top Go down
Sponsored content





3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Empty
PostSubject: Re: 3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.   3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid. Icon_minitime

Back to top Go down
 
3.317 - Unhandled Exception error - Conversion from string "0000-00-00" to type 'Date' is not valid.
Back to top 
Page 1 of 1
 Similar topics
-
» 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

Permissions in this forum:You cannot reply to topics in this forum
Media Companion :: Media Companion :: Bug Discussion-
Jump to: