[Ryoga79]

From what I'm seeing, you have a straight up XBMC import problem. Did you make sure to add new sources to XBMC for the MyLibrary/TVShows and MyLibrary/Movies directories and set the proper scrappers?

That Amanda Knox movie probably isn't going to get scrapped at all. I couldn't find it in themoviedb.org. You could create a .nfo file for it and try and force the import that way.



The easiest thing to do is to go to the plugin and click through the options to get you where you want to go and write down each one as you go. It looks like Terra Nova can be gotten to by TV/Networks/FOX/All/Terra Nova/Episodes. The bad news with that path is that the Terra Nova episodes will go into a folder called Episodes. You'll have to use a .nfo file to get XBMC to understand that folder is Terra Nova, and you can't have any other TV Show end with Episodes.

Honestly, the easiest thing I found to do with Hulu was to add stuff to my queue and then just point XBMC.MyLibrary to my queue using:

Code:

<Hulu path="plugin.video.hulu">
  <subfolder name="Queue" type="episodes" />
</Hulu>

I only keep TV shows in my Hulu queue, so that makes it easy. The above will not properly load movies in my queue.

I'm having a similar problem, and at least from what i can glean from the log, it looks like it may not be a databse problem, but a SQL problem. My log is very similar to his, in that i get repeated references to the files "not being in the database yet", but i also get repeated lines like this snippet below:

Code:

12/12/2011 08:10:08 PM ERROR   DBUpdate:TV Show Failed to check if file exists in XBMC's database using: SELECT idFile FROM files WHERE idPath IN(SELECT idPath FROM path WHERE LOWER(strPath) = 'y:\streaming\drop\tv shows\once.upon.a.time\season.1\') AND lower(strFileName) = 's01e06 - the shepherd.mpg'
12/12/2011 08:10:08 PM ERROR   DBUpdate:TV Show Could not execute query: SELECT idFile FROM files WHERE idPath IN(SELECT idPath FROM path WHERE LOWER(strPath) = 'y:\streaming\drop\tv shows\once.upon.a.time\season.1\') AND lower(strFileName) = 's01e03 - snow falls.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 's01e03 - snow falls.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:555)
                                                        at mylibrary.importer.updateDatabase(importer.java:1561)
                                                        at mylibrary.importer.importVideos(importer.java:357)
                                                        at mylibrary.importer.main(importer.java:25)

I get a copy of that line from every video file that was imported in the previous step. I checked my sources, and it looks like the files are getting imported into the library just fine, it's just that the query is failing when it goes back to check for the files the second time, so the files never get renamed. I'm trying to do the same import as above, with 10 "popular" tv shows and movies from bluecop's hulu plugin (of which i'm also using the latest version).

Config.xml pastebin here: http://pastebin.com/KYPxRPCK

Full Log pastebin here: http://pastebin.com/C8Pzt3kE

Can anyone enlighten me on what i might have done wrong that the second database query is failing?

Thanks!