[Sam.Nazarko]

Hey,

I wanted to erase my MySQL database and start again. Rather than drop the schema I just dropped all my tables. I figured XBMC would see a blank DB and it would re-create it all. Instead, when I go to Videos or Files (Alaska) I get a black screen. This is fixed if I remove the entry from advancedsettings.xml.

My problem: I want to tell XBMC to recreate the database (where can I reset it)

Getting this error:

Code:

ERROR: SQL: The table does not exist

XBMC is looking for tables it should actually be creating.

r32150
W7X64 - portable mode

[jmarshall]

XBMC only creates tables on database creation. If a database is created and has tables we don't expect then we fail.

Just kill the database and start over.

[Sam.Nazarko]

Hey Jon

So I must drop the schema and make a new one or I presume renaming will work. I get that XBMC thinks the DB has tables, where has it saved this data, I'd much rather prefer to reset XBMCs log of MySQL DBs. Preferably I'd like to do this without uninstalling and reinstalling.

I've converted all my media info to NFOs so every machine can pull up images like fanart etc. Importing seems much slower though vs scraping

Thanks