Reply to thread

Message

<blockquote data-quote="RoChess" data-source="post: 1240749" data-attributes="member: 18896">Had another corruption with IMDb+, so this time I tried an aggressive approach to clean up MovPic database as I had 100+ entries in it for IMDb+ in the `scripts` table.Steps I took:<ol>
<li data-xf-list-type="ol">Make backup of movingpictures.db3 file (always a good idea)</li>
<li data-xf-list-type="ol">Open Moving-Pictures configuration</li>
<li data-xf-list-type="ol">Switch to &quot;Importer Settings&quot; tab</li>
<li data-xf-list-type="ol">Ensure &quot;Manually manage movie data sources&quot; option is active</li>
<li data-xf-list-type="ol">Click on the &quot;Movie Details Data Sources&quot;</li>
<li data-xf-list-type="ol">Select IMDb+ from the list, and use the drop-down menu next to '-' to delete it</li>
<li data-xf-list-type="ol">Confirm the warning that you are sure</li>
<li data-xf-list-type="ol">Close Moving-Pictures configuration</li>
<li data-xf-list-type="ol">Launch MediaPortal GUI (and let it settle/run for just a minute)</li>
<li data-xf-list-type="ol">Open IMDb+ plugin</li>
<li data-xf-list-type="ol">Use left-menu (might be different on other skins) to use the &quot;Force IMDb+&quot; option</li>
<li data-xf-list-type="ol">Select the entry listed displaying how many movies can be forced</li>
<li data-xf-list-type="ol">Select &quot;OK&quot; to start the process (will take a bit depending on the amount of movies, speed of system, etc.)</li>
<li data-xf-list-type="ol">Confirmation dialog is given after process is done</li>
</ol>And this will give you a nice clean `scripts` table again within movingpictures.db3 (probably smart to make a fresh backup after you confirmed it is all working again).Once I get back into the full swing, I will look at adding an option in the IMDb+ plugin to do this automatic like a `vacuum` option or something.</blockquote>

[QUOTE="RoChess, post: 1240749, member: 18896"] Had another corruption with IMDb+, so this time I tried an aggressive approach to clean up MovPic database as I had 100+ entries in it for IMDb+ in the `scripts` table. Steps I took: [LIST=1] [*]Make backup of movingpictures.db3 file (always a good idea) [*]Open Moving-Pictures configuration [*]Switch to "Importer Settings" tab [*]Ensure "Manually manage movie data sources" option is active [*]Click on the "Movie Details Data Sources" [*]Select IMDb+ from the list, and use the drop-down menu next to '-' to delete it [*]Confirm the warning that you are sure [*]Close Moving-Pictures configuration [*]Launch MediaPortal GUI (and let it settle/run for just a minute) [*]Open IMDb+ plugin [*]Use left-menu (might be different on other skins) to use the "Force IMDb+" option [*]Select the entry listed displaying how many movies can be forced [*]Select "OK" to start the process (will take a bit depending on the amount of movies, speed of system, etc.) [*]Confirmation dialog is given after process is done [/LIST] And this will give you a nice clean `scripts` table again within movingpictures.db3 (probably smart to make a fresh backup after you confirmed it is all working again). Once I get back into the full swing, I will look at adding an option in the IMDb+ plugin to do this automatic like a `vacuum` option or something. [/QUOTE]

Verification