Uwe Posted September 15, 2022 Report Share Posted September 15, 2022 Hello, in the upload folder are temporarily stored the files that have just been imported, e.g. "..\upload\2022-09-12\test.tif" After tagging them, I move them to their destination folders and the now empty subfolder "...\upload\2022-09-12" is deleted. The following query: " select * from files where relativepath LIKE '%upload%' " shows that some very old entries are still in the table "files", which were not deleted by the action "Optimize catalog". In my catalog: 37 entries, only 2 of them correct. regards, Uwe Quote Link to comment Share on other sites More sharing options...
Daria Kotilainen Posted September 15, 2022 Report Share Posted September 15, 2022 @Oleg.Ross could you please double-check this behavior? Kind regards, Daria Quote Link to comment Share on other sites More sharing options...
Uwe Posted September 15, 2022 Author Report Share Posted September 15, 2022 (edited) Please try also this query: SELECT files.id, files.filename, files.relativepath, files.offline FROM files WHERE NOT EXISTS ( SELECT 1 from mediaitems where mediaitems.id = files.id ) There are 46 of such records in my catalog. Regards, Uwe Edited September 15, 2022 by Uwe query updated Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.