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
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
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)
http://dl.dropbox.com/u/3154799/XBMC.MyLibrary.log