Hi Carlo,
Attachments are stripped on this forum - could you use a file service or
upload it somewhere?
Also be clear about the which paths all changed and to what - AND make a
backup of the file before fixing it - but there most certainly is some
SQL that will fix what you described.
Cheers,
Ryan
On 2018/11/29 9:32 PM, Carlo capaldo wrote:
Dear Users,
Windows 10 Photos App is no longer able to find my files when opening the app.
I discovered that the App uses Sqlite and using DB Browser for SQLite I was
able to display the Table folder which shows the many different folder paths I
believe the App is referencing (see attached).
The original folder paths have all changed and the photos etc have been
consolidated into a single directory (E:\Photos).
I tried using the following sql commands to change the folder references for
each entry. The sequence appears to execute correctly but I can’t find a way to
update or write the database.
select folder.Folder_Path,
replace(Folder_Path,'C:\Users\carlo\Pictures','E:\Photos')
from Folder
where folder.Folder_Id = 1
Could someone kindly educate me on how to update the folder references?
Kind regards,
Carlo.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
