search

d12frosted / vulpea

A collection of functions for note taking based on `org` and `org-roam`.
GNU General Public License v3.0
230 stars 12 forks source link

Org-roam-db issue, "SQL logic error" "no such table: notes" 1 1 #183

Open DominikMendel opened 2 weeks ago

DominikMendel commented 2 weeks ago

I'm not sure if this is related to Vulpea behavior, or my setup with Vulpea and Org-roam. But see the Discourse thread I opened in org-roam with the bug info and comments : https://org-roam.discourse.group/t/emacsql-sql-logic-error-no-such-table-notes-1-1/3520.

Original issue: Recently my org-roam-db has been having a lot of issues with a lot of files. Here is a sample: ⛔ Error (org-roam): Failed to process /home/user/Dropbox/org/roam/daily/Personal 2021-09-10.org with error EmacSQL had an unhandled condition: nil, nil, nil, ("SQL logic error" "no such table: notes" 1 1), skipping...

There are hundred of entires it’s having issues with. I have tried: A resync. A org-roam-db-clea-all into a resync. Deleting the roam-db file at the org-roam-db-location and syncing again.

d12frosted commented 2 weeks ago

Hey @DominikMendel

I lack information to provide any educated help. So please provide the following information.

  1. Vulpea setup code. A link to your configs where it can be reproduced would be neat.
  2. Where exactly does it occur? What do you do?
  3. In case you can't really answer the previous question, please enable debug on error via M-x toggle-debug-on-error and share stack trace once the error occurs.