Win MySQL
#1
Hay everyone it took me ages to fix the MySQL setup yeh its not hard but i did a few misstakes witch was that my advancedsettings was named advancedsettings.xml.xml that was relly funny as Windows hides the names for know filetypes witch i not thinked about!

Anyways to my question i have it setup it create the tables just fine, but when i do "set content" and then try to "scrape" a movie it ignores it and nothing happens i try to do it on a clean XBMC and it not worked

Just for you ppl to noice if i export my media db and import it it inserts it to mySQL just fine and i can also tell that i run it whit "-p" so portable mode but i don´t see why that shuld make any diffrent

/ Anton
Reply
#2
Maybe i got more answers if i post some debug information

Quote:14:02:55 T:5568 NOTICE: -----------------------------------------------------------------------
14:02:55 T:5568 NOTICE: Starting XBMC (11.0 Git:20120321-14feb09), Platform: Windows 7, 64-bit (WoW) Service Pack 1 build 7601. Built on Mar 21 2012 (compiler 1600)
14:02:55 T:5568 NOTICE: Intel® Core™ i7-2720QM CPU @ 2.20GHz
14:02:55 T:5568 NOTICE: Desktop Resolution: 1920x1080 32Bit at 60Hz
14:02:55 T:5568 NOTICE: Running with administrator rights
14:02:55 T:5568 NOTICE: Aero is disabled
14:02:55 T:5568 NOTICE: special://xbmc/ is mapped to: C:\Program Files (x86)\XBMC
14:02:55 T:5568 NOTICE: special://xbmcbin/ is mapped to: C:\Program Files (x86)\XBMC
14:02:55 T:5568 NOTICE: special://masterprofile/ is mapped to: C:\Program Files (x86)\XBMC\portable_data\userdata
14:02:55 T:5568 NOTICE: special://home/ is mapped to: C:\Program Files (x86)\XBMC\portable_data\
14:02:55 T:5568 NOTICE: special://temp/ is mapped to: C:\Program Files (x86)\XBMC\portable_data\cache
14:02:55 T:5568 NOTICE: The executable running is: C:\Program Files (x86)\XBMC\XBMC.exe
14:02:55 T:5568 NOTICE: Local hostname: Anton-Laptop
14:02:55 T:5568 NOTICE: Log File is located: C:\Program Files (x86)\XBMC\portable_data\xbmc.log
14:02:55 T:5568 NOTICE: -----------------------------------------------------------------------
14:02:55 T:5568 NOTICE: Setup SDL
14:02:55 T:5568 NOTICE: Found screen: Allm�n PnP-bildsk�rm on AMD Radeon HD 6870M, adapter 2.
14:02:55 T:5568 NOTICE: Primary mode: 1920x1080 @ 60.00 - Full Screen
14:02:55 T:5568 NOTICE: Additional mode: 640x480 @ 40.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 640x480 @ 60.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 800x600 @ 40.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 800x600 @ 60.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1024x768 @ 40.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1024x768 @ 60.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1280x720 @ 40.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1280x720 @ 60.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1280x1024 @ 40.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1280x1024 @ 60.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1600x900 @ 40.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1600x900 @ 60.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1680x1050 @ 40.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1680x1050 @ 60.00 - Full Screen
14:02:55 T:5568 NOTICE: Previous line repeats 2 times.
14:02:55 T:5568 NOTICE: Additional mode: 1920x1080 @ 40.00 - Full Screen
14:02:55 T:5568 NOTICE: Additional mode: 1920x1080 @ 60.00 - Full Screen
14:02:55 T:5568 NOTICE: load settings...
14:02:55 T:5568 NOTICE: special://profile/ is mapped to: special://masterprofile/
14:02:55 T:5568 NOTICE: loading special://masterprofile/guisettings.xml
14:02:55 T:5568 NOTICE: Getting hardware information now...
14:02:55 T:5568 NOTICE: Checking resolution 12
14:02:55 T:5568 NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
14:02:55 T:5568 NOTICE: Loaded playercorefactory configuration
14:02:55 T:5568 NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
14:02:55 T:5568 NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
14:02:55 T:5568 NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
14:02:55 T:5568 NOTICE: Loaded settings file from special://profile/advancedsettings.xml
14:02:55 T:5568 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.65</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.65</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
</advancedsettings>
14:02:55 T:5568 WARNING: VIDEO database configuration is experimental.
14:02:55 T:5568 NOTICE: Getting hardware information now...
14:02:55 T:5568 NOTICE: Checking resolution 12
14:02:55 T:5568 NOTICE: Default DVD Player: dvdplayer
14:02:55 T:5568 NOTICE: Default Video Player: dvdplayer
14:02:55 T:5568 NOTICE: Default Audio Player: paplayer
14:02:55 T:5568 NOTICE: Disabled debug logging due to GUI setting. Level 0.
14:02:55 T:5568 NOTICE: Log level changed to 0
14:02:55 T:5568 NOTICE: Loading media sources from special://masterprofile/sources.xml
14:02:56 T:5568 NOTICE: initializing playlistplayer
14:02:56 T:5568 NOTICE: DONE initializing playlistplayer
14:02:56 T:5568 NOTICE: initialize done
14:02:56 T:5568 NOTICE: Running the application...
14:02:56 T:5568 NOTICE: ES: Starting event server
14:02:56 T:2392 NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777
14:02:56 T:2392 NOTICE: UDP: Listening on port 9777
14:02:56 T:5404 NOTICE: -->Python Interpreter Initialized<--
14:02:57 T:5844 ERROR: CRemoteControl::Connect - failed to connect
14:03:25 T:5568 ERROR: SQL: Undefined MySQL error: Code (1062)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'E:\\Filmer\\XviD\\A.Beautiful.Mind.2001.DVDRiP.SweSub-MrKeff\\','','')
14:03:25 T:5568 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'E:\\Filmer\\XviD\\A.Beautiful.Mind.2001.DVDRiP.SweSub-MrKeff\\','',''))
14:03:25 T:6588 NOTICE: VideoInfoScanner: Starting scan ..
14:03:25 T:6588 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
14:03:30 T:5568 NOTICE: Storing total System Uptime
14:03:30 T:5568 NOTICE: Saving settings
14:03:30 T:5568 NOTICE: stop all
14:03:30 T:5568 NOTICE: ES: Stopping event server
14:03:30 T:5568 NOTICE: stopping zeroconf publishing
14:03:30 T:2392 NOTICE: ES: UDP Event server stopped
14:03:30 T:5568 NOTICE: stop sap announcement listener
14:03:30 T:5568 NOTICE: clean cached files!
14:03:30 T:5568 NOTICE: unload skin
14:03:30 T:5568 NOTICE: stop python
14:03:31 T:5568 NOTICE: stopped
14:03:31 T:5568 NOTICE: destroy
14:03:31 T:5568 NOTICE: closing down remote control service
14:03:32 T:5568 NOTICE: unload sections
14:03:32 T:5568 NOTICE: destroy
14:03:32 T:5568 WARNING: Attempted to remove window 10013 from the window manager when it didn't exist
14:03:32 T:5568 WARNING: Attempted to remove window 10014 from the window manager when it didn't exist
14:03:32 T:5568 WARNING: Attempted to remove window 10015 from the window manager when it didn't exist
14:03:32 T:5568 WARNING: Attempted to remove window 10016 from the window manager when it didn't exist
14:03:32 T:5568 WARNING: Attempted to remove window 10017 from the window manager when it didn't exist
14:03:32 T:5568 WARNING: Attempted to remove window 10018 from the window manager when it didn't exist
14:03:32 T:5568 WARNING: Attempted to remove window 10019 from the window manager when it didn't exist
14:03:32 T:5568 WARNING: Attempted to remove window 10107 from the window manager when it didn't exist
14:03:32 T:5568 WARNING: Attempted to remove window 10115 from the window manager when it didn't exist
14:03:32 T:5568 WARNING: Attempted to remove window 10104 from the window manager when it didn't exist
14:03:32 T:5568 NOTICE: closing down remote control service
14:03:32 T:5568 NOTICE: unload sections
14:03:32 T:5568 NOTICE: application stopped...
Reply
#3
Did a quick search for SQL: Undefined MySQL error: Code (1062) and found the thread
http://forum.xbmc.org/showthread.php?tid=123266


From that thread it would appear that you need to use the UNC path to the media, whereas you seem to be using the local path (E:\\Filmer\)

Reply
#4
The wiki MySQL (wiki) guide has a quick fix for that using pathsubs.
Reply
#5
(2012-05-23, 04:31)Ned Scott Wrote: The wiki MySQL (wiki) guide has a quick fix for that using pathsubs.

Was esyer to just use it over FTP, Anyways thx for the noice its work fine now Smile

/ Anton
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL0