Recently we switched storage from DB to FS for our articles whose tickets closed by the end of 2022.
So all articles whose tickets closed after 2022-12-31 (and all opened tickets) are still on DB.
Our config is like this:
Code: Select all
Ticket::Article::Backend::MIMEBase::CheckAllStorageBackendsTicket.xml = Enabled
Ticket::Article::Backend::MIMEBase::ArticleStorage = Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleStorageDB
- 1. they show extra attachments in the "Attachments" column.
By "extra" I mean that almost always "file-2-1" file is present as attachment.
Other types of files that appear as attachment are "file-1-1", "image001.png" (or any other email-related img).
I believe that all these extra attachments are part of the email that generated the article.
- 2. HTML article have not been always preserved (i.e., they show up as plain text without formatting and images)
(and I have the impression that those article are the same that are affected by the attachment problem)
Some articles still maintain the HTML formatting and images though.
How can we restore HTML articles and attachments from out filesystem-based tickets?