2 XBMC PCs and 1 Database on the shared NAS

2 XBMC PCs and 1 Database on the shared NAS - Printable Version

+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77

- charrua - 2010-03-31 15:09

rtrimarchi Wrote:I REALLY did not mean to say you were "wrong"....
Honestly ... I did NOT

Don't worry, I never thought you meant that (but I'm wrong lots of times anyway).

rtrimarchi Wrote:There is not doubt that here it's me the one who says "BS" due to my "ignorance"..... .... but I'm studing
Believe me also that I am reading the wiky portion on this whole subject.....

That's a good attitude and the whole point of my suggestion.

- firnsy - 2010-04-02 12:53

charrua Wrote:Reading your log, I think we've just found a bug in the MySQL functionality:
I don't have any local media sources in XBMC database, so I've never hit this error before, but it seems that the SQL for storing/querying local paths has a bug: it's trying to store the paths with "\" instead of "/" and for MySQL "\" is an special character, so it's returning a syntax error when trying to store a local path with that character. Note that network paths don't have that problem, because they are stored in the format "smb://NETWORK_ADDRESS/SHARED_PATH/".
I'll post this error in the developer's thread and see if he can fix it.
In the meantime you can try if you have any problems with networked paths, I guess you won't.

EDIT:
The bug was confirmed by firnsy(the developer of the XBMC MySQL feature) so I raised a bug report (ticket #9022), you can check its status here.

FYI, patches are now available against this bug for testing. I don't have Window's path's so can't fully test. Let me know, via the ticket, how it goes.

- charrua - 2010-04-02 17:09

firnsy Wrote:FYI, patches are now available against this bug for testing. I don't have Window's path's so can't full test. Let me know how via the ticket how it goes.

Thanks firnsy, I'll apply the patch ASAP and let you know if the issue is solved.

- butterkitty - 2010-04-02 22:37

i applied the patches (which didn't want to work with tortoisesvn) and tried to compile and it says it's missing a header file ... svn_rev.h

- charrua - 2010-04-02 23:08

butterkitty Wrote:i applied the patches (which didn't want to work with tortoisesvn) and tried to compile and it says it's missing a header file ... svn_rev.h

How did you apply them? I'm also having problems applying them with TortoiseSVN.

- jmarshall - 2010-04-02 23:24

They're git patches. Grab patch from gnu and run it from the XBMC dir

patch -p1 < patch_file.patch

- charrua - 2010-04-03 00:26

jmarshall Wrote:They're git patches. Grab patch from gnu and run it from the XBMC dir
patch -p1 < patch_file.patch

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?

- butterkitty - 2010-04-03 01:43

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 16:35

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 20:01

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 ?