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-22 00:19

There are two different kinds of SQL related errors in your log:

1064: In your case this is due to a bug already reported but not solved yet.
(and already commented earlier in this thread, read back for more info)

1050: This error is XBMC trying to create some tables that are already present in the MySQL database. Try droping the XBMC_Video database in your MySQL server and the run XBMC again to see what happens.

- lestat1977uk - 2010-04-22 00:52

i dropped the database but still get the error, i even tried created a new one with a different name, still same error

- charrua - 2010-04-22 01:29

lestat1977uk Wrote:i dropped the database but still get the error, i even tried created a new one with a different name, still same error
Did you set the db collation to latin1 instead of utf8?
(as suggested in some of my previous posts)

- lestat1977uk - 2010-04-22 01:31

can you explain a little more im kind of new to mysql

- charrua - 2010-04-22 01:43

lestat1977uk Wrote:can you explain a little more im kind of new to mysql
Yes, drop the XBMC_Video database, then create a new one manually executing the following sql statement:

Code:
CREATE DATABASE XBMC_Video CHARACTER SET latin1 COLLATE latin1_general_ci;
Then run XBMC.

- lestat1977uk - 2010-04-22 02:05

still having problems


01:01:14 T:2240 M:507654144 NOTICE: Loaded advancedsettings.xml from special://profile/advancedsettings.xml
01:01:14 T:2240 M:507654144 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>
</advancedsettings>
01:01:14 T:2240 M:507650048 WARNING: VIDEO database configuration is experimental.
01:01:14 T:2240 M:507650048 NOTICE: Getting hardware information now...
01:01:14 T:2240 M:507650048 NOTICE: Checking resolution 12
01:01:14 T:2240 M:507650048 NOTICE: Default DVD Player: dvdplayer
01:01:14 T:2240 M:507650048 NOTICE: Default Video Player: dvdplayer
01:01:14 T:2240 M:507650048 NOTICE: Default Audio Player: paplayer
01:01:14 T:2240 M:507650048 NOTICE: Loading media sources from special://masterprofile/profiles/SQL/sources.xml
01:01:15 T:2240 M:514646016 WARNING: CGUITextureManager::Cleanup: Having to cleanup texture MenuItemNF.png
01:01:15 T:2240 M:514646016 WARNING: CGUITextureManager::Cleanup: Having to cleanup texture unknown-user.png
01:01:15 T:2240 M:514646016 WARNING: CGUITextureManager::Cleanup: Having to cleanup texture MenuItemFO.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemNF.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture unknown-user.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemNF.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemFO.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture unknown-user.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemNF.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture unknown-user.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemNF.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture MenuItemFO.png
01:01:41 T:2240 M:496656384 WARNING: CGUITextureManager::ReleaseTexture: Unable to release texture unknown-user.png
01:01:41 T:2240 M:496484352 NOTICE: ES: Starting event server
01:01:41 T:5068 M:496259072 NOTICE: ES: Starting UDP Event server on 127.0.0.1:9777
01:01:41 T:5068 M:496246784 NOTICE: UDP: Listening on port 9777
01:02:27 T:2240 M:520585216 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\'
01:02:28 T:2240 M:520556544 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\')
01:02:28 T:2240 M:520556544 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strS​ettings,path.noUpdate from path where strPath like 'H:\'
01:02:28 T:2240 M:520548352 ERROR: CVideoDatabase::GetScraperForPath failed
01:02:40 T:2240 M:521121792 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\'
01:02:40 T:2240 M:521121792 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\')
01:02:40 T:2240 M:521121792 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'H:\Hellboy II - The Golden Army (2008)\','','')
01:02:40 T:2240 M:521121792 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'H:\Hellboy II - The Golden Army (2008)\','',''))
01:02:41 T:3888 M:521334784 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\'
01:02:41 T:3888 M:521330688 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\')
01:02:41 T:3888 M:521322496 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strS​ettings,path.noUpdate from path where strPath like 'H:\'
01:02:41 T:3888 M:521322496 ERROR: CVideoDatabase::GetScraperForPath failed
01:02:41 T:3888 M:521322496 NOTICE: My Videos: Scanning for video info using worker thread, operation took 00:00
01:02:44 T:2240 M:521121792 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\'
01:02:44 T:2240 M:521121792 ERROR: CVideoDatabase::GetPathId unable to getpath (select idPath from path where strPath like 'H:\Hellboy II - The Golden Army (2008)\')
01:02:44 T:2240 M:521121792 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strS​ettings,path.noUpdate from path where strPath like 'H:\'
01:02:44 T:2240 M:521121792 ERROR: CVideoDatabase::GetScraperForPath failed
01:02:49 T:2240 M:523759616 NOTICE: Storing total System Uptime
01:02:49 T:2240 M:523759616 NOTICE: Saving settings
01:02:49 T:2240 M:523706368 NOTICE: stop all
01:02:49 T:2240 M:523706368 NOTICE: ES: Stopping event server
01:02:49 T:5068 M:523747328 NOTICE: ES: UDP Event server stopped
01:02:49 T:2240 M:523812864 NOTICE: stop sap announcement listener
01:02:49 T:2240 M:523812864 NOTICE: clean cached files!
01:02:49 T:2240 M:523800576 NOTICE: unload skin
01:02:49 T:2240 M:526086144 NOTICE: stop python
01:02:49 T:2240 M:526086144 NOTICE: stopped
01:02:49 T:2240 M:526086144 NOTICE: destroy
01:02:50 T:2240 M:526045184 NOTICE: unload sections

- charrua - 2010-04-22 02:23

lestat1977uk Wrote:still having problems
As I told you before, you had two kind of errors in the first log you posted:

errors 1050: SOLVED by changing db collation from utf8 to latin1 (check that you don't have (1050) errors anymore in your log)

errors 1064: due to a bug related to storage of local paths that I already reported some time ago and it is still unsolved. For more info about the bug and my proposed temporary solution check here: http://trac.xbmc.org/ticket/9022

- lestat1977uk - 2010-04-22 02:49

ah ok.

Well thanks for the help, i hope the bug gets sorted cause until then it seems i won't be bale to set this up.

- charrua - 2010-04-22 02:56

lestat1977uk Wrote:ah ok.
Well thanks for the help, i hope the bug gets sorted cause until then it seems i won't be bale to set this up.
You're welcome. While the bug is not solved yet, you can try to solve the problem as I suggested in the last comment of the bug report:
Quote:...for anyone dealing with this bug right now, the solution that I see to add local paths without errors (under windows environments) is to share the path in the network first, and then choose it as a source in XBMC using its networked path instead of the local one. It's not a sophisticated solution but it should work fine. That being said, I really look forward to the upcoming db redesign.
Let me know if that helped.

- WisdomWolf - 2010-04-22 03:54

I am going to look into this when I get home. Previously I had been using Sugarsync to sync the Database folder as well as the Thumnail folder. I would assume (if the thumbnail/coverart issue still exists) that the MySQL route + Sugarsync for the Thumbnail directory would work a bit more elegantly than my current solution. Am I correct?