[freggy]

I used this link to set up mysql: http://lifehacker.com/#!5634515/how-to-s...-the-house
and deleted my current database but now when i try to set media type and want to scan, my xbmc does nothing, it doesn't even remember what type of media i had set
what do i forget?

[fruvos]

I'm getting the same problem on a clean live install. Looking at the db, it appears that only the bookmarks and versions tables have been created in the movies database, whereas all the correct tables have been created in the music one.

Is there something wrong with the db build script in the current builds?

[gven]

Wish all the primers found by searching mentioned this or there was a simple wiki but the databases xbmc_video and xbmc_audio have to be created as

Code:

CREATE DATABASE xbmc_video CHARACTER SET latin1 COLLATE latin1_general_ci;
CREATE DATABASE xbmc_music CHARACTER SET latin1 COLLATE latin1_general_ci;

The default collation doesn't work with XBMC.

To make sure, shutdown xbmc delete those databases and create them again with the above commands, grant the permissions to xbmc user and start xbmc and it will create all the required tables and allow you to scan your files into the library and doesn't crap out when you try to get scraper information.