2009-07-26, 11:18
kulprit Wrote:Can you give us a quick run through of how to update our database FragMenthor, would be great.
This is what I did:
Still using latest T3CH Build:
- Copied the MyVideos34.db to my Windows PC
- Using SQLite Expert Professional I opened the Database and then run 2 SQL instructions:
CREATE TABLE streamdetails (idFile integer, iStreamType integer, strVideoCodec text, fVideoAspect real, iVideoWidth integer, iVideoHeight integer, strAudioCodec text, iAudioChannels integer, strAudioLanguage text, strSubtitleLanguage text)
CREATE INDEX ix_streamdetails ON streamdetails (idFile)
- Opened the Table "version" and modified the record from 27 to 28.
Then I installed the new Nightly Build from TheQUestor (21859 at the time), copied all my UserData and Replaced the MyVideos34.db with the modified version.
- When I switch versions (almost) everything is fine; I have the database working!!!
Now the problem is the mediainfo search; I advise you to switch Auto-search of media flags OFF - otherwise it WILL FREEZE. You can see that it is working if you manually update a Movie. The flags will show!
Hope it helps!
Thanks everyone!