On Friday, 14 December, 2018 10:09, Luuk wrote:
>On 14-12-2018 16:54, Keith Medcalf wrote:
>> You get the message about missing collating sequences because the
>> database is using collating sequences that you don't have (ie, are
>> missing) in your version of SQLite3.
>Extensioon in SQLite,
On 14-12-2018 16:54, Keith Medcalf wrote:
You get the message about missing collating sequences because the database is
using collating sequences that you don't have (ie, are missing) in your version
of SQLite3.
Extensioon in SQLite, thats somewhere on my TODO list ;)
Is there any
.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Luuk
>Sent: Friday, 14 December, 2018 03:18
>To: SQLite mailing list
>Subject: Re: [sqlite] Updating Folder_Path in Windows 10 Photos App
>
>
>On 1
On 14 Dec 2018, at 10:41am, Luuk wrote:
> When SQLite realises it can't use that index, should it revert to a full
> table scan?
That's the bigger question. My theory is that SQLite doesn't want to touch
that database unless it has all the collations it will need. So it errors out
the
On 14-12-2018 11:22, Simon Slavin wrote:
On 14 Dec 2018, at 10:15am, Luuk wrote:
why do i get 'no collation sequence' with this statement:
sqlite> select Folder_Path from Folder;
Error: no such collation sequence: NoCaseUnicode
There's a UNIQUE index for Folder_Path COLLATE NoCaseUnicode.
On 14 Dec 2018, at 10:15am, Luuk wrote:
> why do i get 'no collation sequence' with this statement:
>
> sqlite> select Folder_Path from Folder;
> Error: no such collation sequence: NoCaseUnicode
There's a UNIQUE index for Folder_Path COLLATE NoCaseUnicode. Iterating
through that index would
On 14-12-2018 11:15, Luuk wrote:
On 13-12-2018 18:26, Simon Slavin wrote:
On 13 Dec 2018, at 2:57pm, Carlo capaldo
wrote:
UPDATE folder
SET Folder_Path = 'E:\Photos'
would change the directory references in all existing 16 rows
currently containing Folder_Path references to the
On 13-12-2018 18:26, Simon Slavin wrote:
On 13 Dec 2018, at 2:57pm, Carlo capaldo wrote:
UPDATE folder
SET Folder_Path = 'E:\Photos'
would change the directory references in all existing 16 rows currently
containing Folder_Path references to the wrong locations to the correct
] Updating Folder_Path in Windows 10 Photos App
On 13 Dec 2018, at 2:57pm, Carlo capaldo wrote:
> UPDATE folder
>
>SET Folder_Path = 'E:\Photos'
>
> would change the directory references in all existing 16 rows currently
> containing Folder_Path references to the wrong locati
On 13 Dec 2018, at 2:57pm, Carlo capaldo wrote:
> UPDATE folder
>
>SET Folder_Path = 'E:\Photos'
>
> would change the directory references in all existing 16 rows currently
> containing Folder_Path references to the wrong locations to the correct
> location ‘E:\Photos’ however this also
Kind regards,
Carlo.
From: sqlite-users on behalf of
Simon Slavin
Sent: Thursday, December 6, 2018 9:22:35 PM
To: SQLite mailing list
Subject: Re: [sqlite] Updating Folder_Path in Windows 10 Photos App
On 6 Dec 2018, at 9:01pm, Carlo capaldo wrote:
> U
On 6 Dec 2018, at 9:01pm, Carlo capaldo wrote:
> UNIQUE constraint failed: Folder.Folder_Path:
You seem to have two rows in the table: one with the correct Folder_Path and
one with the incorrect Folder_Path. So instead of an UPDATE you just need a
DELETE command like
DELETE FROM folder
Subject: Re: [sqlite] Updating Folder_Path in Windows 10 Photos App
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
' AND folder_Id = 1
Kind regards,
Carlo.
From: Simon Slavin<mailto:slav...@bigfraud.org>
Sent: 30 November 2018 14:43
Subject: Re: [sqlite] Updating Folder_Path in Windows 10 Photos App
On 29 Nov 2018, at 7:32pm, Carlo capaldo wrote:
> select folder.Folder_Path,
> replace(Folder_Pa
On 29 Nov 2018, at 7:32pm, Carlo capaldo wrote:
> 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?
My guess is that you actually want
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.
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).
17 matches
Mail list logo