Help troubleshooting MySQL

zacnelson0628 · 2012-07-18 08:46

I have been using XBMC for a few months now and I love it! I decided to add another HTPC to my home network, everything was working great. So, I decided to do some research on how to "Sync" my libraries and I found out how to use mySQL. Well, I followed the instructions to the T and for some reason my video library does not show up as a database. The music database shows up but I don't even have any music on them. Everything is stored on my server and I just don't understand what is going on! I have tried about 3 times now and the video database just won't show up! I am ready to pull my hair out! Angry

bossanova808 · 2012-07-18 08:51

Debug log!! http://wiki.xbmc.org/index.php?title=Debug_log

zacnelson0628 · 2012-07-18 08:55

(2012-07-18 08:51)bossanova808 Wrote: Debug log!! http://wiki.xbmc.org/index.php?title=Debug_log

Okay, I enabled it. So do I run another scan or what? How would I trigger the write to the log?

I do apologize Like I said I am quite new to this. haha

bossanova808 · 2012-07-18 08:55

Or put more nicely - you'll need to provide a lot more info to get meaningful help...

Yeah ok - enable debugging, re-start XBMC, maybe trigger a library update for videos, the pastebin the resulting xbmc.log (as in the wiki link above).

Maybe try reading it first as it will likely point out the issue pretty quickly....

zacnelson0628 · 2012-07-18 09:04

(2012-07-18 08:55)bossanova808 Wrote: Or put more nicely - you'll need to provide a lot more info to get meaningful help...
Yeah ok - enable debugging, re-start XBMC, maybe trigger a library update for videos, the pastebin the resulting xbmc.log (as in the wiki link above).

Maybe try reading it first as it will likely point out the issue pretty quickly....

Got it! I couldn't find it for a minute.

[quote02:57:54 T:288 NOTICE: -----------------------------------------------------------------------
02:57:54 T:288 NOTICE: Starting XBMC (11.0 Git:20120321-14feb09), Platform: Windows 7, 32-bit Service Pack 1 build 7601. Built on Mar 21 2012 (compiler 1600)
02:57:54 T:288 NOTICE: Intel® Core™2 Duo CPU T5800 @ 2.00GHz
02:57:54 T:288 NOTICE: Desktop Resolution: 1920x1080 32Bit at 60Hz
02:57:54 T:288 NOTICE: Running with administrator rights
02:57:54 T:288 NOTICE: Aero is disabled
02:57:54 T:288 NOTICE: special://xbmc/ is mapped to: C:\Program Files\XBMC
02:57:54 T:288 NOTICE: special://xbmcbin/ is mapped to: C:\Program Files\XBMC
02:57:54 T:288 NOTICE: special://masterprofile/ is mapped to: C:\Users\XBMC BEDROOM\AppData\Roaming\XBMC\userdata
02:57:54 T:288 NOTICE: special://home/ is mapped to: C:\Users\XBMC BEDROOM\AppData\Roaming\XBMC\
02:57:54 T:288 NOTICE: special://temp/ is mapped to: C:\Users\XBMC BEDROOM\AppData\Roaming\XBMC\cache
02:57:54 T:288 NOTICE: The executable running is: C:\Program Files\XBMC\XBMC.exe
02:57:54 T:288 NOTICE: Local hostname: XBMCBEDROOM
02:57:54 T:288 NOTICE: Log File is located: C:\Users\XBMC BEDROOM\AppData\Roaming\XBMC\xbmc.log
02:57:54 T:288 NOTICE: -----------------------------------------------------------------------
02:57:54 T:288 NOTICE: Setup SDL
02:57:54 T:288 NOTICE: Found screen: Generic PnP Monitor on Mobile Intel® 965 Express Chipset Family, adapter 0.
02:57:54 T:288 NOTICE: Primary mode: 1920x1080 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 320x200 @ 70.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 320x240 @ 70.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 400x300 @ 70.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 512x384 @ 70.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 640x400 @ 70.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 640x480 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 640x480 @ 70.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 640x480 @ 73.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 640x480 @ 75.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 720x480 @ 59.94 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 720x480 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 720x576 @ 50.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 800x600 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 800x600 @ 72.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 800x600 @ 75.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1024x768 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1024x768 @ 70.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1024x768 @ 75.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1152x864 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1280x600 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1280x720 @ 50.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1280x720 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1280x768 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1280x960 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1280x1024 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1400x1050 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1600x900 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1680x1050 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1920x1080 @ 50.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1920x1080 @ 25.00i - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1920x1080 @ 60.00 - Full Screen
02:57:54 T:288 NOTICE: Additional mode: 1920x1080 @ 30.00i - Full Screen
02:57:54 T:288 NOTICE: load settings...
02:57:54 T:288 NOTICE: special://profile/ is mapped to: special://masterprofile/profiles/main/
02:57:54 T:288 NOTICE: loading special://profile/guisettings.xml
02:57:54 T:288 ERROR: special://profile/guisettings.xml, Line 0
Failed to open file
02:57:54 T:288 ERROR: Unable to load special://profile/guisettings.xml, creating new special://profile/guisettings.xml with default values
02:57:54 T:288 ERROR: Unable to save settings to special://profile/guisettings.xml
02:57:54 T:288 ERROR: special://profile/guisettings.xml, Line 0
Failed to open file
[/quote]

bossanova808 · 2012-07-18 09:18

ok - pastebin.com the whole thing please.

zacnelson0628 · 2012-07-18 09:26

http://pastebin.com/raw.php?i=MrF8qL2p

http://pastebin.com/MrF8qL2p

My apologies for being the n00b. I got it to show up now in mySQL. Hopefully this will work now! Thanks for your understanding. Big Grin

bossanova808 Member+ Posts: 1,532 Joined: Sep 2009 Reputation: 20 Location: Melbourne, Australia	2012-07-18 08:51 Post: #2 Debug log!! http://wiki.xbmc.org/index.php?title=Debug_log My XBMC stuff: ...inc: My Addons: XSqueeze - Squeezebox for XBMC, XZen - Zenfolio for XBMC and OzWeather - weather with Australian BOM data & radars Notes on my fanless, silent, powerful XBMC build Get Win7 to run RemoteApps
	find quote

zacnelson0628 Junior Member Posts: 4 Joined: Jul 2012 Reputation: 0	2012-07-18 08:55 Post: #3 (2012-07-18 08:51)bossanova808 Wrote: Debug log!! http://wiki.xbmc.org/index.php?title=Debug_log Okay, I enabled it. So do I run another scan or what? How would I trigger the write to the log? I do apologize Like I said I am quite new to this. haha
	find quote

bossanova808 Member+ Posts: 1,532 Joined: Sep 2009 Reputation: 20 Location: Melbourne, Australia	2012-07-18 09:18 Post: #6 ok - pastebin.com the whole thing please. My XBMC stuff: ...inc: My Addons: XSqueeze - Squeezebox for XBMC, XZen - Zenfolio for XBMC and OzWeather - weather with Australian BOM data & radars Notes on my fanless, silent, powerful XBMC build Get Win7 to run RemoteApps
	find quote

zacnelson0628 Junior Member Posts: 4 Joined: Jul 2012 Reputation: 0	2012-07-18 09:26 Post: #7 http://pastebin.com/raw.php?i=MrF8qL2p http://pastebin.com/MrF8qL2p My apologies for being the n00b. I got it to show up now in mySQL. Hopefully this will work now! Thanks for your understanding. (This post was last modified: 2012-07-18 09:29 by zacnelson0628.)
	find quote