error - need help

mpollie
Hi, my error # is 1185230714
Error(s) encountered during statement execution: no such column: IA.authorName [QUERY: SELECT itemID, IA.parentItemID, IA.type, IA.authorName, IA.text, IA.comment, IA.color, IA.sortIndex, IA.isExternal FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=?] [PARAMS: 1] [ERROR: no such column: IA.authorName]

When I try to open library, it just says "Loading items" indefinitely - I tried redownloading software but nothing is working. FYI I am not a coder and will need step-by-step help if possible. Pls help! Thank you!!!
  • dstillman Zotero Team
    edited February 17, 2022
    If you don't mind, could you upload your database to the DB Repair Tool and provide the Upload ID? We can run some tests and should be able to provide a fix.

    You can ignore the download link that the tool provides, which won't fix the issue.
  • dstillman Zotero Team
    @mpollie: Actually, could you email the upgrade.log file from the Zotero data directory to support@zotero.org with a link to this thread?
Sign In or Register to comment.