[5.0 Beta] Missing item attachments
I was looking for the PDF of an article that I was sure I had, but it did not appear under the item in the center pane. The only things under the item were two word documents for supplementary data. I though that I must be mistaken so I downloaded the article again. When I attached the PDF (drag and drop) to the item, the original PDF re-appeared (now 2 PDFs of the article). Again, I though that this was just me stuffing things up so I forgot about it.
But it has happened again. If I do an advanced search for the PDF (Title contains ...) the PDF shows up as I start to type the title but it can not be seen under the item in the advanced search results pane. This is also the case for at least one other completely unrelated item. I can find it in advanced search but it does not appear under the item.
The files are referenced in the SQLite database (itemAttachments) and I can find them if I do a search in Windows Explorer. In both these circumstances there is more than one file attached to an item.
Ver: 5.0-beta.216+444d77958
OS: Windows 7
Debug ID: D1093610640
Report ID: 1384062127
But it has happened again. If I do an advanced search for the PDF (Title contains ...) the PDF shows up as I start to type the title but it can not be seen under the item in the advanced search results pane. This is also the case for at least one other completely unrelated item. I can find it in advanced search but it does not appear under the item.
The files are referenced in the SQLite database (itemAttachments) and I can find them if I do a search in Windows Explorer. In both these circumstances there is more than one file attached to an item.
Ver: 5.0-beta.216+444d77958
OS: Windows 7
Debug ID: D1093610640
Report ID: 1384062127
I tried with a new Zotero profile and on Windows 10 with the same result.
It's obviously a bug either way, but it seems pretty clearly just a display glitch if they're reappearing when you add other attachments.
I ran the database integrity check, and there were no errors. I also vacuumed the database, still the same problem.
Have you made manual changes to your database via SQLite or used a plugin that writes to the database?
I have made no manual changes to the database. I have used Zotfile but currently it is disabled so that I can make sure it is not a Zotfile problem.
SELECT COUNT(*) FROM items WHERE libraryID=1 AND itemID NOT IN (SELECT itemID FROM deletedItems);
?Using the command: 7,471
SELECT COUNT(*) FROM items WHERE libraryID=1 AND itemID NOT IN (SELECT itemID FROM deletedItems) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL);
?Using command: 4,142.
One thing you could do, after making sure that auto-sync is disabled and that you've backed up your data directory, is delete all other items in the database, empty the trash, and, if the problem still occurs, upload it to the DB Repair Tool and post the Upload ID here so that we can take a look. If it doesn't happen after deleting all other items, you can see what the smallest set of items is that demonstrates the problem. (You're also welcome to just upload your full database, but a smaller set is fine if you prefer.) You can then restore your database from the backup.
I downloaded the repaired database, still the same problem.
I deleted 2,000 items the problem still exists.