bandantonio / obsidian-apple-books-highlights-plugin

Import highlights and notes from your Apple Books to Obsidian
https://obsidian.md/plugins?id=apple-books-import-highlights
MIT License
44 stars 2 forks source link

Parse error near line 2: no such table: ZAEANNOTATION #17

Closed vsiisv closed 5 months ago

vsiisv commented 5 months ago

Description the bug The plugin is not working. not with the commands, not with the icon in sidebar. getting this error in console output:

Error: Command failed: echo " SELECT ZASSETID, ZTITLE, ZAUTHOR, ZGENRE, ZLANGUAGE, ZLASTOPENDATE, ZCOVERURL FROM ZBKLIBRARYASSET WHERE ZPURCHASEDATE IS NOT NULL" | sqlite3 ~/Downloads/test-BKLibrary.sqlite -json Parse error near line 2: no such table: ZBKLIBRARYASSET

Error: Command failed: echo " SELECT ZANNOTATIONASSETID, ZFUTUREPROOFING5, ZANNOTATIONREPRESENTATIVETEXT, ZANNOTATIONSELECTEDTEXT, ZANNOTATIONNOTE, ZANNOTATIONCREATIONDATE, ZANNOTATIONMODIFICATIONDATE, ZANNOTATIONSTYLE FROM ZAEANNOTATION WHERE ZANNOTATIONSELECTEDTEXT IS NOT NULL AND ZANNOTATIONDELETED IS 0" | sqlite3 ~/Downloads/empty-AEAnnotation_v10312011_1727_local.sqlite -json Parse error near line 2: no such table: ZAEANNOTATION

Also include the following details:

General information

To Reproduce Steps to reproduce the behavior:

  1. option+command --> Apple Books import command
  2. with icon in sidebar
  3. See error

Expected behavior importing some highlights

Screenshots

Additional context getting this error in console:

roman1gan commented 5 months ago

me too 🙁

bandantonio commented 5 months ago

@vsiisv @roman1gan Thanks for reporting 🤝. This was an unintentional bug after testing responses from databases. Please update the plugin to the latest 1.2.3 version.

vsiisv commented 5 months ago

Thanks a lot. It works =)