Lost all attachments after moving to file system storage?

[kevinpattison]

Hey,

Recently I've been working a lot on OTRS. I've done:
1. Moved all attachments to the filesystem in OTRS 3.0.10 using "bin/otrs.ArticleStorageSwitch.pl"
2. Upgraded to 3.1.21
3. Upgraded to 3.2.18
4. Upgraded to 3.3.15
5. Upgraded to 4.0.16
6. Upgraded to 5.0.7
7. Upgraded to 5.0.16

I've lost all attachments for all old tickets it seems. From looking at the database it seems that the rows are missing from the article_attachment table and the files are also not in the filesystem (although there is 12Gb of files in the /opt/otrs/var/article folder). How could this happen?

I have a dump of the DB after the storage switch but before the upgrades but it seems to have the same problem. Have I lost all attachments?

[root]

After running the scrip with default configuration the attachment are in /opt/otrs/var/article with the structure YEAR/MONTH/DAY/ARTICLEID

If you can't access them via the GUI I think you did not changed the SysConfig setting for ArticleStorage. Check your setting in the Group Ticket, Subgroup Core::Ticket: Ticket::StorageModule and Ticket::StorageModule::CheckAllBackends.

[kevinpattison]

Correct, this resolved the issue. It seems the StorageModule got reset to DB when I did the upgrades. Setting both of these settings and all is working again.

Thanks!