I can’t access my documents when updating to version 1.7.1 on my own server. The error message is as shown in the screenshot. I can enter recovery mode but can’t do anything. I’ve tried downloading the documents and re-importing them, but it still doesn’t work. All I can do is put the documents in Grist on another server with a lower version (e.g., 1.1.1).
What version did you upgrade from?
There was an issue prior to 1.5.1 where documents were producing corrupt data in the form of duplicate rows in internal ACL tables. We patched it up since and it should be quite rare, but it does look like your document is one of the ones affected. This is now flagged as an error when opening the document in newer versions of Grist.
The fix is a bit awkward in that it currently needs to be done to the Grist document externally (.grist files are just SQLite files, so any tool that can open and modify a SQLite database will work). See [1.5.1] can't open some documents : Duplicate ACLResource · Issue #1562 · gristlabs/grist-core · GitHub for an example of how to find the duplicates to remove.
George
the version I previously used was 1.4.2
The problem is specifically with corruption in one of your document’s access rules.
One thing you can try is downloading the document as a template (i.e. without any data) and using a site like https://sqliteviewer.app/ to open it and find the problematic access rule. Based on your error, you’re going to want to look for a table called _grist_ACLResources (should be near the bottom in the left panel). Inside it, the record with id 67 is the one you want to find. It will have columns for the name of the table and column(s) the problematic access rule is for.
Once you know which rule it is, you can try deleting it, saving, and then recreating it, in a version of Grist that can still open the file. If you don’t have many rules, you could also just try deleting them all and reimporting the document in 1.7.1.
George
1 Like