Posts: 26,215
Joined: Oct 2003
Reputation:
187
They're git patches. Grab patch from gnu and run it from the XBMC dir
patch -p1 < patch_file.patch
Posts: 16
Joined: Apr 2010
Reputation:
0
i used patch -p1 < file.patch....it went through and everything, but on compile it says that the file (svn_rev.h) is missing for some reason
Posts: 28
Joined: Mar 2009
Reputation:
0
hello
i have been setting up this system to try
but i have a problems;
xbmc is connecting to the mysql server and create the database
but i don t have the scan for new content on right clicking my movie folder.
If I start without the advancedsettings.xml file, I have the scan for new content option.
any idea ?
Posts: 28
Joined: Mar 2009
Reputation:
0
made some more test, and it appear that when i choose the set content, and choose any scrapper my settings doesn t get saved
when i go back to check the set content option it is empty.
Posts: 28
Joined: Mar 2009
Reputation:
0
this is what i have
" strContent text latin1_swedish_ci "
I tested further, i can import my database just fine. And see the movies from there.
Posts: 28
Joined: Mar 2009
Reputation:
0
Hello,
Well I solved the problem, I import my database, from a file. And I have everything now on the mysql serveR.
I can even launch the update.
Posts: 333
Joined: Jan 2009
Reputation:
1
2010-04-21, 23:14
(This post was last modified: 2010-04-21, 23:33 by lestat1977uk.)
Hi All
Can any of you help been trying to get this working but don't have the option to update library in XBMC, appears to be conecting to MYSQL but won't allow update.
here is an extract from the debug log and below my advanced settings.
Any help would be great.
22:07:43 T:1084 M:435949568 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>root</user>
<pass>Amedaus1</pass>
<name>XBMC_Video</name>
</videodatabase>
</advancedsettings>
22:07:43 T:1084 M:435941376 WARNING: VIDEO database configuration is experimental.
22:07:43 T:1084 M:435941376 NOTICE: Getting hardware information now...
22:07:43 T:1084 M:435941376 NOTICE: Checking resolution 12
22:07:43 T:1084 M:435941376 NOTICE: Default DVD Player: dvdplayer
22:07:43 T:1084 M:435937280 NOTICE: Default Video Player: dvdplayer
22:07:43 T:1084 M:435937280 NOTICE: Default Audio Player: paplayer
22:07:43 T:1084 M:435937280 NOTICE: Loading media sources from special://masterprofile/sources.xml
22:07:43 T:1084 M:414572544 NOTICE: initializing playlistplayer
22:07:43 T:1084 M:414572544 NOTICE: DONE initializing playlistplayer
22:07:43 T:1084 M:414560256 NOTICE: load default skin:[Confluence]
22:07:43 T:1084 M:406663168 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
22:07:43 T:1084 M:406626304 ERROR: CVideoDatabase::CreateTables unable to create tables:0
22:07:43 T:1084 M:406552576 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
22:07:43 T:1084 M:406540288 ERROR: CVideoDatabase::CreateTables unable to create tables:0
22:07:45 T:1084 M:402862080 NOTICE: initialize done
22:07:45 T:1084 M:402841600 NOTICE: Running the application...
22:07:45 T:1084 M:402731008 NOTICE: ES: Starting event server
22:07:45 T:5040 M:402616320 NOTICE: ES: Starting UDP Event server on 127.0.0.1:9777
22:07:45 T:5040 M:402489344 NOTICE: UDP: Listening on port 9777
22:07:45 T:1084 M:402833408 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
22:07:45 T:1084 M:402825216 ERROR: CVideoDatabase::CreateTables unable to create tables:0
22:07:49 T:1084 M:392855552 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
22:07:49 T:1084 M:392855552 ERROR: CVideoDatabase::CreateTables unable to create tables:0
22:07:52 T:1084 M:392159232 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
22:07:52 T:1084 M:392159232 ERROR: CVideoDatabase::CreateTables unable to create tables:0
22:07:52 T:1084 M:392159232 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\'
22:07:52 T:1084 M:392155136 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\')
22:07:52 T:1084 M:392155136 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate from path where strPath like 'F:\'
22:07:52 T:1084 M:392146944 ERROR: CVideoDatabase::GetScraperForPath failed
22:07:58 T:1084 M:385253376 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\'
22:07:58 T:1084 M:385253376 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\')
22:07:58 T:1084 M:385253376 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate from path where strPath like 'F:\'
22:07:58 T:1084 M:385253376 ERROR: CVideoDatabase::GetScraperForPath failed
22:07:58 T:1084 M:385253376 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\'
22:07:58 T:1084 M:385253376 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\')
22:07:58 T:1084 M:385249280 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate from path where strPath like 'F:\'
22:07:58 T:1084 M:385249280 ERROR: CVideoDatabase::GetScraperForPath failed
22:08:07 T:1084 M:384200704 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\'
22:08:07 T:1084 M:384200704 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\')
22:08:07 T:1084 M:384200704 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'F:\4 - Rise of the Silver Surfer (2007)\','','')
22:08:07 T:1084 M:384196608 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'F:\4 - Rise of the Silver Surfer (2007)\','',''))
22:08:08 T:1084 M:384405504 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
22:08:08 T:1084 M:384405504 ERROR: CVideoDatabase::CreateTables unable to create tables:0
22:08:08 T:1084 M:384405504 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\'
22:08:08 T:1084 M:384405504 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\')
22:08:08 T:1084 M:384405504 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate from path where strPath like 'F:\'
22:08:08 T:1084 M:384405504 ERROR: CVideoDatabase::GetScraperForPath failed
22:08:10 T:1084 M:384434176 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\'
22:08:10 T:1084 M:384434176 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\')
22:08:10 T:1084 M:384434176 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate from path where strPath like 'F:\'
22:08:10 T:1084 M:384434176 ERROR: CVideoDatabase::GetScraperForPath failed
22:08:10 T:1084 M:384434176 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\'
22:08:10 T:1084 M:384434176 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'F:\4 - Rise of the Silver Surfer (2007)\')
------------------------------------------
My settings
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>root</user>
<pass>*******</pass>
<name>XBMC_Video</name>
</videodatabase>
</advancedsettings>