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

+- 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)



- lestat1977uk - 2010-04-29

Hey guys, as i mentioned before video is working perfectly, however i've just moved onto doing music and getting same errors as before

I have tried creating database manually using the command

CREATE DATABASE XBMC_Music CHARACTER SET latin1 COLLATE latin1_general_ci;
(as per Charrua advice previously)

and i'm using a network path.

log below, any ideas?

01:37:42 T:1564 M:373137408 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>server2008</host>
<port>3306</port>
<user>root</user>
<pass>xbmc</pass>
<name>xbmc_movies</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>server2008</host>
<port>3306</port>
<user>root</user>
<pass>xbmc</pass>
<name>xbmc_Music</name>
</musicdatabase>
</advancedsettings>
01:37:42 T:1564 M:373125120 WARNING: VIDEO database configuration is experimental.
01:37:42 T:1564 M:373194752 NOTICE: Getting hardware information now...
01:37:42 T:1564 M:373194752 NOTICE: Checking resolution 11
01:37:42 T:1564 M:373194752 NOTICE: Default DVD Player: dvdplayer
01:37:42 T:1564 M:373194752 NOTICE: Default Video Player: dvdplayer
01:37:42 T:1564 M:373219328 NOTICE: Default Audio Player: paplayer
01:37:42 T:1564 M:373264384 NOTICE: Loading media sources from special://masterprofile/sources.xml
01:37:42 T:1564 M:373391360 ERROR: Missing or invalid <name> and/or <path> in source
01:37:43 T:1564 M:366252032 NOTICE: initializing playlistplayer
01:37:43 T:1564 M:366252032 NOTICE: DONE initializing playlistplayer
01:37:43 T:1564 M:366239744 NOTICE: load default skin:[Confluence]
01:37:44 T:1564 M:363491328 NOTICE: CApplication::UpdateLibraries - Starting video library startup scan
01:37:44 T:1564 M:363003904 NOTICE: CApplication::UpdateLibraries - Starting music library startup scan
01:37:44 T:1564 M:362749952 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
01:37:44 T:1564 M:362717184 ERROR: CMusicDatabase::CreateTables unable to create tables:0
01:37:44 T:1564 M:362696704 NOTICE: initialize done
01:37:44 T:1564 M:362696704 NOTICE: Running the application...
01:37:44 T:1564 M:362622976 NOTICE: Webserver: Starting...
01:37:44 T:1564 M:362577920 NOTICE: WebServer: Started the webserver
01:37:44 T:1564 M:362569728 NOTICE: starting upnp renderer
01:37:44 T:5580 M:362401792 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
01:37:44 T:5580 M:362389504 ERROR: CMusicDatabase::CreateTables unable to create tables:0
01:37:44 T:5580 M:362123264 NOTICE: My Music: Scanning for music info using worker thread, operation took 00:00
01:37:44 T:1564 M:361897984 NOTICE: ES: Starting event server
01:37:44 T:5528 M:361693184 NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777
01:37:44 T:5528 M:361689088 NOTICE: UDP: Listening on port 9777
01:37:44 T:1564 M:360304640 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
01:37:44 T:1564 M:360296448 ERROR: CMusicDatabase::CreateTables unable to create tables:0
01:37:44 T:1564 M:360247296 ERROR: SQL: The table does not exist
Query: select count(idSong) as NumSongs from songview
01:37:44 T:1564 M:360247296 ERROR: CMusicDatabase::GetSongsCount() failed
01:37:45 T:5484 M:350027776 NOTICE: -->Python Interpreter Initialized<--
01:37:53 T:4856 M:363474944 NOTICE: My Videos: Scanning for video info using worker thread, operation took 00:08
01:38:39 T:5960 M:365826048 NOTICE: -->Python Interpreter Initialized<--
01:38:42 T:1564 M:364429312 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
01:38:42 T:1564 M:364429312 ERROR: CMusicDatabase::CreateTables unable to create tables:0
01:39:07 T:5160 M:380473344 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
01:39:07 T:5160 M:380465152 ERROR: CMusicDatabase::CreateTables unable to create tables:0
01:39:07 T:5160 M:381022208 ERROR: SQL: The table does not exist
Query: select * from songview where strPath like 'smb://Administrator:******@server2008/Music & Music Video/Artists Complete/'
01:39:07 T:5160 M:381001728 ERROR: CMusicDatabase::RemoveSongsFromPath (smb://Administrator:******@server2008/Music & Music Video/Artists Complete/) failed
01:39:07 T:5160 M:381022208 ERROR: SQL: The table does not exist
Query: select count(idSong) as NumSongs from songview
01:39:07 T:5160 M:381022208 ERROR: CMusicDatabase::GetSongsCount() failed
01:39:07 T:5160 M:381132800 ERROR: SQL: The table does not exist
Query: select * from songview where strPath like 'smb://Administrator:********@server2008/Music & Music Video/Artists Complete/2 Ulimited/'
01:39:07 T:5160 M:381132800 ERROR: CMusicDatabase::RemoveSongsFromPath (smb://Administrator:********@server2008/Music & Music Video/Artists Complete/2 Ulimited/) failed
01:39:07 T:5160 M:381132800 ERROR: SQL: The table does not exist
Query: select count(idSong) as NumSongs from songview
01:39:07 T:5160 M:381132800 ERROR: CMusicDatabase::GetSongsCount() failed
01:39:07 T:5160 M:381132800 ERROR: SQL: The table does not exist
Query: select * from songview where strPath like 'smb://Administrator:********@server2008/Music & Music Video/Artists Complete/2 Ulimited/Get Ready/'
01:39:07 T:5160 M:381132800 ERROR: CMusicDatabase::RemoveSongsFromPath (smb://Administrator:********@server2008/Music & Music Video/Artists Complete/2 Ulimited/Get Ready/) failed
01:39:08 T:5160 M:380624896 ERROR: SQL: The table does not exist
Query: select count(idSong) as NumSongs from songview
01:39:08 T:5160 M:380624896 ERROR: CMusicDatabase::GetSongsCount() failed
01:39:08 T:4448 M:380485632 ERROR: XFILE::CFile:Big Grinelete - Error deleting file C:\Program Files (x86)\XBMC\cache\scrapers\tvdb.xml\
01:39:08 T:4448 M:380485632 ERROR: XFILE::CFile:Big Grinelete - Error deleting file special://temp/scrapers/tvdb.xml/
01:39:16 T:644 M:386736128 ERROR: XFILE::CFile:Big Grinelete - Error deleting file C:\Program Files (x86)\XBMC\cache\scrapers\tvdb.xml\
01:39:16 T:644 M:386736128 ERROR: XFILE::CFile:Big Grinelete - Error deleting file special://temp/scrapers/tvdb.xml/


- charrua - 2010-04-29

lestat1977uk Wrote:I have tried creating database manually using the command
CREATE DATABASE XBMC_Music CHARACTER SET latin1 COLLATE latin1_general_ci;
(as per Charrua advice previously)
and i'm using a network path.
log below, any ideas?
I think that the db name is case sensitive, try using exactly the same name in the advancedsettings.xml than the db name you've created (e.g. XBMC_Music)
Or even better, use only lowercase in both.


- lestat1977uk - 2010-04-29

Hi Mate

I tried that but no joy, any other ideas?


- charrua - 2010-04-29

lestat1977uk Wrote:Hi Mate
I tried that but no joy, any other ideas?
Did you drop the old database, created a new one all lowercased (e.g. xbmc_music) and then modify the advancedsettings to reflect the same db name and still no luck? Could you post your debug log? (use pastebin.com instead of pasting directly here)


- lestat1977uk - 2010-04-29

Hi Mate

Yes i did tried several times, Video is working really well (thanks so much for your help) and i'm even using the symbolic trick for all thumbs and that works very well indded now that i have a gigabyte network.

So this is the last hurdle Smile

paste bin below

http://pastebin.com/N7jwib0Z


- charrua - 2010-04-29

lestat1977uk Wrote:Hi Mate
Yes i did tried several times, Video is working really well now even used the symbolic trick for all thumbs and works really well (thanks so much for your help) over gigabyte network (just got gigabyte switch) so this is the last hurdle Smile
paste bin below
http://pastebin.com/N7jwib0Z
Congrats on the video db part (and on the gigabit upgrade).
Regarding the log, please activate debug mode in XBMC restart and paste the new log (with debug info on).


- lestat1977uk - 2010-04-29

Fair play , will do that now


- lestat1977uk - 2010-04-29

http://pastebin.com/bvZHkhER


- charrua - 2010-04-29

lestat1977uk Wrote:http://pastebin.com/bvZHkhER
It seems that you've solved part of the problem by changing the db name to lowercase (see that you no longer have errors code 1050 as you had before), the problem now seems to be that songview wasn't created on xbmc_music db. When you created the new xbmc_music (all lowercased) did you remember to also define it as CHARACTER SET latin1 COLLATE latin1_general_ci?


- lestat1977uk - 2010-04-29

i used the following command

CREATE DATABASE xbmc_music CHARACTER SET latin1 COLLATE latin1_general_ci;

The command above is the one that fixed my problem with Video database so i really don't understand it, am i missing something?


- charrua - 2010-04-29

lestat1977uk Wrote:i used the following command
CREATE DATABASE xbmc_music CHARACTER SET latin1 COLLATE latin1_general_ci;
The command above is the one that fixed my problem with Video database so i really don't understand it, am i missing something?
For what I can see in the last log you posted, your xbmc_music db is missing a view named songview, you can try this:
-delete again the xbmc_music db
-create it again using the same command you posted
-open XBMC
-paste the log again in pastebin and post it here
That way we'll be able to see the debug info for the db creation process.


- lestat1977uk - 2010-04-29

ok will do that right now


- lestat1977uk - 2010-04-29

Sorry for the delay am at work and had to wait until i had a second to breathe Smile

http://pastebin.com/Hzut8M5D


- charrua - 2010-04-29

lestat1977uk Wrote:Sorry for the delay am at work and had to wait until i had a second to breathe Smile
http://pastebin.com/Hzut8M5D
Same here Smile
It is a privileges problem: MySQL error code 1142 while trying to create a trigger. Make sure user root have full permissions on the db (the privilege that allows you to drop/create triggers is SUPER).


- lestat1977uk - 2010-04-29

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?