Posts: 333
Joined: Jan 2009
Reputation:
1
i dropped the database but still get the error, i even tried created a new one with a different name, still same error
Posts: 333
Joined: Jan 2009
Reputation:
1
can you explain a little more im kind of new to mysql
Posts: 333
Joined: Jan 2009
Reputation:
1
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.strSettings,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.strSettings,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.strSettings,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
Posts: 333
Joined: Jan 2009
Reputation:
1
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.
Posts: 113
Joined: Mar 2008
Reputation:
0
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?
Posts: 1,546
Joined: Jun 2005
Reputation:
1
I can't believe I overlooked that. Thanks so much!