[Firedog]

I can "see" the error but dont know how to fix it.

my SQL database looks like this:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| xbmc_music |
| xbmc_video |
+--------------------+
5 rows in set (0.00 sec)



and my Log from XBMC is looking like this:

Code:

22:41:57 T:2424  NOTICE: -----------------------------------------------------------------------
22:41:57 T:2424  NOTICE: Starting XBMC, Platform: Windows 7, 64-bit (WoW) Service Pack 1 build 7601. Built on Oct 26 2011 (Git:20111025-cfa1a05, compiler 1600)
22:41:57 T:2424  NOTICE: AMD Phenom(tm) 9350e Quad-Core Processor
22:41:57 T:2424  NOTICE: Desktop Resolution: 1024x768 32Bit at 60Hz
22:41:57 T:2424  NOTICE: Running with administrator rights
22:41:57 T:2424  NOTICE: Aero is disabled
22:41:57 T:2424  NOTICE: special://xbmc/ is mapped to: C:\Program Files (x86)\XBMC
22:41:57 T:2424  NOTICE: special://xbmcbin/ is mapped to: C:\Program Files (x86)\XBMC
22:41:57 T:2424  NOTICE: special://masterprofile/ is mapped to: C:\Users\HTPC\AppData\Roaming\XBMC\userdata
22:41:57 T:2424  NOTICE: special://home/ is mapped to: C:\Users\HTPC\AppData\Roaming\XBMC
22:41:57 T:2424  NOTICE: special://temp/ is mapped to: C:\Users\HTPC\AppData\Roaming\XBMC\cache
22:41:57 T:2424  NOTICE: The executable running is: C:\Program Files (x86)\XBMC\XBMC.exe
22:41:57 T:2424  NOTICE: Log File is located: C:\Users\HTPC\AppData\Roaming\XBMC\xbmc.log
22:41:57 T:2424  NOTICE: -----------------------------------------------------------------------
22:41:57 T:2424  NOTICE: Setup SDL
22:41:57 T:2424  NOTICE: Found screen: Generic PnP Monitor on ATI Radeon HD 3200 Graphics (Microsoft Corporation WDDM 1.1) , adapter 0.
22:41:57 T:2424  NOTICE: Primary mode: 1024x768 @ 60.00 - Full Screen
22:41:57 T:2424  NOTICE: Additional mode: 640x480 @ 59.94 - Full Screen
22:41:57 T:2424  NOTICE: Additional mode: 640x480 @ 60.00 - Full Screen
22:41:57 T:2424  NOTICE: Additional mode: 800x600 @ 60.00 - Full Screen
22:41:57 T:2424  NOTICE: Additional mode: 1024x768 @ 60.00 - Full Screen
22:41:57 T:2424  NOTICE: load settings...
22:41:57 T:2424  NOTICE: special://profile/ is mapped to: special://masterprofile/
22:41:57 T:2424  NOTICE: loading special://masterprofile/guisettings.xml
22:41:57 T:2424  NOTICE: Getting hardware information now...
22:41:57 T:2424  NOTICE: Checking resolution 11
22:41:57 T:2424  NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
22:41:57 T:2424  NOTICE: Loaded playercorefactory configuration
22:41:57 T:2424  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
22:41:57 T:2424  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
22:41:57 T:2424  NOTICE: No settings file to load to load (special://xbmc/system/advancedsettings.xml)
22:41:57 T:2424  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
22:41:57 T:2424  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.197</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                                <name>xbmc_video</name>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.197</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                                <name>xbmc_music</name>
                                              </musicdatabase>
                                            </advancedsettings>
22:41:57 T:2424 WARNING: VIDEO database configuration is experimental.
22:41:57 T:2424  NOTICE: Getting hardware information now...
22:41:57 T:2424  NOTICE: Checking resolution 11
22:41:57 T:2424  NOTICE: Default DVD Player: dvdplayer
22:41:57 T:2424  NOTICE: Default Video Player: dvdplayer
22:41:57 T:2424  NOTICE: Default Audio Player: paplayer
22:41:57 T:2424  NOTICE: Loading media sources from special://masterprofile/sources.xml
22:41:58 T:2424  NOTICE: initializing playlistplayer
22:41:58 T:2424  NOTICE: DONE initializing playlistplayer
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video57 [1049](Unknown database 'xbmc_video57')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video56 [1049](Unknown database 'xbmc_video56')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video55 [1049](Unknown database 'xbmc_video55')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video54 [1049](Unknown database 'xbmc_video54')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video53 [1049](Unknown database 'xbmc_video53')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video52 [1049](Unknown database 'xbmc_video52')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video51 [1049](Unknown database 'xbmc_video51')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video50 [1049](Unknown database 'xbmc_video50')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video49 [1049](Unknown database 'xbmc_video49')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video48 [1049](Unknown database 'xbmc_video48')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video47 [1049](Unknown database 'xbmc_video47')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video46 [1049](Unknown database 'xbmc_video46')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video45 [1049](Unknown database 'xbmc_video45')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video44 [1049](Unknown database 'xbmc_video44')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video43 [1049](Unknown database 'xbmc_video43')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video42 [1049](Unknown database 'xbmc_video42')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video41 [1049](Unknown database 'xbmc_video41')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video40 [1049](Unknown database 'xbmc_video40')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video39 [1049](Unknown database 'xbmc_video39')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video38 [1049](Unknown database 'xbmc_video38')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video37 [1049](Unknown database 'xbmc_video37')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video36 [1049](Unknown database 'xbmc_video36')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video35 [1049](Unknown database 'xbmc_video35')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video34 [1049](Unknown database 'xbmc_video34')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video33 [1049](Unknown database 'xbmc_video33')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video32 [1049](Unknown database 'xbmc_video32')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video31 [1049](Unknown database 'xbmc_video31')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video30 [1049](Unknown database 'xbmc_video30')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video29 [1049](Unknown database 'xbmc_video29')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video28 [1049](Unknown database 'xbmc_video28')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video27 [1049](Unknown database 'xbmc_video27')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video26 [1049](Unknown database 'xbmc_video26')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video25 [1049](Unknown database 'xbmc_video25')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video24 [1049](Unknown database 'xbmc_video24')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video23 [1049](Unknown database 'xbmc_video23')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video22 [1049](Unknown database 'xbmc_video22')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video21 [1049](Unknown database 'xbmc_video21')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video20 [1049](Unknown database 'xbmc_video20')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video19 [1049](Unknown database 'xbmc_video19')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video18 [1049](Unknown database 'xbmc_video18')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video17 [1049](Unknown database 'xbmc_video17')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video16 [1049](Unknown database 'xbmc_video16')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video15 [1049](Unknown database 'xbmc_video15')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video14 [1049](Unknown database 'xbmc_video14')
22:41:58 T:2424   ERROR: Unable to open database: xbmc_video13 [1049](Unknown database 'xbmc_video13')

And this just keeps going on.
The problem is it doenst connect to the SQL database and saves the records in it..
I have tried drop the databases and remake them. But i think there something more to that..

[jodur]

I have exact the same problems and my log log file looks the same.
I am also running the latest nightly builds as you, its a problem from the last nightly builds see also http://forum.xbmc.org/showthread.php?tid=113180

[Firedog]

I have exact the same problems and my log log file looks the same.
I am also running the latest nightly builds as you, its a problem from the last nightly builds see also http://forum.xbmc.org/showthread.php?tid=113180

Ohhh. I am gonna hear with my friend. He have the same build as me but he seemed to get it work last night.
But then we have to roll back.

[deadguy]

If I'm not mistaken, the nightlies make a new database MyVideos56 and uses it instead of xbmc_video.

As for me, I don't include <name>xbmc_video</name> in my advacesettings.xml and let XBMC nightlies make the db on it's own.

[bambi73]

Up to now I though DB update changes are still ongoing but looks like developers consider it finished already. So I created two tickets (#12156, #12157) because there are still holes in it.

For these who still have problem maybe my observations will help. There are two use-cases:
1/ You already used MySQL and have "old" database (for example xbmc_video in advancedsettings.xml)
- increase number of connections on your MySQL server (max_connections setting) to at least 60. See #12156 why.
- start XBMC, database should be updating (no longer Too many connections error)
- wait some time until your data are copies. See #12157 for reason why you need to wait.
- as result you will have there new database named xbmc_video57

2/ You want to create empty MySQL DB (for example xbmc_video in advancedsettings.xml)
- until now you need to create empty DB before XBMC start. DON'T DO IT NOW, database will be created by XBMC itself.
- if you create empty DB XBMC expect that it's already filled with tables and data and does nothing. As result you will get "The table does not exist" error.
- as result you will have there new database named xbmc_video57

[Firedog]

Up to now I though DB update changes are still ongoing but looks like developers consider it finished already. So I created two tickets (#12156, #12157) because there are still holes in it.

For these who still have problem maybe my observations will help. There are two use-cases:
1/ You already used MySQL and have "old" database (xbmc_video in advancedsettings.xml)
- increase number of connections on your MySQL server (max_connections setting) to at least 60. See #12156 why.
- start XBMC, database should be updating (no longer Too many connections error)
- wait some time until your data are copies. See #12157 for reason why you need to wait.
- as result you will have there new database named xbmc_video57

2/ You want to create empty MySQL DB (xbmc_video in advancedsettings.xml)
- until now you need to create empty DB before XBMC start. DON'T DO IT NOW, database will be created by XBMC itself.
- if you create empty DB XBMC expect that it's already filled with tables and data and does nothing. As result you will get "The table does not exist" error.
- as result you will have there new database named xbmc_video57

i am a result of both 1 and 2.. but i didt shit with 1. and just builded a whole new one. so now i am on 2

But what u are saying is i just let XBMC make the DB in mysql?
So i plant the advancedsettings.xml in the userdata and let XBMC make the DB.. seems like the best way imo.

Thanks for the great reply

[bambi73]

Yes, put MySQL setting in advancedsettings.xml with your choosen DB name and XBMC will create database for you. Only don't be surprised by name, it adds DB version at the end (for example xbmc_video -> xbmc_video57).

[tommyhome]

This is messed up, it means that I have to connect with a user to the mysql database that has insane access rights, meaning that whole mysql sever installation will be useless for anything but xbmc.

combined with the remote features in xbmc this leaves the whole mysql server exposed. If there is any security hole in xbmc the whole database server is at risk. Since it actually means the user for the media center need to have access to _any_ database on the mysql server.

There just is no way i'm giving a media center that kind of access rights to a database server.

[Memphiz]

This is messed up, it means that I have to connect with a user to the mysql database that has insane access rights, meaning that whole mysql sever installation will be useless for anything but xbmc.

combined with the remote features in xbmc this leaves the whole mysql server exposed. If there is any security hole in xbmc the whole database server is at risk. Since it actually means the user for the media center need to have access to _any_ database on the mysql server.

There just is no way i'm giving a media center that kind of access rights to a database server.

you should read again about the grant command ... of course you can restrict rights to the user so that he can only create databases which start with MyVideos ... just use the wildcard % inside of the db name and you are set...

[tommyhome]

you should read again about the grant command ... of course you can restrict rights to the user so that he can only create databases which start with MyVideos ... just use the wildcard % inside of the db name and you are set...

The problem is that it needs the right to create whole databases and to delete them. That is a huge step from only having access within its own database.

I've never heard of anything like this before.

[bossanova808]

When I tried the Windows nightly rfom the 29th, it also error out trying to create columns that existed already, and various data errors UTF8 vs. latin1 - I honestly think it's gonna be easier to just start with a fresh DB....seems like there is a LOT of defensive programming still missing in this update procedure...but then again, this IS a nightly, so no real surprise there I guess.

[prophetizer]

it's quite annoying this is happening, really screwing everything up. i would use dharma release if i didn't use a mac, windows, and ATV2 in the mix and need to use NFS, really sux things don't play nice together

[Firedog]

well now with a fresh DB i got this working with the SQL

tho i am still pretty bumped that i cant see my movies as i did them as ISO,IMG etc. and my 1080p videos stutter aswell

But series and movies that i have unpacked works perfect..


cheers for the help and looking forward to a stable release to iOS

[prophetizer]

well, redoing a database sucks because then recently added is useless. this is another reason i wish they would add a release date sort

[jhsrennie]

@prophetizer: we aren't deliberately breaking XBMC just to annoy you. These sorts of issues are inevitable in the development process. Complaining about it in this forum may relieve some of your stress but it's not going to make any difference to the development process.

JR