Jump to content

2988 - 3010 - catalog table files.offline = true


Recommended Posts


since more than a year I use a small Python program to check if all files from the specified folders are in the Daminion catalog.
I use the following query within the program:
read_query = ("SELECT relativepath, fi.filename from files as fi "
                  "join mediaitems as mi on fi.id = mi.id "
                  " where fi.offline = false and mi.deleted = false Order BY relativepath, fi.filename")
Because of a new computer I switched from Windows 10 to Windows 11 and restored the backup of the catalogs created under W10. Now I had to notice that at the moment about 700 files (before the number was = 0) from different folders are "allegedly" not in the catalog - but they are. The reason for the files "allegedly" not being in the catalog is: in the table "files" is offline = true for these files, in the table "mediaitems" is deleted = false.
Is there any known explanation for the fact that the files are marked as offline?

Regards, Uwe

Link to comment
Share on other sites

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...