XBMC Community Forum
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-04-29 21:40

lestat1977uk Wrote:its the root shouldn't it have everything, ah Super i remember that bad boy from my Ubuntu days, how do i add the extra permission levels?
Yes, it should. You can check it with:
Code:
SHOW GRANTS FOR root;


- hermy65 - 2010-04-29 23:05

Im going to be switching to a centralized database. My question is this, currently all of my videos (tv,movies) are stored on 3 drives locally on my main xbmc box. Im going to be moving everything to my new server so i can stream content to my other xbmc clients. My question is this, when i export my library, then move all of my media to my server and then re-import my library is it going to be messed up since the path of the videos has changed?

- lestat1977uk - 2010-04-29 23:31

yep it has super, hmmm

- RockDawg - 2010-04-30 01:59

hermy65 Wrote:Im going to be switching to a centralized database. My question is this, currently all of my videos (tv,movies) are stored on 3 drives locally on my main xbmc box. Im going to be moving everything to my new server so i can stream content to my other xbmc clients. My question is this, when i export my library, then move all of my media to my server and then re-import my library is it going to be messed up since the path of the videos has changed?

If the paths are different then yes. But what you could do relatively easily though is export your library, then open that file in a text editor and do a "find and replace" on the portion of the text string for the path that will change.

- lestat1977uk - 2010-04-30 10:16

It has the Super permission levels, any other thoughts on this??

- charrua - 2010-04-30 10:26

lestat1977uk Wrote:It has the Super permission levels, any other thoughts on this??
Try to create the trigger that was returning the error from MySQL command line and see what happens (look for the trigger creation command in the last log you've posted).

- lestat1977uk - 2010-04-30 11:01

how do you mean, sorry i'm still finding my feet with mysql

- charrua - 2010-04-30 11:11

lestat1977uk Wrote:how do you mean, sorry i'm still finding my feet with mysql
The same way you runned previous MySQL commands (e.g. the SHOW GRANTS, the CREATE DATABASE, etc.) run the command:

Code:
CREATE TRIGGER tgrAlbumInfo AFTER delete ON albuminfo FOR EACH ROW BEGIN delete from albuminfosong where albuminfosong.idAlbumInfo=old.idAlbumInfo;

To see if it returns the same error than it returns when XBMC tries to create the trigger.

- lestat1977uk - 2010-04-30 13:23

I get error 1064 when i do that?

mysql> select xbmc_music;
ERROR 1054 (42S22): Unknown column 'xbmc_music' in 'field list'
mysql> use xbmc_music;
Database changed
mysql> CREATE TRIGGER tgrAlbumInfo AFTER delete ON albuminfo FOR EACH ROW BEGIN
delete from albuminfosong where albuminfosong.idAlbumInfo=old.idAlbumInfo;
ERROR 1064 (42000): 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 '' at
line 1
mysql>

- charrua - 2010-04-30 14:18

lestat1977uk Wrote:I get error 1064 when i do that?

Code:
DELIMITER //
USE xbmc_music
CREATE TRIGGER tgrAlbumInfo AFTER delete ON albuminfo FOR EACH ROW BEGIN  delete from albuminfosong where  albuminfosong.idAlbumInfo=old.idAlbumInfo; END//