Reply to thread

Message

<blockquote data-quote="howudodat" data-source="post: 1180409" data-attributes="member: 46799">Thanks for that.&nbsp; I made a backup of the movie database first so I could rollback easily.&nbsp; I was concerned with two issues that popped up:<ol>
<li data-xf-list-type="ol">I found that I ended up with dual entries for each movie in the database.&nbsp; </li>
<li data-xf-list-type="ol">When I went to delete the old path, it warned me that any entries pointing to the old path would be deleted...I got scared here</li>
</ol>Here is what I ended up doing:<ol>
<li data-xf-list-type="ol">Add new import path and quit settings</li>
<li data-xf-list-type="ol">make a backup of movingpictures.db3</li>
<li data-xf-list-type="ol">go back and do step 2 again <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></li>
<li data-xf-list-type="ol">open movingpictures.db3 in sqlite editor (I use sqliteman)</li>
<li data-xf-list-type="ol">select * from import_path.&nbsp; This gets you the &quot;id&quot; of the new import path...take note of this id</li>
<li data-xf-list-type="ol">select * from local_media.&nbsp; This is all the movies.&nbsp; Take a look around, get comfortable with the data that is there.&nbsp; The columns that are important are &quot;fullpath&quot; and &quot;importpath&quot;.&nbsp; This is the data we will want to update.</li>
<li data-xf-list-type="ol">update localmedia set importpath=&lt;id from step 3&gt;, fullpath=replace(fullpath, '&lt;old path part&gt;', '&lt;new path part&gt;').&nbsp; note: items in &lt;&gt; are variables that need entered.&nbsp; For MY CASE ONLY, the replace looked like:<ol>
<li data-xf-list-type="ol">update localmedia set importpath=4, fullpath=replace(fullpath, '\\NAS\movies\', 'N:\');</li>
</ol></li>
<li data-xf-list-type="ol">Start moving pictures settings config again&nbsp; (For some reason all the movies showed up red, I quit and restarted the config and it was very happy)</li>
<li data-xf-list-type="ol">remove old path.</li>
</ol>I might not of needed to do all that, but in the end it worked.&nbsp; These instructions might be a bit much for those who are not comfortable with SQL.Peter</blockquote>

[QUOTE="howudodat, post: 1180409, member: 46799"] Thanks for that. I made a backup of the movie database first so I could rollback easily. I was concerned with two issues that popped up: [LIST=1] [*]I found that I ended up with dual entries for each movie in the database. [*]When I went to delete the old path, it warned me that any entries pointing to the old path would be deleted...I got scared here [/LIST] Here is what I ended up doing: [LIST=1] [*]Add new import path and quit settings [*]make a backup of movingpictures.db3 [*]go back and do step 2 again :) [*]open movingpictures.db3 in sqlite editor (I use sqliteman) [*]select * from import_path. This gets you the "id" of the new import path...take note of this id [*]select * from local_media. This is all the movies. Take a look around, get comfortable with the data that is there. The columns that are important are "fullpath" and "importpath". This is the data we will want to update. [*]update localmedia set importpath=<id from step 3>, fullpath=replace(fullpath, '<old path part>', '<new path part>'). note: items in <> are variables that need entered. For MY CASE ONLY, the replace looked like: [LIST=1] [*]update localmedia set importpath=4, fullpath=replace(fullpath, '\\NAS\movies\', 'N:\'); [/LIST] [*]Start moving pictures settings config again (For some reason all the movies showed up red, I quit and restarted the config and it was very happy) [*]remove old path. [/LIST] I might not of needed to do all that, but in the end it worked. These instructions might be a bit much for those who are not comfortable with SQL. Peter [/QUOTE]

Verification