+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Windows (https://forum.kodi.tv/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)
- jmarshall - 2010-04-02
They're git patches. Grab patch from gnu and run it from the XBMC dir
patch -p1 < patch_file.patch
- charrua - 2010-04-03
jmarshall Wrote:They're git patches. Grab patch from gnu and run it from the XBMC dirThanks Jonathan. I grabbed patch for windows from GNU, copied the patch and patch.exe to XBMC folder and run patch -p1 < database_abstracted_prepare.patch from the XBMC dir, but it just opens a blank command window. Also tried installing TortoiseGIT but when I try to apply the patches it returns an error detecting the patch format. What am I doing wrong?
patch -p1 < patch_file.patch
- butterkitty - 2010-04-03
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
- charrua - 2010-04-03
charrua Wrote:Thanks Jonathan. I grabbed patch for windows from GNU, copied the patch and patch.exe to XBMC folder and run patch -p1 < database_abstracted_prepare.patch from the XBMC dir, but it just opens a blank command window. Also tried installing TortoiseGIT but when I try to apply the patches it returns an error detecting the patch format. What am I doing wrong?
I finally applied the patches successfully on svn r28988, but I'm getting errors on mysqldataset.cpp (lines 374 and 444) and sqlitedataset.cpp (line 364) when trying to compile. For error details please check: http://trac.xbmc.org/ticket/9022#comment:6
- michaelcdf - 2010-04-07
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 ?
- michaelcdf - 2010-04-07
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.
- charrua - 2010-04-07
michaelcdf Wrote:made some more test, and it appear that when i choose the set content, and choose any scrapper my settings doesn t get savedWhat revision of XBMC are you using?
when i go back to check the set content option it is empty.
- michaelcdf - 2010-04-07
i am using r28256
- charrua - 2010-04-07
michaelcdf Wrote:i am using r28256Check the strContent field of the path table to see if there are any values stored there. If not paste a XBMC log in debug mode to see if we can find the problem.
- michaelcdf - 2010-04-07
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.
- charrua - 2010-04-07
michaelcdf Wrote:this is what i haveSorry, I meant to check the content of that field for the defined source paths.
" strContent text latin1_swedish_ci "
I tested further, i can import my database just fine. And see the movies from there.
- michaelcdf - 2010-04-08
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.
Please Help- error 1050 - lestat1977uk - 2010-04-21
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>
- charrua - 2010-04-21
lestat1977uk Wrote:Any help would be great.
What XBMC revision do you have?
- lestat1977uk - 2010-04-21
it's SVN 28256