Skip to content

Attachments not visible #4644

@xet7

Description

@xet7

Attachment is at MongoDB database on newest WeKan Snap Candidate, newest Meteor, Node.js 14.x, MongoDB 5.x.

Link to attachment at minicard:

<div class="minicard-cover" style="background-image: url('/cdn/storage/attachments/mH2oPrY3Sx2oFNuDA/original/mH2oPrY3Sx2oFNuDA.png?dummyReloadAfterSessionEstablished=abcd1234');"></div>

Attachment details at database. File is at database, not at filesystem.

{
  "_id": "mH2oPrY3Sx2oFNuDA",
  "name": "UCS-nested-icons.png",
  "extension": "png",
  "ext": "png",
  "extensionWithDot": ".png",
  "path": "/var/snap/wekan-gantt-gpl/common/files/mH2oPrY3Sx2oFNuDA-UCS-nested-icons.png",
  "meta": {
    "boardId": "cxw7o5A4iemFQiwhP",
    "cardId": "CrHbsSdzqGfFGzsH8",
    "listId": "PDkxvnukZfb2RdTcG",
    "swimlaneId": "fP8wfXkjBzqs22gYE",
    "source": "import"
  },
  "type": "image/png",
  "mime": "image/png",
  "mime-type": "image/png",
  "size": 52022,
  "userId": "jmBkZ4KqncQuKWM9r",
  "versions": {
    "original": {
      "path": "/data/attachments/mH2oPrY3Sx2oFNuDA-original-UCS-nested-icons.png",
      "size": 52022,
      "type": "image/png",
      "extension": "png",
      "meta": {},
      "storage": "fs"
    }
  },
  "_downloadRoute": "/cdn/storage",
  "_collectionName": "attachments",
  "isVideo": false,
  "isAudio": false,
  "isImage": true,
  "isText": false,
  "isJSON": false,
  "isPDF": false,
  "_storagePath": "/var/snap/wekan-gantt-gpl/common/files/mH2oPrY3Sx2oFNuDA-UCS-nested-icons.png"
}

Avatar icon is also broken:

https://example.com/cdn/storage/avatars/fQALJcbzTgvMssHtL/original/fQALJcbzTgvMssHtL.jpg?auth=false&brokenIsFine=true

This is example of cfs.avatars.filerecord:

db.getCollection("cfs.avatars.filerecord").update({ _id: "abcd1234" }, {
    $set: {
        "original": {
            "name": "aaaaabbbbb.jpg",
            "updatedAt": ISODate("2019-07-02T16:52:43.572+03:00"),
            "size": 5200,
            "type": "image/jpeg"
        },
        "userId": "aaaabbbbb",
        "uploadedAt": ISODate("2020-07-02T15:54:42.106+03:00"),
        "copies": {
            "avatars": {
                "name": "aaaaabbbbb.jpg",
                "type": "image/jpeg",
                "size": 5200,
                "key": "aaaabbbbb",
                "updatedAt": ISODate("2020-07-02T16:54:42.113+03:00"),
                "createdAt": ISODate("2020-07-02T16:54:42.113+03:00")
            }
        }
    }
})

This is example of cfs.attachments.filerecord:

db.getCollection("cfs.attachments.filerecord").update({ _id: "zyMDW3ECnxvG57u9w" }, {
    $set: {
        "original": {
            "type": "image/png",
            "size": 585972,
            "updatedAt": ISODate("2018-10-31T10:43:36.000+02:00"),
            "name": "Screenshot_201.png"
        },
        "boardId": "wn6jSd",
        "cardId": "AxiDN33",
        "userId": "9ztgWFy",
        "uploadedAt": ISODate("2020-06-12T01:49:03.886+03:00"),
        "copies": {
            "attachments": {
                "name": "Screenshot_201.png",
                "type": "image/png",
                "size": 585972,
                "key": "5ee2",
                "updatedAt": ISODate("2020-06-12T01:49:04.638+03:00"),
                "createdAt": ISODate("2020-06-12T01:49:04.638+03:00")
            }
        }
    }
})

According to nosqlbooster, attachment files are at:

  • attachments.files (355)
  • avatars.files (12)
  • cfs_gridfs.attachments.files (4.4K)
  • cfs_gridfs.avatars.files (260)

Example of attachments.files:

{
  "_id": "abcde",
  "length": 415386,
  "chunkSize": 261120,
  "uploadDate": "2020-05-15T09:21:34.633Z",
  "filename": "example.xlsx",
  "contentType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
  "metadata": {
    "boardId": "abcde1234",
    "swimlaneId": "abcde1234",
    "listId": "abcde1234",
    "cardId": "abcde1234",
    "versionName": "original",
    "fileId": "abcde1234"
  }
}

Example of avatars.files:

{
  "_id": "abcd1234",
  "length": 27094,
  "chunkSize": 261120,
  "uploadDate": "2022-02-03T12:19:51.396Z",
  "filename": "image.jpg",
  "md5": "abcd1234",
  "contentType": "image/jpeg",
  "metadata": {
    "versionName": "original",
    "fileId": "abcd1234"
  }
}

To be continued...

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions