Kodi Community Forum
Ember Media Manager NFO/Poster/FanArt Manager for Movies (Open Source VB.NET) - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+---- Forum: Ember Media Manager (https://forum.kodi.tv/forumdisplay.php?fid=195)
+---- Thread: Ember Media Manager NFO/Poster/FanArt Manager for Movies (Open Source VB.NET) (/showthread.php?tid=50348)



- mark007 - 2009-06-07

Thanks so much, looking alot better Big Grin but did take a few attempts to get it to show my movies on first attempt as others say.

Just the extrathumbs editor seems to be a bit buggy still. I have 13 extra thumbs for a movie "300". I was trying to move number 10, upto number 2 so it appears in xbmc multiplex view. Two things went wrong.

When pressing "up", the extrathumb did change number, 10,9,8,7 etc but didn't change position in the list, like the list wasn't resorted after I pressed up. Also, the image above the one I was working with, got its number incremented, its at 17 now. I just took a screenshot to show you.

Image


- MrDVD - 2009-06-07

@Ayla i had the same error after the first start but @ the 2nd try i saw the movies after an rescan.
Code:
Title: Error
Message: Abort due to constraint violation
movies.lock may not be NULL
StackTrace:    bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei Ember_Media_Manager.Master.ConnectDB(Boolean Reset)
   bei Ember_Media_Manager.frmMain.frmMain_Load(Object sender, EventArgs e)
Date/Time: 07.06.2009 12:25:27



- Ayla - 2009-06-07

MrDVD Wrote:@Ayla i had the same error after the first start but @ the 2nd try i saw the movies after an rescan.
Code:
Title: Error
Message: Abort due to constraint violation
movies.lock may not be NULL
StackTrace:    bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei Ember_Media_Manager.Master.ConnectDB(Boolean Reset)
   bei Ember_Media_Manager.frmMain.frmMain_Load(Object sender, EventArgs e)
Date/Time: 07.06.2009 12:25:27

Thanks MrDVD !

After 4-6 tries and some restarts of EMM, it suddenly worked Smile


- PrimaryMaster - 2009-06-07

nul7 Wrote:Is this still a problem with r257?

no.. now it works =)


- Nuno - 2009-06-07

Me again,
Some issues with HTML decode, you can test it (re)scraping "Foor Rooms (1995)" .. Studio will get some unDecode HTML. (same will happen for Director a Writer in other movies)
diif patch
Code:
Index: clsScrapeIMDB.vb
===================================================================
--- clsScrapeIMDB.vb    (revision 258)
+++ clsScrapeIMDB.vb    (working copy)
@@ -481,7 +481,7 @@
                 'got any director(s) ?
                 If D > 0 AndAlso Not W <= 0 Then
                     'get only the first director's name
-                    Dim rDir As MatchCollection = Regex.Matches(HTML.Substring(D, W - D), HREF_PATTERN)
+                    Dim rDir As MatchCollection = Regex.Matches(Web.HttpUtility.HtmlDecode(HTML.Substring(D, W - D)), HREF_PATTERN)
                     Dim Dir = From M As Match In rDir Where Not M.Groups("name").ToString.Contains("more") _
                               Select Web.HttpUtility.HtmlDecode(M.Groups("name").ToString)

@@ -593,7 +593,7 @@
                         If D > 0 Then W = HTML.IndexOf("</ul>", D)
                         If D > 0 AndAlso W > 0 Then
                             'only get the first one
-                            Dim Ps = From P1 As Match In Regex.Matches(HTML.Substring(D, W - D), HREF_PATTERN) _
+                            Dim Ps = From P1 As Match In Regex.Matches(Web.HttpUtility.HtmlDecode(HTML.Substring(D, W - D)), HREF_PATTERN) _
                                      Where Not P1.Groups("name").ToString = String.Empty _
                                      Select Studio = P1.Groups("name").ToString Take 1
                             IMDBMovie.StudioReal = Ps(0).ToString.Trim
@@ -602,7 +602,7 @@
                         D = HTML.IndexOf("<h5>Company:</h5>")
                         If D > 0 Then W = HTML.IndexOf("</div>", D)
                         If D > 0 AndAlso W > 0 Then
-                            IMDBMovie.StudioReal = Regex.Match(HTML.Substring(D, W - D), HREF_PATTERN).Groups("name").ToString.Trim
+                            IMDBMovie.StudioReal = Regex.Match(Web.HttpUtility.HtmlDecode(HTML.Substring(D, W - D)), HREF_PATTERN).Groups("name").ToString.Trim
                         End If
                     End If
                 End If
@@ -616,7 +616,7 @@
                 D = HTML.IndexOf("<h5>Writer")
                 If D > 0 Then W = HTML.IndexOf("</div>", D)
                 If D > 0 AndAlso W > 0 Then
-                    Dim q = From M As Match In Regex.Matches(HTML.Substring(D, W - D), HREF_PATTERN) _
+                    Dim q = From M As Match In Regex.Matches(Web.HttpUtility.HtmlDecode(HTML.Substring(D, W - D)), HREF_PATTERN) _
                             Where Not M.Groups("name").ToString = "more" _
                             AndAlso Not M.Groups("name").ToString = "(more)" _
                             AndAlso Not M.Groups("name").ToString = "(WGA)" _
@@ -636,7 +636,7 @@
                     D = HTML.IndexOf("Directed by</a></h5>")
                     If D > 0 Then W = HTML.IndexOf("</body>", D)
                     If D > 0 AndAlso W > 0 Then
-                        Dim qTables As MatchCollection = Regex.Matches(HTML.Substring(D, W - D), TABLE_PATTERN)
+                        Dim qTables As MatchCollection = Regex.Matches(Web.HttpUtility.HtmlDecode(HTML.Substring(D, W - D)), TABLE_PATTERN)

                         For Each M As Match In qTables
                             'Producers

BTW: do you want me to report in here or in the google issue?


- Nuno - 2009-06-07

...
if nfo have some genres not in EMM genres list (ie. put by another XBMC scraper) exception will occur and some info on EditMovie form will not load

diff patch
Code:
Index: dlgEditMovie.vb
===================================================================
--- dlgEditMovie.vb    (revision 258)
+++ dlgEditMovie.vb    (working copy)
@@ -421,7 +421,9 @@
                     Dim genreArray() As String
                     genreArray = Strings.Split(Master.currMovie.Genre, " / ")
                     For g As Integer = 0 To UBound(genreArray)
-                        .lbGenre.SetItemChecked(.lbGenre.FindString(Strings.Trim(genreArray(g))), True)
+                        If .lbGenre.FindString(Strings.Trim(genreArray(g))) > 0 Then
+                            .lbGenre.SetItemChecked(.lbGenre.FindString(Strings.Trim(genreArray(g))), True)
+                        End If
                     Next

                     If .lbGenre.CheckedItems.Count = 0 Then


EDIT: This will solve issue 121 in google issue tracker


- nul7 - 2009-06-07

MrDVD Wrote:Some cosmetic error
The counter behind Movies (xxx) isnt updated after you insert/clear an filter

The counter is the total movie count... I never intended it to display the filtered list count. I can add a separate count display if you wish.

Ayla Wrote:My movie list is now empty. When I click Rescan Media nothing get's loaded.

mark007 Wrote:Thanks so much, looking alot better Big Grin but did take a few attempts to get it to show my movies on first attempt as others say.

MrDVD Wrote:@Ayla i had the same error after the first start but @ the 2nd try i saw the movies after an rescan.

Strange.... I guess SQLite doesn't operate the same way as MySQL when dealing with default values on "NOT NULL" columns? I'll have to drop in the forums for the library I use and see what's up with that.

EDIT: After staring at this for a moment, I had another "duh" moment. It's because of the "NOT NULL". *sigh* I'll fix this for the next release.

mark007 Wrote:Just the extrathumbs editor seems to be a bit buggy still. I have 13 extra thumbs for a movie "300". I was trying to move number 10, upto number 2 so it appears in xbmc multiplex view. Two things went wrong.

When pressing "up", the extrathumb did change number, 10,9,8,7 etc but didn't change position in the list, like the list wasn't resorted after I pressed up. Also, the image above the one I was working with, got its number incremented, its at 17 now. I just took a screenshot to show you.

Image

Hmm.... I'll play with this today to get the kinks worked out.

EDIT: Ok, I think this is fixed (for real this time) for the next release.

PrimaryMaster Wrote:no.. now it works =)

Whew... ok, good. Had me worried for a second there. lol

Nuno Wrote:Me again,
Some issues with HTML decode, you can test it (re)scraping "Foor Rooms (1995)" .. Studio will get some unDecode HTML. (same will happen for Director a Writer in other movies)
diif patch

... code snip ...

BTW: do you want me to report in here or in the google issue?

I see your intentions, but some of the changes are not necessary and some needed to be tweaked a little. Taking directors, for example, they are already being decoded in the linq:

Code:
Dim Dir = From M As Match In rDir Where Not M.Groups("name").ToString.Contains("more") _
                              [b] Select Web.HttpUtility.HtmlDecode(M.Groups("name").ToString)[/b]

The same method just needed to be applied for the linq select statement for other items. For the ones not using linq, I just decode the entire value:

Code:
IMDBMovie.StudioReal = Web.HttpUtility.HtmlDecode(Regex.Match(HTML.Substring(D, W - D), HREF_PATTERN).Groups("name").ToString.Trim)

Posting here is fine for small patches like these as I can apply them immediately. If they're bigger changes, please use the google code page so they won't get lost in case I don't have time to get to them right away.

Nuno Wrote:...
if nfo have some genres not in EMM genres list (ie. put by another XBMC scraper) exception will occur and some info on EditMovie form will not load

diff patch
Code:
Index: dlgEditMovie.vb
===================================================================
--- dlgEditMovie.vb    (revision 258)
+++ dlgEditMovie.vb    (working copy)
@@ -421,7 +421,9 @@
                     Dim genreArray() As String
                     genreArray = Strings.Split(Master.currMovie.Genre, " / ")
                     For g As Integer = 0 To UBound(genreArray)
-                        .lbGenre.SetItemChecked(.lbGenre.FindString(Strings.Trim(genreArray(g))), True)
+                        If .lbGenre.FindString(Strings.Trim(genreArray(g))) > 0 Then
+                            .lbGenre.SetItemChecked(.lbGenre.FindString(Strings.Trim(genreArray(g))), True)
+                        End If
                     Next

                     If .lbGenre.CheckedItems.Count = 0 Then


EDIT: This will solve issue 121 in google issue tracker

Bah.... same structure as the old code. Don't know what I was thinking there. lol Thanks, again!


- PrimaryMaster - 2009-06-07

ant ETA on the "TV" part for EMM ?


- nul7 - 2009-06-07

PrimaryMaster Wrote:ant ETA on the "TV" part for EMM ?

Some time after today. lol




I'll be making a bugfix release tonight as there is a pretty serious bug in the movie editor. If a genre does not exist in the genre list it causes an error and doesn't finish loading the rest of the data (including images). If you hit "OK" it assumes that you intended to remove the images and deletes them.


- nul7 - 2009-06-07

My wife and I are going out for "date night" so I need to get ready and I don't know when I'll be back home. Figured I should make the next release just in case I get home too late tonight and can't do it later. So r263 is in the first post. Just a small bug fix release.

For people using r257 it is very important that you upgrade to r263 due to the bug in the movie editor (unless you never edit your movies or don't care that you'll lose data lol). Also, let me know if the new version check worked properly. Wink


- nul7 - 2009-06-08

I've created a readme file to include with future versions of Ember that will hopefully alleviate some of the repeated questions and "It doesn't work" = "You need the Extras package" bug reports. If someone would be so kind as to look it over and provide any suggestions for changes/additions, I would be highly appreciative:

http://www.cube3studios.com/EMM/README.rtf

Thanks!


- Neku - 2009-06-08

Can you add an option to update only trailer links to .nfo files?


- nul7 - 2009-06-08

Neku Wrote:Can you add an option to update only trailer links to .nfo files?

I will if you add your feature request here:

http://code.google.com/p/embermediamanager/issues/list

:p


- Neku - 2009-06-08

Done. ;]


- Radikaltimes - 2009-06-08

just upgreaded .. and i got the following error if i try to right click over the movie list

======================
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
doesn't load new movies either.

************** Exception Text **************
System.InvalidCastException: Conversion from type 'DBNull' to type 'Boolean' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions.ToBoolean(Object Value)
at Ember_Media_Manager.frmMain.dgvMediaList_MouseDown(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.DataGridView.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.DataGridView.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.3074 (QFE.050727-3000)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Ember Media Manager
Assembly Version: 0.0.0.263
Win32 Version: 0.0.0.263
CodeBase: file:///C:/Users/media/Documents/emm/Ember%20Media%20Manager.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data.SQLite
Assembly Version: 1.0.61.0
Win32 Version: 1.0.61.0
CodeBase: file:///C:/Users/media/Documents/emm/System.Data.SQLite.DLL
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
has9ows9
Assembly Version: 0.0.0.263
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Xml.Linq
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.1 built by: SP
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
System.Core
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.1 built by: SP
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
_cuu34qw
Assembly Version: 0.0.0.263
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.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.

=========