I'm getting a "Disk Image Is Malformed" error

[sebhrivas]

Hi, I was trying to import my highlights to add new books I read since the last time I imported them but I am getting this error

Error: database disk image is malformed at f.handleError (plugin:obsidian-kobo-highlights-importer-plugin:599:19) at c.step (plugin:obsidian-kobo-highlights-importer-plugin:326:31) at Repository.parseContentStatement (plugin:obsidian-kobo-highlights-importer-plugin:17700:22) at Repository.eval (plugin:obsidian-kobo-highlights-importer-plugin:17659:29) at Generator.next (<anonymous>) at eval (plugin:obsidian-kobo-highlights-importer-plugin:54:61) at new Promise (<anonymous>) at __async (plugin:obsidian-kobo-highlights-importer-plugin:38:10) at Repository.getAllContentByBookTitleOrderedByContentId (plugin:obsidian-kobo-highlights-importer-plugin:17654:12) at HighlightService.eval (plugin:obsidian-kobo-highlights-importer-plugin:17491:40)

How can I fix it?

[OGKevin]

On what version are you getting this?
Have you tried on other versions as well?

[sebhrivas]

I'm running Obsidian 1.5.11 and the plugin is 2.0.0 — how could I try in other versions?

[OGKevin]

go to the releases: https://github.com/OGKevin/obsidian-kobo-highlights-import/releases
find one, download the plugin zip and extract it in the folder below.

[Your Vault]/.obsidian/plugins/

specifically, the main.js needs to get replaced.

[sebhrivas]

Thanks for the instructions. Just tried with v1.5.4 and the 1.6.0-beta.2 and I get the same error.

[OGKevin]

Ah, I forgot to mention that you must restart obsidian after manually changing the plugin folder.

Next to this, can you try to open that database in a DB app like https://tableplus.com/ and see if that can actually open and read the DB?

If multiple versions is giving you trouble and another app can't open the DB, then it sounds more like a DB issue rather than an app issue. .e.g. corrupted DB or wrong file.

Also, what is your e-reader model?

[sebhrivas]

Hi, first of all thanks for all your help so far, really appreciate it!
I did restart Obsidian every time I changed the plugin version + connected and disconnected the Kobo.
So, I couldn't figure out how to open the DB with tableplus but I searched for an online tool to open it and you can see it does open and it has the books + bookmarks there so it seems like the DB is not corrupt.

My Kobo is a Clara HD and I always keep it updated.

[sebhrivas]

@OGKevin Hi, any other suggestion on this?

[OGKevin]

No not really 🤔 I can't seem to reproduce this issue.
And if you are the only one with this issue, I'm afraid it might be an issue on your end.

Did you try a different computer by any chance?
What if you create a copy of the database?
What if you manually create a new database, and then export the data out of the old one into the new one? Does that export button in your screen shot export to SQL statements that you can use to manually import.

This rules out at least if its a plugin issue or a DB issue.
E.g. if that manually created DB with data works, then its a DB issue.
Or it could be a data issue, maybe there is some weird characters/data in the DB?

Can you also try to manually execute the query that fails:

obsidian-kobo-highlights-import/src/database/repository.ts

Line 158 in 7b12749

`select Title, ContentID, ChapterIDBookmarked, BookTitle from "content" where BookTitle = $bookTitle order by "ContentID"`,