Upgrade StorageReport # 2118211304 - Error when Syncing Library on Mac
When I try to sync my library I receive this error:
Error(s) encountered during statement execution: database disk image is malformed [QUERY: SELECT O.itemID FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) WHERE libraryID=? AND synced=0 ORDER BY COALESCE(IA.parentItemID, INo.parentItemID)] [PARAMS: 1] [ERROR: database disk image is malformed]
Anyone know if I can fix this or if it's worth worrying about? I'm following the steps noted in the application for error troubleshooting. I saw one other fix that says this may be due to keeping my database on a cloud drive, which I don't think is accurate, but I have not yet successfully located the database file to test this out.
Error(s) encountered during statement execution: database disk image is malformed [QUERY: SELECT O.itemID FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) WHERE libraryID=? AND synced=0 ORDER BY COALESCE(IA.parentItemID, INo.parentItemID)] [PARAMS: 1] [ERROR: database disk image is malformed]
Anyone know if I can fix this or if it's worth worrying about? I'm following the steps noted in the application for error troubleshooting. I saw one other fix that says this may be due to keeping my database on a cloud drive, which I don't think is accurate, but I have not yet successfully located the database file to test this out.
-
benjpapaUpdate, I used the database repair tool after locating the files and confirming they were not on a cloud or network drive, and so far so good! My guess is that my old Macbook's crashing issues caused corruption during use at some point in it's troubled past. It is currently catching up to my library on other devices but has not thrown the original error chain. Referenced Upload ID 603d47bf435f4 for the repair and upload, I will post again if needed but everything seems functional as of now!