Reply to thread

Message

<blockquote data-quote="armandp" data-source="post: 387014" data-attributes="member: 71896">Ok, you asked for it <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /> Before trying this, BACKUP your database!! 1. Close down mediaportal / moving pictures completely2. Start your favorite SQLite editor3. Open the &quot;movingpictures.db3&quot; database. location differs depending on your OSExample: C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal\database 4. Open to the import_path table5. Write down the IDs for import paths that were moved to a different disk6. Open up the query editor and write the following query:[CODE]UPDATE local_mediaSET volume_serial = NULLWHERE importpath IN (?,?, etc... )[/CODE]replace ? with the ID's you wrote down in step 5)Example for multiple import paths (ID 2, 6 and 7):[CODE]UPDATE local_mediaSET volume_serial = NULLWHERE importpath IN (2,6,7)[/CODE]Example for one import path (ID = 5):[CODE]UPDATE local_mediaSET volume_serial = NULLWHERE importpath = 5[/CODE]7. Execute the query, it should report that it affected # number of objects8. Close down the SQLite editor9. Start MediaPortal Configuration -&gt; Plugins -&gt; Moving Pictures -&gt; CONFIG10. Moving Pictures will now update the database and restore the new volume_serials.</blockquote>

[QUOTE="armandp, post: 387014, member: 71896"] Ok, you asked for it :) [B] Before trying this, BACKUP your database!! [/B] 1. Close down mediaportal / moving pictures completely 2. Start your favorite SQLite editor 3. Open the "[B]movingpictures.db3[/B]" database. [i] location differs depending on your OS Example: C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal\database [/i] 4. Open to the[B] import_path[/B] table 5. Write down the IDs for import paths that were moved to a different disk 6. Open up the query editor and write the following query: [CODE]UPDATE local_media SET volume_serial = NULL WHERE importpath IN (?,?, etc... )[/CODE] replace ? with the ID's you wrote down in step 5) Example for multiple import paths (ID 2, 6 and 7): [CODE]UPDATE local_media SET volume_serial = NULL WHERE importpath IN (2,6,7)[/CODE] Example for one import path (ID = 5): [CODE]UPDATE local_media SET volume_serial = NULL WHERE importpath = 5[/CODE] 7. Execute the query, it should report that it affected # number of objects 8. Close down the SQLite editor 9. Start MediaPortal Configuration -> Plugins -> Moving Pictures -> CONFIG 10. Moving Pictures will now update the database and restore the new volume_serials. [/QUOTE]

Verification