Reply to thread

Message: <blockquote data-quote="RoChess" data-source="post: 855753" data-attributes="member: 18896">Open the old DB3 file in an SQLite tool and open each table, if you are unable to open certain tables due to an error, then you have a real database corruption and best coarse of action is to do a full re-import, unless you are an expert to manually rebuild it. The reasons for the corruption could be due to powerloss when things didn't get written into database yet or some other bad failure (also easy to occur when you try to hack together a server+client system setup the wrong way). If however each table opens file without errors, then technically you should be able to repair the issue, however MovingPictures normally does a lot of checks and self-repair already, so the fact you had issues must indicate something weird has indeed happened. In my experience when I've seen that happen to others (and once to myself) a re-import was still the easiest way to go. One thing to keep in mind, when you install MovingPictures an auto-backup is made inside a subfolder of the DB3 file, so you might be in luck that you still have some of those older versions available that were created before the corruption occured. In that case you can just put the best backup back and go from there, so you have less issues. On the other hand it usually takes 1 to 10 seconds *per* movie to reimport depending on the speed of your system and internet connection and the scraper you use. I use IMDb+ myself and it takes about 4 seconds per movie for my own setup, mainly due to all the additional features IMDb+ does for me. This is the total time, as in from the point MovPic detects the media, to storing it in database and adding all the artwork. So on a very large collection it can add up but in reality it is not a very long process to do a re-import. Most of the time would be wasted to manually approve movies that did not auto-match and to verify that the ones that did auto-approve did so correctly if you only supplied for example a title and multiple versions of that title exists. This is why I personally have started adding the IMDb tt-id (example: tt1234567) to all the filenames of my media, so that a re-import not only goes much faster, but it is also 100% guaranteed to be the right one. PS: keep in mind that when you do a fresh-import that is might also be a good idea to clean out your artwork folders. Granted MovPic usually ends up re-using artwork if you re-import the same media, but you might over the years have removed some movies from your collection and that artwork would still clutter up the folders. Also if you use a scraper-solution such as IMDb+ then it renames a lot of titles as part of its group/unique-title feature which causes other filenames to be used for the artwork as well. PPS: Good luck either way <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile    :)" loading="lazy" data-shortname=":)" /></blockquote>

Verification