+- 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)
+--- Thread: Win HTML Creator for Kodi (/showthread.php?tid=160863)
RE: HTML Generator: Show off your library with style to your friends or the world. - ConfusedTA - 2013-05-08
That's a problem of the program - I've copied across every file it generated
(I've tried it on another machine, and I get the same, no movies scraped, and no movies html page generated)
RE: HTML Generator: Show off your library with style to your friends or the world. - DeadSix27 - 2013-05-08
(2013-05-08, 15:09)ConfusedTA Wrote: That's a problem of the program - I've copied across every file it generated
(I've tried it on another machine, and I get the same, no movies scraped, and no movies html page generated)
Well, i fixed the debug error you posted, but im not sure why it doesnt process movies, maybe that error just interuppted the process, we'll see
test this version: (Note: I only included the debug file and the .exe no installer, simply paste that 2 files into the current .exe dir, and replace old one (keep the new pdb file as well))
6.3.1 Test: xbmc_html632.zip
RE: HTML Generator: Show off your library with style to your friends or the world. - ConfusedTA - 2013-05-08
New debug file: http://pastebin.com/M1H9ceKj
I can press Edit TV Show List and it brings up the window correctly. Still no movies, though.
RE: HTML Generator: Show off your library with style to your friends or the world. - DeadSix27 - 2013-05-08
(2013-05-08, 15:27)ConfusedTA Wrote: New debug file: http://pastebin.com/M1H9ceKj
I can press Edit TV Show List and it brings up the window correctly. Still no movies, though.
Is that really the whole debug file?
RE: HTML Generator: Show off your library with style to your friends or the world. - ConfusedTA - 2013-05-08
Unfortunately, yes.
Prior to uploading it, I deleted the debug file, and ran through the application again, and that was the result of doing it a second time - basically the same as the first.
RE: HTML Generator: Show off your library with style to your friends or the world. - DeadSix27 - 2013-05-08
(2013-05-08, 15:44)ConfusedTA Wrote: Unfortunately, yes.
Prior to uploading it, I deleted the debug file, and ran through the application again, and that was the result of doing it a second time - basically the same as the first.
Well i made a big change in the processing now, lets see if the debug gives more info now.
Download and extract this: xbmchtml_debug_632.zip
RE: HTML Generator: Show off your library with style to your friends or the world. - ConfusedTA - 2013-05-08
Getting closer
http://pastebin.com/YV0Dhyx1
It now goes further, and goes through trailers etc.
However, as you can see from the log, it seems to be creating too many connections to the MySQL server. The default is 151 connections.
Are you creating a new connection for each query, or just making one connection and re-using it?
RE: HTML Generator: Show off your library with style to your friends or the world. - DeadSix27 - 2013-05-08
(2013-05-08, 15:59)ConfusedTA Wrote: Getting closer
http://pastebin.com/YV0Dhyx1
It now goes further, and goes through trailers etc.
However, as you can see from the log, it seems to be creating too many connections to the MySQL server. The default is 151 connections.
Are you creating a new connection for each query, or just making one connection and re-using it?
I just re-use it. Let's see why that happends
Edit:
Heres new test: http://dead6.eu/files/debug_633.zip
RE: HTML Generator: Show off your library with style to your friends or the world. - ConfusedTA - 2013-05-08
http://pastebin.com/9kRTymre
This is the result of running the following command on MySQL:
show processlist;
(My bad, the default is 101 connections, not 151)
As soon as I close the application, this drops down to just 5 rows (my MySQL command line connection, plus 4 to the argustv database)
It seems as though it is creating new connections each time, whether it should be or not
RE: HTML Generator: Show off your library with style to your friends or the world. - DeadSix27 - 2013-05-08
(2013-05-08, 16:06)ConfusedTA Wrote: http://pastebin.com/9kRTymre
This is the result of running the following command on MySQL:
show processlist;
(My bad, the default is 101 connections, not 151)
As soon as I close the application, this drops down to just 5 rows (my MySQL command line connection, plus 4 to the argustv database)
It seems as though it is creating new connections each time, whether it should be or not
See edit, added new version
RE: HTML Generator: Show off your library with style to your friends or the world. - ConfusedTA - 2013-05-08
With 633 I get absolutely nothing. Just the following in the debug log when I press "Scrape Library"
Quote:Aquiring Source path's
RE: HTML Generator: Show off your library with style to your friends or the world. - DeadSix27 - 2013-05-08
(2013-05-08, 16:21)ConfusedTA Wrote: With 633 I get absolutely nothing. Just the following in the debug log when I press "Scrape Library"
Quote:Aquiring Source path's
gotta fix that today evening.
RE: HTML Generator: Show off your library with style to your friends or the world. - ConfusedTA - 2013-05-08
No rush
I'm just really happy that you're even looking at MySQL
RE: HTML Generator: Show off your library with style to your friends or the world. - DeadSix27 - 2013-05-08
(2013-05-08, 17:31)ConfusedTA Wrote: No rushTry 634:
http.//dead6.eu/files/xbmchtml_debug_634.zip
RE: HTML Generator: Show off your library with style to your friends or the world. - ConfusedTA - 2013-05-08
As soon as I hit "Scrape Library (MySQL)" the following pops up:
Quote:-------ERROR------
Object reference not set to an instance of an object.
at XBMCHtmlGenerator.Form_Main.InitializeMysql() in c:\Users\Hagen\Documents\Visual Studio 2012\Projects\XBMCManager\XBMCManager\Form_Main.cs:line 4761
at XBMCHtmlGenerator.Form_Main.btnMySqlConnect_Click(Object sender, EventArgs e) in c:\Users\Hagen\Documents\Visual Studio 2012\Projects\XBMCManager\XBMCManager\Form_Main.cs:line 4678
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.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)
-------ERROR------