no such table: ZACCOUNT (SQLite3::SQLException)

[iwan-uschka]

Unfortunately i receive the following message when running ruby notes_cloud_ripper.rb --file path/to/NotesV7.storedata:

Starting Apple Notes Parser at Sat Jan 23 22:12:56 2021
Storing the results in ./output/2021_01_23-22_12_56

Created a new AppleBackup from single file: /Users/iwanuschka/Desktop/apple_cloud_notes_parser/output/2021_01_23-22_12_42/notes.sqlite
Guessed Notes Version: 8
Traceback (most recent call last):
	9: from notes_cloud_ripper.rb:122:in `<main>'
	8: from /Users/iwanuschka/Desktop/apple_cloud_notes_parser/lib/AppleBackup.rb:124:in `rip_notes'
	7: from /Users/iwanuschka/Desktop/apple_cloud_notes_parser/lib/AppleBackup.rb:124:in `each'
	6: from /Users/iwanuschka/Desktop/apple_cloud_notes_parser/lib/AppleBackup.rb:126:in `block in rip_notes'
	5: from /Users/iwanuschka/Desktop/apple_cloud_notes_parser/lib/AppleNoteStore.rb:185:in `rip_all_objects'
	4: from /Users/iwanuschka/Desktop/apple_cloud_notes_parser/lib/AppleNoteStore.rb:324:in `rip_accounts'
	3: from /Users/iwanuschka/.rvm/gems/ruby-2.6.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:193:in `execute'
	2: from /Users/iwanuschka/.rvm/gems/ruby-2.6.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `prepare'
	1: from /Users/iwanuschka/.rvm/gems/ruby-2.6.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `new'
/Users/iwanuschka/.rvm/gems/ruby-2.6.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `initialize': no such table: ZACCOUNT (SQLite3::SQLException)

My system:

• Mac OS 11.1
• ruby 2.6.0p0 (2018-12-25 revision 66547) [x86_64-darwin20]
• rvm 1.29.12 (latest) by Michal Papis, Piotr Kuczynski, Wayne E. Seguin [https://rvm.io]

I reinstalled ruby including (?) openssl like

rvm reinstall ruby-2.6.0 --with-openssl-dir=/usr/local/opt/openssl
rvm reload

Hope you can help me because i just lost all my notes :/ The data seems to be still there but cannot be retrieved correctly.

[iwan-uschka]

On my part, there is no pressure here. I found another way to recover the data: ydkhatri/mac_apt#46 (comment).