Login at Kodi Home

prophetizer · 2011-10-22, 18:09

i updated to the latest windows nightly yesterday, and i noticed my library was empty. ok thats strange i thought. so i looked at my sql databases and there were 2 new ones that i didn't create. they were MyMusic17 and MyVideos56. whats up with that?

my advancedsettings.xml shows xbmc_video and xbmc_music

djbarney · 2011-10-22, 21:10

prophetizer Wrote:i updated to the latest windows nightly yesterday, and i noticed my library was empty. ok thats strange i thought. so i looked at my sql databases and there were 2 new ones that i didn't create. they were MyMusic17 and MyVideos56. whats up with that?

my advancedsettings.xml shows xbmc_video and xbmc_music

I've got exactly the same here, same names even (MyMusic17 and MyVideos56). Does this mean xbmc now creates its own database (no longer xbmc_music and xbmc_video in my case) and the rest works the same way? i tried re-scraping and re-adding sources, but my library somehow stays empty.

**Martijn** · 2011-10-22, 21:16

This had something to do with a few commits concerning the database handling.
Will probably be fixes in tomorrows build.

prophetizer · 2011-10-22, 23:09

well, it's pretty cool if they are going to support mysql out of the box with no user config in the future

BDPNA · 2011-10-22, 23:51

Same here - Lost all database functionality in the house now. I can't seem to get the DB to work. Anyone have a workaround?

This is a bit surprising as I thought Eden was in a feature freeze and just squashing bugs. If the way to config for multi-room XBMC shared DB is going to change that's significant news and a pretty big change as far as I'm concerned.

Anyone have this working with a shared MySQL DB? No matter what I do I can't seem to get DB working now (even tried emptying my tables and starting totally over, no luck).

prophetizer · 2011-10-23, 00:01

i just went back to an older version

**Martijn** · 2011-10-23, 02:30

BDPNA Wrote:Same here - Lost all database functionality in the house now. I can't seem to get the DB to work. Anyone have a workaround?

This is a bit surprising as I thought Eden was in a feature freeze and just squashing bugs. If the way to config for multi-room XBMC shared DB is going to change that's significant news and a pretty big change as far as I'm concerned.

Anyone have this working with a shared MySQL DB? No matter what I do I can't seem to get DB working now (even tried emptying my tables and starting totally over, no luck).

It was no new feature. It was just a try of improving the way the database upgrading was handled. They where already working on this for some time. They just missed some things so that why it went wrong. That's the risk you take when you are using nightlies. They can break.

prophetizer · 2011-10-23, 03:29

there is no sort of issues page with specific nightlies is there? so that it's easier to avoid bad ones like this?

**piipes** · 2011-10-23, 09:31

http://trac.xbmc.org/ticket/12109

That works.

prophetizer · 2011-10-23, 15:24

piipes Wrote:http://trac.xbmc.org/ticket/12109

That works.

thank you very much!

djbarney · 2011-10-23, 18:57

and indeed, with the latest (23th of oct) version it works like it did before again, i do however still have the newly created databases in mysql, i'll just leave them there, unless they don't get updated in a week or so Smile

**piipes** · 2011-10-23, 21:26

so, maybe is better to change MyMusic17 and MyVideos56 back to xbmc_music and xbmc_video?

prophetizer · 2011-10-31, 05:16

i have no idea, now it's video57, things breaking all over and don't know what to do

**jabba_29** · 2011-12-05, 15:23

I started to experience this with nightly build from this build: http://mirrors.xbmc.org/nightlies/darwin...r-atv2.deb

I now have xbmc_video & xbmc_video57 in MySQL. This cause XBMC not to start on Saturday. I deleted all my Db files on the ATV2, and it started again.

I thought I had deleted xbmc_video57 - is it safe to do so or is below the only way?

Quote:To manually work around this: 1) Copy (or rename) your MySQL databases (ex. xbmc_video and xbmc_music) to MyVideos56 and MyMusic17. 2) Grant ALL privileges to your XBMC database user (ex xbmc) on the newly created databases. 3) Grant CREATE privileges globally for your XBMC database user. 4) Remove the <name> tag from the database entries in advanced settings.xml. 5) Start XBMC nightly...

Had initially thought it was the constellation app for iPad that caused this, but reading further ... it seems not.

darkscout · 2011-12-05, 17:44

Read.
Signature.