Updating folder path in Windows 10 Photo App
After several weeks work putting together a holiday video using the Windows 10 Photo App when I now open the app it can no longer find any of my photos. Every file in the Storyboard shows the sad emoticon and a message stating "We can't find this file".
I have tried all of the obvious steps of updating Settings -> Sources to include the folder containing all the source material (E:Photos)
Being understandably reluctant to give up completely on my work I discovered that the file format is SQLite and so managed to open the database using DB Browser for SQLite. The table Folder reveals the list below. I have tried various SQL scripts to try to correct the references to point to E:Photos, all of which have failed.
When first opening the database to view the folders I also receive a message stating I have missing collating sequences. I've been told this is because the database is using collating sequences that are missing in DB Browser.
Can anyone please suggest how to correct the references in the database so that Windows 10 Photo App is able to find my photos?
sqlite> .width 5 50
sqlite> SELECT Folder_Id,Folder_Path FROM Folder;
1 C:UserscarloPictures
2 C:UserscarloPicturesSaved Pictures
3 C:UserscarloPicturesCamera Roll
4
5
6
7 C:UserscarloPicturesExported videos
13 C:UserscarloPictures2018-09
14 C:UserscarloPictures2018-08
16 C:UserscarloPicturesGoPro
17 C:UserscarloOneDrivePictures
20
21
22
23 C:UserscarloOneDrivePicturesCamera imports
24 C:UserscarloOneDrivePicturesCamera imports
25 E:Photos
windows-10 photos sqlite folder-redirection
edited Dec 23 '18 at 19:59
harrymc
254k14265565
asked Dec 23 '18 at 19:44
CarloCarlo
1
add a comment |
After several weeks work putting together a holiday video using the Windows 10 Photo App when I now open the app it can no longer find any of my photos. Every file in the Storyboard shows the sad emoticon and a message stating "We can't find this file".
I have tried all of the obvious steps of updating Settings -> Sources to include the folder containing all the source material (E:Photos)
Being understandably reluctant to give up completely on my work I discovered that the file format is SQLite and so managed to open the database using DB Browser for SQLite. The table Folder reveals the list below. I have tried various SQL scripts to try to correct the references to point to E:Photos, all of which have failed.
When first opening the database to view the folders I also receive a message stating I have missing collating sequences. I've been told this is because the database is using collating sequences that are missing in DB Browser.
Can anyone please suggest how to correct the references in the database so that Windows 10 Photo App is able to find my photos?
sqlite> .width 5 50
sqlite> SELECT Folder_Id,Folder_Path FROM Folder;
1 C:UserscarloPictures
2 C:UserscarloPicturesSaved Pictures
3 C:UserscarloPicturesCamera Roll
4
5
6
7 C:UserscarloPicturesExported videos
13 C:UserscarloPictures2018-09
14 C:UserscarloPictures2018-08
16 C:UserscarloPicturesGoPro
17 C:UserscarloOneDrivePictures
20
21
22
23 C:UserscarloOneDrivePicturesCamera imports
24 C:UserscarloOneDrivePicturesCamera imports
25 E:Photos
windows-10 photos sqlite folder-redirection
edited Dec 23 '18 at 19:59
harrymc
254k14265565
asked Dec 23 '18 at 19:44
CarloCarlo
1
add a comment |
After several weeks work putting together a holiday video using the Windows 10 Photo App when I now open the app it can no longer find any of my photos. Every file in the Storyboard shows the sad emoticon and a message stating "We can't find this file".
I have tried all of the obvious steps of updating Settings -> Sources to include the folder containing all the source material (E:Photos)
Being understandably reluctant to give up completely on my work I discovered that the file format is SQLite and so managed to open the database using DB Browser for SQLite. The table Folder reveals the list below. I have tried various SQL scripts to try to correct the references to point to E:Photos, all of which have failed.
When first opening the database to view the folders I also receive a message stating I have missing collating sequences. I've been told this is because the database is using collating sequences that are missing in DB Browser.
Can anyone please suggest how to correct the references in the database so that Windows 10 Photo App is able to find my photos?
sqlite> .width 5 50
sqlite> SELECT Folder_Id,Folder_Path FROM Folder;
1 C:UserscarloPictures
2 C:UserscarloPicturesSaved Pictures
3 C:UserscarloPicturesCamera Roll
4
5
6
7 C:UserscarloPicturesExported videos
13 C:UserscarloPictures2018-09
14 C:UserscarloPictures2018-08
16 C:UserscarloPicturesGoPro
17 C:UserscarloOneDrivePictures
20
21
22
23 C:UserscarloOneDrivePicturesCamera imports
24 C:UserscarloOneDrivePicturesCamera imports
25 E:Photos
windows-10 photos sqlite folder-redirection
edited Dec 23 '18 at 19:59
harrymc
254k14265565
asked Dec 23 '18 at 19:44
CarloCarlo
1
After several weeks work putting together a holiday video using the Windows 10 Photo App when I now open the app it can no longer find any of my photos. Every file in the Storyboard shows the sad emoticon and a message stating "We can't find this file".
I have tried all of the obvious steps of updating Settings -> Sources to include the folder containing all the source material (E:Photos)
Being understandably reluctant to give up completely on my work I discovered that the file format is SQLite and so managed to open the database using DB Browser for SQLite. The table Folder reveals the list below. I have tried various SQL scripts to try to correct the references to point to E:Photos, all of which have failed.
When first opening the database to view the folders I also receive a message stating I have missing collating sequences. I've been told this is because the database is using collating sequences that are missing in DB Browser.
Can anyone please suggest how to correct the references in the database so that Windows 10 Photo App is able to find my photos?
sqlite> .width 5 50
sqlite> SELECT Folder_Id,Folder_Path FROM Folder;
1 C:UserscarloPictures
2 C:UserscarloPicturesSaved Pictures
3 C:UserscarloPicturesCamera Roll
4
5
6
7 C:UserscarloPicturesExported videos
13 C:UserscarloPictures2018-09
14 C:UserscarloPictures2018-08
16 C:UserscarloPicturesGoPro
17 C:UserscarloOneDrivePictures
20
21
22
23 C:UserscarloOneDrivePicturesCamera imports
24 C:UserscarloOneDrivePicturesCamera imports
25 E:Photos
windows-10 photos sqlite folder-redirection
windows-10 photos sqlite folder-redirection
edited Dec 23 '18 at 19:59
harrymc
254k14265565
asked Dec 23 '18 at 19:44
CarloCarlo
1
edited Dec 23 '18 at 19:59
harrymc
254k14265565
asked Dec 23 '18 at 19:44
CarloCarlo
1
edited Dec 23 '18 at 19:59
harrymc
254k14265565
edited Dec 23 '18 at 19:59
harrymc
254k14265565
edited Dec 23 '18 at 19:59
harrymc
254k14265565
254k14265565
asked Dec 23 '18 at 19:44
CarloCarlo
1
asked Dec 23 '18 at 19:44
CarloCarlo
1
asked Dec 23 '18 at 19:44
CarloCarlo
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
If Photos is looking for your photos in folder C:UserscarloPictures,
while they are really in folder E:Photos, you can in effect add
E:Photos to C:UserscarloPictures via symbolic links (junctions).
Start a Command Prompt (cmd) and enter the following command:
mklink /J E:Photos C:UserscarloPictures
answered Dec 23 '18 at 20:13
harrymcharrymc
254k14265565
Many thanks for your reply and sorry for the delayed response. I did try running the above command in administrator mode which resulted in the response: "Cannot create a file when that file already exists." I'm not sure why, I also tried downloading the shell extension to try to do the same thing using explorer which shows the folder link being created but once again the Storyboard in the Photo App still can't find the file. If only there was a way to see what file the App is trying to find and where it's trying to read it from.
– Carlo
Dec 31 '18 at 18:18
Use Process Monitor to trace a process.
– harrymc
Dec 31 '18 at 18:55
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1387195%2fupdating-folder-path-in-windows-10-photo-app%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If Photos is looking for your photos in folder C:UserscarloPictures,
while they are really in folder E:Photos, you can in effect add
E:Photos to C:UserscarloPictures via symbolic links (junctions).
Start a Command Prompt (cmd) and enter the following command:
mklink /J E:Photos C:UserscarloPictures
answered Dec 23 '18 at 20:13
harrymcharrymc
254k14265565
Many thanks for your reply and sorry for the delayed response. I did try running the above command in administrator mode which resulted in the response: "Cannot create a file when that file already exists." I'm not sure why, I also tried downloading the shell extension to try to do the same thing using explorer which shows the folder link being created but once again the Storyboard in the Photo App still can't find the file. If only there was a way to see what file the App is trying to find and where it's trying to read it from.
– Carlo
Dec 31 '18 at 18:18
Use Process Monitor to trace a process.
– harrymc
Dec 31 '18 at 18:55
add a comment |
If Photos is looking for your photos in folder C:UserscarloPictures,
while they are really in folder E:Photos, you can in effect add
E:Photos to C:UserscarloPictures via symbolic links (junctions).
Start a Command Prompt (cmd) and enter the following command:
mklink /J E:Photos C:UserscarloPictures
answered Dec 23 '18 at 20:13
harrymcharrymc
254k14265565
Many thanks for your reply and sorry for the delayed response. I did try running the above command in administrator mode which resulted in the response: "Cannot create a file when that file already exists." I'm not sure why, I also tried downloading the shell extension to try to do the same thing using explorer which shows the folder link being created but once again the Storyboard in the Photo App still can't find the file. If only there was a way to see what file the App is trying to find and where it's trying to read it from.
– Carlo
Dec 31 '18 at 18:18
Use Process Monitor to trace a process.
– harrymc
Dec 31 '18 at 18:55
add a comment |
If Photos is looking for your photos in folder C:UserscarloPictures,
while they are really in folder E:Photos, you can in effect add
E:Photos to C:UserscarloPictures via symbolic links (junctions).
Start a Command Prompt (cmd) and enter the following command:
mklink /J E:Photos C:UserscarloPictures
answered Dec 23 '18 at 20:13
harrymcharrymc
254k14265565
If Photos is looking for your photos in folder C:UserscarloPictures,
while they are really in folder E:Photos, you can in effect add
E:Photos to C:UserscarloPictures via symbolic links (junctions).
Start a Command Prompt (cmd) and enter the following command:
mklink /J E:Photos C:UserscarloPictures
answered Dec 23 '18 at 20:13
harrymcharrymc
254k14265565
answered Dec 23 '18 at 20:13
harrymcharrymc
254k14265565
answered Dec 23 '18 at 20:13
harrymcharrymc
254k14265565
answered Dec 23 '18 at 20:13
harrymcharrymc
254k14265565
254k14265565
Many thanks for your reply and sorry for the delayed response. I did try running the above command in administrator mode which resulted in the response: "Cannot create a file when that file already exists." I'm not sure why, I also tried downloading the shell extension to try to do the same thing using explorer which shows the folder link being created but once again the Storyboard in the Photo App still can't find the file. If only there was a way to see what file the App is trying to find and where it's trying to read it from.
– Carlo
Dec 31 '18 at 18:18
Use Process Monitor to trace a process.
– harrymc
Dec 31 '18 at 18:55
add a comment |
Many thanks for your reply and sorry for the delayed response. I did try running the above command in administrator mode which resulted in the response: "Cannot create a file when that file already exists." I'm not sure why, I also tried downloading the shell extension to try to do the same thing using explorer which shows the folder link being created but once again the Storyboard in the Photo App still can't find the file. If only there was a way to see what file the App is trying to find and where it's trying to read it from.
– Carlo
Dec 31 '18 at 18:18
Use Process Monitor to trace a process.
– harrymc
Dec 31 '18 at 18:55
Many thanks for your reply and sorry for the delayed response. I did try running the above command in administrator mode which resulted in the response: "Cannot create a file when that file already exists." I'm not sure why, I also tried downloading the shell extension to try to do the same thing using explorer which shows the folder link being created but once again the Storyboard in the Photo App still can't find the file. If only there was a way to see what file the App is trying to find and where it's trying to read it from.
– Carlo
Dec 31 '18 at 18:18
Many thanks for your reply and sorry for the delayed response. I did try running the above command in administrator mode which resulted in the response: "Cannot create a file when that file already exists." I'm not sure why, I also tried downloading the shell extension to try to do the same thing using explorer which shows the folder link being created but once again the Storyboard in the Photo App still can't find the file. If only there was a way to see what file the App is trying to find and where it's trying to read it from.
– Carlo
Dec 31 '18 at 18:18
Use Process Monitor to trace a process.
– harrymc
Dec 31 '18 at 18:55
Use Process Monitor to trace a process.
– harrymc
Dec 31 '18 at 18:55
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1387195%2fupdating-folder-path-in-windows-10-photo-app%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
