Error: "1Password has detected an error with your local app database"

@GreyM1P

Since a few of us were able to correct the "1Password has detected an error with your local app database" error by having 1Password regenerate the sqlite database file then maybe your developers can figure out a way to prevent this issue from happening.

Or at least add a utility function in the menus that checks database integrity and offers to correct it. I recall that in prior versions of Quicken on Windows they had a similar function.

Leaving customers waiting, sometimes for days, for someone in support to respond is not an acceptable position.

@lysander

Thank you for the feedback. Our developers are working on avoiding this situation in the future and I've shared your suggestions with the team. I'm sorry again for the frustration that the issue caused.

-Dave

Same problem for me, I just followed step by step the first post of Dave_1P to locate the file, then I renamed it "1password.sqilite.old" (after backing it up as a precaution), and restarted the Mac. I then reconnected using my iPhone. Everything's OK, and it's quicker than waiting for an answer.

@Alalettre

I'm sorry that you ran into the issue as well. I see that you sent in a diagnostics report and one of my colleagues will get back to you as soon as possible.

I also wanted to echo my colleague Grey's comment from earlier in the thread:

⚠️ Please make sure that you can sign in to 1Password.com and find all the items you would expect before modifying ANY of 1Password's supporting files to minimise the risk of data loss.

If you see an error message, and are at all unsure about what to do, please don't modify anything and email support@1password.com for guided help.

-Dave

ref: BAD-62297-727

@1P_Dave Great, it would be good to see this error repaired.

In the meantime, renaming the "1password.sqilite" to"1password.sqilite.old" procedure seems to help everyone.

@lysander

Please make sure that you can see all of your items in a correct state when you log in to your 1Password account on 1Password.com (in the browser, not the app) before modifying any files.

While renaming that file forces 1Password to generate a new healthy database using the data in your account on 1Password.com, it can result in data loss in certain situations. I recommend that folks reach out to the team by sending an email to support+forum@1Password.com so that we can help everyone resolve the issue safely.

-Dave

I have the same problem. I sent logs.zip to mailto:support+forum@1password.com.
Please help!

@yukii

I've located your email and confirm that it has made it to the right team. One of my colleagues will review the logs and send you instructions as soon as possible.

-Dave

ref: TJF-76974-611

Can someone please send me the instructions for locating and removing the 1password.sqlite file? I am having this local app database error and the 1Password help has not been helpful after 2 days.

@eoschlotz

I'm sorry that you're running into the database error. Can you please post the Support ID of the ongoing conversation that you have open with our support team? It looks something like [#ABC-12345-678]. Post that here, and I'll be able to locate your message and make sure that you receive a reply as soon as possible.

-Dave