XBMC Community Forum
XBMC.MyLibrary - Scan any source to the library (Hulu/Netflix/Plugins) - Printable Version

+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for XBMC (/forumdisplay.php?fid=116)
+--- Thread: XBMC.MyLibrary - Scan any source to the library (Hulu/Netflix/Plugins) (/showthread.php?tid=98210)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88

- bradvido88 - 2011-06-30 14:53

@ktjensen
Thanks, it's just a spare time project for me. I like to give back to the XBMC community when i can since it's been so awesome to me over the years!

- bradvido88 - 2011-06-30 14:57

--Sorry, double post

- qq_bryon - 2011-07-01 18:10

first thanks so much for this, this is exactly what I wanted in setting up my xbmc. I'm very excited to get it working but running into a problem.

It looks like everything is set up correctly but when it goes to update xbmc database I get errors stating

Code:
07/01/2011 10:23:06 AM ERROR   DBUpdate:TV Show Could not execute query: SELECT idFile FROM files WHERE idPath IN(SELECT idPath FROM path WHERE strPath = 'C:\Library\dropbox\TV Shows\Arrested.Development\Season.1\') AND strFileName = 'S01E01 - Pilot.mpg'
                                                    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'S01E01 - Pilot.mpg'' at line 1
                                                        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
                                                        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
                                                        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
                                                        at java.lang.reflect.Constructor.newInstance(Unknown Source)
                                                        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
                                                        at com.mysql.jdbc.Util.getInstance(Util.java:381)
                                                        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
                                                        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                                                        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
                                                        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
                                                        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
                                                        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
                                                        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
                                                        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571)
                                                        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1451)
                                                        at utilities.Database.getSingleInt(Database.java:205)
                                                        at utilities.XBMCInterface.updateFilePointers(XBMCInterface.java:554)
                                                        at mylibrary.importer.updateDatabase(importer.java:1564)
                                                        at mylibrary.importer.importVideos(importer.java:359)
                                                        at mylibrary.importer.main(importer.java:27)
as you can see the problem is that it's escaping the single quote with the path i.e Season.1\' causing it to not terminate the string in the query. This causes all the updates to fail. This is on a windows 7 box and maybe that's the problem. here's my entire log file for reference.

http://dl.dropbox.com/u/3154799/XBMC.MyLibrary.log

- gseib - 2011-07-01 18:37

Here is another example of the problem i have with none "seasoned" tv shows on netflix (collections and volumes)

http://pastebin.com/RLDMueRK

for some reason it chooses the "volume 1" as the series lookup. I am sure it is something im doing wrong, but what?

- qq_bryon - 2011-07-03 20:42

Actually found the solution to my problem by turning off escaped characters in mysql

http://stackoverflow.com/questions/3098978/mysql-interpreting-special-characters-in-generated-query

- bradvido88 - 2011-07-03 21:04

gseib Wrote:Here is another example of the problem i have with none "seasoned" tv shows on netflix (collections and volumes)

http://pastebin.com/RLDMueRK

for some reason it chooses the "volume 1" as the series lookup. I am sure it is something im doing wrong, but what?

I'd need a full log to determine if it's doing custom Netflix parsing

- bradvido88 - 2011-07-03 21:07

qq_bryon Wrote:Actually found the solution to my problem by turning off escaped characters in mysql

http://stackoverflow.com/questions/3098978/mysql-interpreting-special-characters-in-generated-query

Yep that'll work but it shouldn't be necessary. I'll take a look at my escaping, I thought I had that handled correctly.

- amirite - 2011-07-04 20:10

hey, could one of you check my config for me? I'm trying to merge a small number of Netflix and Hulu sources into my library, but I'm getting the error that my config.xml isn't valid. I hope I'm not just doing something dumb:

http://pastebin.com/y9CneG4r

Thanks in advance! This seems like a kickass program, just can't seem to get it to work right yet...

- qq_bryon - 2011-07-05 15:31

@amirite This
<subfolder name="Popular/Popular Feature Films" recursive="true" type="movies" max_videos="10" suffix=" [H]></subfolder>

suffix doesn't have a closed " so it should be

<subfolder name="Popular/Popular Feature Films" recursive="true" type="movies" max_videos="10" suffix=" [H]"></subfolder>

- amirite - 2011-07-05 23:25

lol whooops, of course it was a typo... thanks for pointing it out for me! Seems to be working now, but my new videos aren't actually playing. I'm supposed to set my streaming dropbox as a source right? Because it finds all the media just fine, it's just that nothing's playing...

could be user error. I'm gonna try clearing my databases and scanning again.

EDIT: Finally got this working last night - it's wonderful! Big Grin