[Question] Using only local db: "Diagnostic Error: Cannot update a record with pending changes"
I'm using WatermelonDB solely as a local database, without syncing to any server. The issue I'm facing is that I have some records marked as having pending changes in the local database, and I can't seem to bypass the error:
Cannot update a record with pending changesEven when I re-fetch the record from the database (discarding the previous instance), the error persists.
My question is: Is there any way to manually mark a record as having no pending changes so I can update or overwrite it with the latest version?
I’ve searched through the documentation and GitHub issues, but all the relevant solutions seem to apply only when syncing with a remote server.
I've also tried using multiple AI models to find a workaround, but none have been helpful so far.
For context, I'm not using the latest version of WatermelonDB.
Thanks in advance for any help or guidance.
Source: Nozbe/WatermelonDB