TheCasa Wrote:Thanks for the quick response. For simplicity's sake, I changed the config to only pull in 2 movies. One of them is added to the library, the other is not. That mpg is not renamed though. Here's the log:
http://pastebin.com/pZD3nVrC
and here is my config:
http://pastebin.com/8T8vXdBJ

Thanks again in advance for the help. I'm a pretty quick learner, but I'm a virgin on this.

TheCasa Wrote:Thanks for the quick response. For simplicity's sake, I changed the config to only pull in 2 movies. One of them is added to the library, the other is not. That mpg is not renamed though. Here's the log:
http://pastebin.com/pZD3nVrC
and here is my config:
http://pastebin.com/8T8vXdBJ

Thanks again in advance for the help. I'm a pretty quick learner, but I'm a virgin on this.

TheCasa Wrote:Here's the log with logging set to info.
http://pastebin.com/94w8qRfS

TheCasa Wrote:Does anyone have a reference for how the subfolders are structured for that plugin? For example, I'm trying to import the Terra Nova tv show. I've tried /TV/T/Terra Nova/Full Episodes, I've tried /TV Shows/T/Terra Nova/Full Episodes, /TV Shows/Full Episodes/T/Terra Nova, etc. Lots of iterations with no luck.

pkscuot Wrote: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?

Quote: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.

Quote: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.

pkscuot Wrote: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.

Ryoga79 Wrote: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!

TheCasa Wrote:Yes, the sources are setup and the content is set properly. XBMC is pulling the tv shows/movies into the library, but the mpgs aren't being renamed to strm and doing the database magic to make them play.


You're right, that movie didn't get scraped or imported, and honestly I don't care. I was just using the straight up example from the users manual to try to get it working in some way. But it's good to know how I'd have to go about getting movies or tv that can't be scraped.



I'll just use that code and see if I can get it to pull the queue in. I'm just trying to get it working, then I'll try to get some stuff customized.

Thanks for your help. I'll run it with you code above and let you know how it goes......

bradvido88 Wrote:It looks like MySQL is failing at executing that query. What version of MySQL are you using? Can you try and execute the query manually (if you know how)

Code:

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'

Ryoga79 Wrote:Trying to do a crash course in mysql right now to find out the second part, but the version is:

Server version: 5.1.54-1ubuntu4 (Ubuntu)

Running on ubuntu server (natty)

bradvido88 Wrote:See my edited post above, it's a problem with me escaping backslashes in the query. In the meantime, you could try a smb share as those paths shouldn't have backslashes.

I'll post a fix (probably tomorrow but no guarantees)

Ryoga79 Wrote:Do you mind filling me in on the SMB syntax for the config.xml?
...
in the log - no files get written. Any suggestions? I'm new to this XML thing, clearly

TheCasa Wrote:After pulling only my queue in, again, the files were downloaded, added to the xbmc library, but not converted to strm for playing. Here's my searchfilter:

Code:

<Hulu path="plugin://plugin.video.hulu">
        <subfolder name="Queue" type="episodes" />
                                
        <exclude>
            <contains>previous page</contains>                    
            <contains>next page</contains>                        
        </exclude>
    </Hulu>

Weird....

1. Your dropbox\Tv Shows directory has not been added as a source in XBMC and had it's content type set to "TV Shows" (this should be done after some .mpg's exists in the dropbox). From your screenshot, it looks like the .mpg is in the library, so this probably isn't the issue.
   
2. (most likely) - The path to your TV Shows directory in XBMC is different than the path you specified in the Config file. For example, one uses a network share and the other uses a local path. They have to be the same. I personally use a network share "\\onyx\\dropbox\\tvshows" in the config file, and in xbmc I set the source up as a smb path to the same directory.
   To troubleshoot this, can you post the contents of your sources.xml file (in XBMC's userdata directory) as well as your dropbox config in the Config.xml so I can compare.
   
3. The query to your SQL database to determine if the dummy .mpg files is in the library is failing. However we would see this in the logs as an ERROR and I don't think we've seen that.
   

bradvido88 Wrote:See my edited post above, it's a problem with me escaping backslashes in the query. In the meantime, you could try a smb share as those paths shouldn't have backslashes.

I'll post a fix (probably tomorrow but no guarantees)

bradvido88 Wrote:

1. Your dropbox\Tv Shows directory has not been added as a source in XBMC and had it's content type set to "TV Shows" (this should be done after some .mpg's exists in the dropbox). From your screenshot, it looks like the .mpg is in the library, so this probably isn't the issue.

Quote:

(most likely) - The path to your TV Shows directory in XBMC is different than the path you specified in the Config file. For example, one uses a network share and the other uses a local path. They have to be the same. I personally use a network share "\\onyx\\dropbox\\tvshows" in the config file, and in xbmc I set the source up as a smb path to the same directory.
To troubleshoot this, can you post the contents of your sources.xml file (in XBMC's userdata directory) as well as your dropbox config in the Config.xml so I can compare.

Quote:

The query to your SQL database to determine if the dummy .mpg files is in the library is failing. However we would see this in the logs as an ERROR and I don't think we've seen that.

Quote:As a disclaimer, my testing is limited to a Windows environment so things may be slightly different if your running a different OS