# EmacSQL SQL logic error : No such table: notes 1 1 **URL:** \ **Category:** Troubleshooting\ **Created:** [June 30, 2024, 1:17am UTC](https://org-roam.discourse.group/t/emacsql-sql-logic-error-no-such-table-notes-1-1/3520 "2024-06-30T01:17:43Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Dominik](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@Dominik](https://org-roam.discourse.group/u/Dominik)\ **Post date:** [June 30, 2024, 1:17am UTC](https://org-roam.discourse.group/t/emacsql-sql-logic-error-no-such-table-notes-1-1/3520/1 "2024-06-30T01:17:43Z")
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. ---
**Author:** ![nobiot](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/nobiot/32/159_2.png) [@nobiot](https://org-roam.discourse.group/u/nobiot)\ **Post date:** [June 30, 2024, 10:07am UTC](https://org-roam.discourse.group/t/emacsql-sql-logic-error-no-such-table-notes-1-1/3520/2 "2024-06-30T10:07:46Z")
One thing you could check is the value of `org-roam-database-connector`. If it is not `sqlite-builtin`, try it. The docstring says this: > If you are using Emacs 29, then the recommended connector is > ‘sqlite-builtin’, which uses the new builtin support for SQLite. > You need to install the ‘emacsql-sqlite-builtin’ package to use > this connector. ---
**Author:** ![akashp](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/akashp/32/1383_2.png) [@akashp](https://org-roam.discourse.group/u/akashp)\ **Post date:** [June 30, 2024, 12:44pm UTC](https://org-roam.discourse.group/t/emacsql-sql-logic-error-no-such-table-notes-1-1/3520/3 "2024-06-30T12:44:12Z")
You installed some extension to org roam then forgot. There is no notes table in the database. I suspect you were using vulpea. ---
**Author:** ![Dominik](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@Dominik](https://org-roam.discourse.group/u/Dominik)\ **Post date:** [June 30, 2024, 11:35pm UTC](https://org-roam.discourse.group/t/emacsql-sql-logic-error-no-such-table-notes-1-1/3520/4 "2024-06-30T23:35:38Z")
Yes I’m already using `sqlite-builtin` for `org-roam-database-connector`. I’m on Doom, they might’ve done that for me. ---
**Author:** ![Dominik](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@Dominik](https://org-roam.discourse.group/u/Dominik)\ **Post date:** [June 30, 2024, 11:36pm UTC](https://org-roam.discourse.group/t/emacsql-sql-logic-error-no-such-table-notes-1-1/3520/5 "2024-06-30T23:36:08Z")
This is correct. I am using Vulpea. So is the problem then that Vulpea is adding an additional entry to the database? ---
**Author:** ![akashp](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/akashp/32/1383_2.png) [@akashp](https://org-roam.discourse.group/u/akashp)\ **Post date:** [July 1, 2024, 3:08am UTC](https://org-roam.discourse.group/t/emacsql-sql-logic-error-no-such-table-notes-1-1/3520/6 "2024-07-01T03:08:02Z")
no - we merely uncovered the condition-of-possibility of such an error. We can infer now that a function call is happening that presumes vulpea definitions are in order- that the database has been informed, etc. But this function call cannot get the requisite details from the database. My first step of inquiry should be in disabling vulpea definitions and re-initiating vulpea however its done. The problem should lie somewhere here.