Database issues since yesterday (1 Viewer)

[ned_flanders]

Hi guys,

some weeks ago I started to build a media pc for my father, so he can digtize his whole dvd collection.
During the last weeks he digitized his collection and embedded it into Moving Pictures plugin, which I also use at my own media pc.
Since yesterday he has some issues with his database.
Moving Pictures allways reinitiates a full scan of his two inserted folders (on 2 seperate hdds) and rerecognizes all movies, which are allready in the database, within the importer. In the logs (MediaPortal.log, MovingPictures.log, Error.log) there are many many SQL issues which all point to the problem "out of memory".
Do you guys think the hole databases are corrupted, or are they limited to a certain number of entries. He must have had digitized about 700 to 800 movies until now. The only difference within the last days was, that he only inserted .isos the last days.
Any suggestions?

Greetings
Stefan

 

[thekitehunter]

A bit late, but I'll post this in case it helps anyone else. I used the Firefox plugin 'SQLite Manager'. After you add this plug in, you use it by clicking 'tools/SQLite manager'. Then open the 'movingpictures.db3' file in the Mediaportal/database folder. In the program's database menu, there is an option 'check integrity'. I had to go back a few generations before I found one that passed - I didn't find any way of fixing the database. Everything is now fine.