Fatal error: Unterminated string in JSON at position 4423

lucklh · 2024-03-01T09:24:13.508Z

Operating system

Windows

Joplin version

2.13.15

Desktop version info

Joplin Portable 2.13.15

Joplin don't start up anymore

Sync target

File system

Editor

Rich Text Editor

What issue do you have?

Joplin portable don't start anymore. I always get a fatal error message.
I downloaded the latest portable app again, but it is still the same behavior.

Screenshots

2024-03-01 Joplin Error.png

laurent · 2024-03-01T11:26:00.093Z

It looks like some data in the database is corrupted. To fix it you will need to do this:

Open the file database.sqlite in JoplinProfile using a database viewer such as https://sqlitebrowser.org/
Go to "Browse data"
Open the "settings" table
Find the entry with key "syncInfoCache"
Copy the data under in "value" cell and paste it in a text editor
Delete the "value" and save

Now Joplin should start, however please note that the sync state has been lost so I'm not sure what will happen. I think nothing special with filesystem sync but to be sure make a full backup of your data.

By the way would you mind sharing the content of the "syncInfoCache" you copied earlier so that we can see why it was corrupted in the first place?

lucklh · 2024-03-01T12:08:24.454Z

Thanks Laurent

I did as you recommended. But I still have a fatal error. It is a different one.
Ups - how can I add a new screenshot?

Error:SQLITE_CORRUPT: database disk image is malformed: SELECT count(*) as total FROM notes WHERE is_conflict = 1

at DatabaseDriverNode.sqliteErrorToJsError

laurent · 2024-03-01T12:11:26.984Z

It looks like your external drive is corrupted so the database is not being saved properly. I would suggest before doing anything else to make a copy of your profile on a different drive.

Do you have a backup of your data somewhere? Because you should probably restore all data from it.

First also run a disk check on your drive to confirm that there's indeed a problem there.

system · 2024-03-31T12:11:40.930Z

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.