HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker

(2012-04-23 15:42)Moncha Wrote:  You need to create the datatbases, XBMC only reads them after you have done so.

Log in and run this as taken from the Lifehacker site:

Code:

CREATE database xbmc_video;
CREATE database xbmc_music;

This is incorrect, if you have set everything up properly you let XBMC create the databases and tables.

(2012-04-23 17:12)WordMasterRice Wrote:  

(2012-04-23 15:42)Moncha Wrote:  You need to create the datatbases, XBMC only reads them after you have done so.

Log in and run this as taken from the Lifehacker site:

Code:

CREATE database xbmc_video;
CREATE database xbmc_music;

This is incorrect, if you have set everything up properly you let XBMC create the databases and tables.

Yup, as long as the permissions are set up correctly, i.e. grant all on *.* to 'xbmc'@'%' it should Just Work©.

Also, have you set the content correctly on all of the pertinent folders and updated your library?

I've ran through the steps several times, and ran the permissions query multiple chance but still no luck.

I've even renamed the profiles and updated the settings file a couple of times, but still nothing.

I'm about to try it on a different computer and see how well I do.

I may stand corrected but, I had no luck in having XBMC create the DB and tables so I did it manually and all worked great.
In Dharma I was using WHS, now with eden I am using WHS 2011 and both time had to manually set the DBs.

I finally managed to get this working after a couple of mistakes, the first being that the advancedsettings.xml file wasn't saved in the userdata folder and the second being a missing closing '>' in my file.

However after I checked the database and found all my videos had been added to the tables, when trying to play them in XBMC all the folders were now empty. I then tried to fix this by readding the content, but now it doesn't save the content settings and doesn't scan the videos to the library.

Anyone got any ideas?

Cheers

(2012-04-27 00:13)Kami Wrote:  but now it doesn't save the content settings and doesn't scan the videos to the library.

im having this issue too after switching over to mysql, tv shows will keep set content, but movies will not, it keeps reverting to NONE. this was working just fine when i set it up, but i discoverd yesterday that movies i can no longer set the scraper and content type.

i've tried removing the source and adding it again, but doesnt work.

dave

(2012-04-27 14:57)labtopia Wrote:  

(2012-04-27 00:13)Kami Wrote:  but now it doesn't save the content settings and doesn't scan the videos to the library.

im having this issue too after switching over to mysql, tv shows will keep set content, but movies will not, it keeps reverting to NONE. this was working just fine when i set it up, but i discoverd yesterday that movies i can no longer set the scraper and content type.

i've tried removing the source and adding it again, but doesnt work.

dave

i was able to fix this, it looks like my user profile was bad, so i backed up my userdata folder and deleted it, new fresh one, i put back my advanced, sources, medialocations xml's and it is now working again.

So has anyone got thumbnails working for movies and TV shows on Eden? I have my libraries sync'd but I have no thumbnails. I can manually go into each movie and set the thumbnail, then it stays... but for some reason it isnt working automatically.

(2012-04-25 22:09)Moncha Wrote:  I may stand corrected but, I had no luck in having XBMC create the DB and tables so I did it manually and all worked great.
In Dharma I was using WHS, now with eden I am using WHS 2011 and both time had to manually set the DBs.

How did you do it manually? I tried manually creating the databases but it won't create the tables. Since I don't know the schema for the database, I can't create them manually.

Please let me know as I've been googling for hours trying to figure out how to manually create the tables.

Do not create the tables, XBMC will do it for you. Read the wiki!