# Upgraded org-roam, sqlite3 troubles with windows 10

**URL:** <https://org-roam.discourse.group/t/upgraded-org-roam-sqlite3-troubles-with-windows-10/595>\
**Category:** Troubleshooting\
**Created:** [August 2, 2020, 6:41pm UTC](https://org-roam.discourse.group/t/upgraded-org-roam-sqlite3-troubles-with-windows-10/595 "2020-08-02T18:41:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mngz](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mngz](https://org-roam.discourse.group/u/mngz)\
**Post date:** [August 2, 2020, 6:41pm UTC](https://org-roam.discourse.group/t/upgraded-org-roam-sqlite3-troubles-with-windows-10/595/1 "2020-08-02T18:41:16Z")

</div>

I just upgraded org-roam to the latest version and the database is no longer working. I’ve been getting a “Cannot find executable “sqlite3”!” error when attempting to add org-roam links.

I am on Windows 10, using org-roam with spacemacs and used scoop to manually compile the binary for sqlite [as per the installation guide here](https://org-roam.readthedocs.io/en/master/installation/).

I think as of the latest version of org-roam sqlite3 is the new default? Does that mean I would have to install the sqlite3 package in emacs as well? I have tried, through the package install menu (but not properly adding it to my .spacemacs).

I’ve tried to add (add-to-list 'exec-path “c:/sqlite”) to my .spacemacs user-config layers after putting sqlite3.exe etc in that folder, as well as adding that to the PATH.

I can also run (executable-find “sqlite3”) and it returns “c:/sqlite/sqlite3”.

What am I missing? I’m at a bit of a loss for what else to try, I wouldn’t even mind reverting back to an older version if possible, I’ve been using org-roam a lot and it’s worked fairly seamlessly until now.

---

<div class="post-metadata">

**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:** [August 3, 2020, 7:01am UTC](https://org-roam.discourse.group/t/upgraded-org-roam-sqlite3-troubles-with-windows-10/595/2 "2020-08-03T07:01:46Z")

</div>

Yes, you now need the SQLite executable available at [https://sqlite.org](https://sqlite.org), and also the [emacsql-sqlite3 package](https://melpa.org/#/emacsql-sqlite3).

Not sure why you still get the error “Cannot find executable “sqlite3”!”, when you “can also run (executable-find “sqlite3”) and it returns “c:/sqlite/sqlite3””.

I would have thought installing `emacsql-sqlite3` was automatic, but perhaps spacemacs has its own way of managing packages (I have no idea about spacemacs)? It’s a different sqlite3 package from when we had to compile our own executable, so you might need a separate installation.