Home → 1Password 3.8 for Mac (from AgileBits website) →

Database error 1: no such column: overview_key

Admin Functions

• Remove

ajbehrens

18 Feb, 2012 10:32 PM

This is the error I get trying to access 1Password through the Safari browser extension on one of my MacBook Airs. The two computers are sharing the data file over dropbox. It works fine on one but not the other. Both have Lion. I get this error trying to enter the master password. It says there is a problem with the database. I've tried clearing cache's, rebuilding the datafile and reinstalling the Safari extension. What should I do next?

• 1Password_Troubleshooting_Report.pdf 37.8 KB

1. Support Staff 2 Posted by Khad Young on 19 Feb, 2012 11:11 AM

   

   Hi ajbehrens,

   Thanks for taking the time to contact us. I'm sorry that you are having this problem.

   It sounds like your Safari extensions preferences may have gotten corrupted. The following steps will require you to reinstall any extension you have installed in Safari, but should get things working well again:

   1. Quit Safari.
   2. Open a Finder window and select "Go to Folder" from the Go menu.

   3. Type this in the input field and then press Return:

      ~/Library/Safari/Extensions

   4. Move the files you see there to your Desktop or some other folder you can easily find later if necessary.

   5. Restart Safari.
   6. Reinstall the 1Password extension and your other extensions.

   Please let me know how it goes.

   ---

   Khad Young
   Forum Choreographer, AgileBits
   http://agilebits.com/support

   Admin Functions

   • Echo
   • Remove

2. 3 Posted by Chris Moores on 19 Apr, 2012 06:41 PM

   

   Hi There -

   I have the same error that 'ajbehrens' reported and followed the steps outlined.

   I still get the same error:

   Problem with Database
   Data Error 1: No such column.

   1Password Extension Information

   Extension version 3.9.4 (release notes)
   Database created at 2011-9-4 : 10:58:56
   Instance UUID dcd654f0...6CD9
   Uptime (mins) 2

   Admin Functions

   • Split
   • Remove

3. 4 Posted by Stu Helm on 19 Apr, 2012 07:48 PM

   

   Hi Chris,

   Sorry for the trouble here, could you try something different instead, as your error seems a little different. Can you go to Safari > Preferences > Extensions and remove 1Password from the list.

   Once that's done, please try the following:

   • Quit Safari and 1Password
   • Open a Finder window and select Go > Go to Folder
   • Enter ~/Library/Safari/Databases and press enter
   • Delete the folder named 'safari-extension_com.agilebits.onepassword-safari-2bua8c4s2c_0'
   • Restart Safari
   • Install our latest extension from https://agilebits.com/extensions/mac/safari.html

   You should now be all set, if you continue to have problems do you use Private Browsing mode in Safari or any 'cleaning' tools?

   ---

   Stu Helm
   Agile Crusader
   AgileBits

   http://support.agilebits.com
   http://twitter.com/1Password

   Admin Functions

   • Split
   • Remove

4. 5 Posted by Chris Moores on 19 Apr, 2012 07:56 PM

   

   Problem resolved. Thanks for the assistance!

   Chris

   Admin Functions

   • Split
   • Remove

5. 6 Posted by Chris Moores on 19 Apr, 2012 07:56 PM

   

   Worked like a charm!

   Thank-You,

   Chris Moores

   Admin Functions

   • Split
   • Remove

6. 7 Posted by Stu Helm on 19 Apr, 2012 08:05 PM

   

   You're very welcome, Chris, glad that did the trick for you.

   ---

   Stu Helm
   Agile Crusader
   AgileBits

   http://support.agilebits.com
   http://twitter.com/1Password

   Admin Functions

   • Split
   • Remove

7. System closed this discussion on 07 Jun, 2012 09:31 PM.

Comments are currently closed for this discussion. You can start a new one.