(Archived) evernote sq error?

[ssh 1]

I've been getting an "evernote sq" error almost every time I leave Evernote active for a length of time (Snow Leopard). I may open it in the morning, and then in the evening or the next day it will have this error. It doesn't appear to impact data, but I do have to restart Evernote. Anyone else seeing this? I'll get the exact error message next time it does it.

[engberg 89]

That's strange, I haven't seen this before. A screen shot would be pretty useful, and you could also run the Mac "Console" application and grab the last dozen "Evernote" lines, which may provide more details.

Thanks

[Robert_London 0]

I get this error a lot too. My console entry reads:

Sep 19 21:20:58 [ ]-macbook-air Evernote[209]: NSExceptionHandler has recorded the following exception:\nNSInternalInconsistencyException -- I/O error for database at /Users/[ ]/Library/Application Support/Evernote/data/51783/Evernote.sql. SQLite error code:21, 'unable to open database file'\nStack trace: 0x919dfd24 0x99157f49 0x963d995f 0x964257a1 0x9642b4e5 0x9642a1f4 0x964243a3 0x963e3991 0x963e2a31 0x96419c47 0x819c7 0x8354e 0x94b979d4 0x9889feee 0x9889dd34 0x9889db61 0x945fbfec 0x945fbda3 0x945fbc28 0x91cf4c95 0x91cf450a 0x91cb669b 0x91cae735 0x2e62 0x2

Sep 19 21:20:58 [ ]-macbook-air Evernote[209]: NSExceptionHandler has recorded the following exception:\nNSInternalInconsistencyException -- I/O error for database at /Users/[ ]/Library/Application Support/Evernote/data/51783/Evernote.sql. SQLite error code:14, 'unable to open database file'\nStack trace: 0x919dfd24 0x99157f49 0x963d995f 0x963d938b 0x963d82c5 0x963e38e0 0x963e2a31 0x96419c47 0x819c7 0x8354e 0x94b979d4 0x9889feee 0x9889dd34 0x9889db61 0x945fbfec 0x945fbda3 0x945fbc28 0x91cf4c95 0x91cf450a 0x91cb669b 0x91cae735 0x2e62 0x2

Sep 19 21:20:58: --- last message repeated 1 time ---

Sep 19 21:20:58 [ ]-macbook-air Evernote[209]: Save error: Error Domain=NSCocoaErrorDomain Code=256 UserInfo=0x17c7f990 "The file “Evernote.sql” couldn’t be opened."

Sep 19 21:20:58 [ ]-macbook-air Evernote[209]: Presenting error: Error Domain=NSCocoaErrorDomain Code=256 UserInfo=0x17c7f990 "The file “Evernote.sql” couldn’t be opened."

Sep 19 21:20:58 [ ]-macbook-air Evernote[209]: user info: {\n NSFilePath = "/Users/[ ]/Library/Application Support/Evernote/data/51783/Evernote.sql";\n NSStackTraceKey = "0x919dfd24 0x99157f49 0x963d995f 0x964257a1 0x9642b4e5 0x9642a1f4 0x964243a3 0x963e3991 0x963e2a31 0x96419c47 0x819c7 0x8354e 0x94b979d4 0x9889feee 0x9889dd34 0x9889db61 0x945fbfec 0x945fbda3 0x945fbc28 0x91cf4c95 0x91cf450a 0x91cb669b 0x91cae735 0x2e62 0x2";\n NSUnderlyingException = I/O error for database at /Users/[ ]/Library/Application Support/Evernote/data/51783/Evernote.sql. SQLite error code:21, 'unable to open database file';\n}

[engberg 89]

That log snippet indicates that there is some sort of file system corruption in the main database file on your drive. This could be due to a missing file, bad file permissions, or some internal file corruption.

If you don't have any important notes that have not been synchronized to the service*, you can try the following:

Please try moving your Evernote database directory so that Evernote will regenerate a new local database by copying your notes back down from the service. To do this:

Quit Evernote.

In the finder, open the "Library" folder in your home directory. (This is in the directory with your name, NOT at the top level of your hard drive.)

Navigate to "Application Support"

Move the "Evernote" directory from that location to a different place (like the desktop)

Start Evernote, provide your username and password again if needed

This will synchronize all of your notes from the service and create a new local database.

*If you do have some unsynchronized notes, you can go to the Note List view, sort by the "Sync" column, and export any notes that have a * in that column to .enex format before following the above instructions. Once those instructions are finished, you can then import the .enex files you created to restore these exported notes.

[Robert_London 0]

Thank you; I've just replaced the local copy of the database, as you suggested, and will let you know if the problem recurs.

[tchaten 1]

Would doing this with a library of over 500MB - cause the monthly usage to be wiped out so we have no space to add new content?

I am also having this error on a semidaily basis

[engberg 89]

Other than the error message in the Console logs, what problem are you seeing? I.e. is Evernote misbehaving in any other way?

We're seeing this on a few systems that we have access to, but the problem doesn't appear to cause any issues with the application itself (which is strange).

Thanks

[tchaten 1]

The only issue I have been seeing is that it locks up every now when returning to Evernote after working with a PDF in Preview. And the Evernote can't save SQL error shows up in a popup. It doesn't seem to effect anything but I just wish it was more stable and did not have to force quite Evernote once a day or more.

Would starting from scratch toast my monthly usage?

Thanks

[engberg 89]

Our Mac team lead has seen this on a couple of computers, so he's looking into it.

Creating a new database wouldn't affect your upload allowance, but that might take a while.

[tchaten 1]

Okay awesome thanks!

I have a screenshot of the error - but it sounds like you guys found the problem and are working on a fix

[Robert_London 0]

... and mine was completely fixed by the solution suggested above.

[petey5 0]

I get  SQLite error when trying to sync a new note from my 3G Android phone (Huawei Fusion U8652).

Will not sync at all anymore. Don't have more specifics because the popup flashes too fast but now that I have found this spot I will try to get better, specific information

 

I would like to try the fix mentioned above but being a newbie (using an Acer laptop-Windows 7) could you give more specific direction in the following areas:

-Am having the problem on phone but that may mean the problem is within laptop/Evernote files?

*My Desktop and Web Evernote behave and sync fine

 

-If the unsynced notes are on my phone am I safe to move the directory on the laptop?

 

-The 'Home Library with my name'-....

-Acer\AppData\Local\Apps\Evernote-Yeah found it! This opens a TON of files that WOW did not know were there.

-What file type am I looking for? (ie. .is, .dll, .exe, etc)

 

-Am I looking for the "console" application to get lines that might help diagnose the problem?

-Looking for Application Support-Is that the name of the file?

 

-Don't understand the .enex directions for following directions:

(*If you do have some unsynchronized notes, you can go to the Note List view, sort by the "Sync" column, and export any notes that have a * in that column to .enex format before following the above instructions. Once those instructions are finished, you can then import the .enex files you created to restore these exported notes.)

I have unsyncd notes on phone that are important.