# Installation of Org-Roam fails

**URL:** <https://org-roam.discourse.group/t/installation-of-org-roam-fails/3676>\
**Category:** Troubleshooting\
**Created:** [November 22, 2024, 10:34pm UTC](https://org-roam.discourse.group/t/installation-of-org-roam-fails/3676 "2024-11-22T22:34:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![juajua](https://avatars.discourse-cdn.com/v4/letter/j/8e8cbc/32.png) [@juajua](https://org-roam.discourse.group/u/juajua)\
**Post date:** [November 22, 2024, 10:34pm UTC](https://org-roam.discourse.group/t/installation-of-org-roam-fails/3676/1 "2024-11-22T22:34:59Z")

</div>

I try to install Org-Roam on my Mac (with Sequoia), but it fails. Here are my steps:

1.) In .emacs I initialize the MELPA-archive

(use-package package  
:config  
(add-to-list 'package-archives '(“melpa-stable” . “[Package Listing](https://stable.melpa.org/packages/)”))  
(package-initialize))

2.) Later I try to install ORG-ROAM with:

(use-package org-roam  
:ensure t  
:demand t ;; Ensure org-roam is loaded by default  
:init  
(setq org-roam-v2-ack t)  
:custom  
(org-roam-completion-everywhere t)  
:config  
(org-roam-db-autosync-mode)  
(require 'org-roam-protocol)  
(org-roam-setup)  
)

3.) But this fails with:

Debugger entered–Lisp error: (error “Package ‘emacsql-sqlite’ (version 1.0.0) is unavai…”)  
signal(error (“Package ‘emacsql-sqlite’ (version 1.0.0) is unavai…”))  
error(“Package `emacsql-sqlite’ (version 1.0.0) is unavai…”)  
package-compute-transaction((#s(package-desc :name org-roam :version (2 2 2) :summary “A database abstraction layer for Org-mode” :reqs ((emacs (26 1)) (dash (2 13)) (org (9 4)) (emacsql (3 0 0)) (emacsql-sqlite (1 0 0)) (magit-section (3 0 0))) :kind tar :archive “MELPA-STABLE” :dir nil :extras ((:url . “[GitHub - org-roam/org-roam: Rudimentary Roam replica with Org-mode](https://github.com/org-roam/org-roam)”)  
package-compute-transaction(nil ((org-roam)))  
package-install(org-roam)  
use-package-ensure-elpa(org-roam (t) (:demand t))

4.) It seem org-roam (2.2.2) requires emacsql-sqlite (1.0.0), but this package is no longer available in MELPA\_STABLE.

How can I fix this?

---

<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:** [November 22, 2024, 11:12pm UTC](https://org-roam.discourse.group/t/installation-of-org-roam-fails/3676/2 "2024-11-22T23:12:28Z")

</div>

I suggest not to use MELPA-stable and instead use MELPA.

Also, review [Getting Started](https://melpa.org/#/getting-started). I don’t see where you specify the URL.

---

<div class="post-metadata">

**Author:** ![juajua](https://avatars.discourse-cdn.com/v4/letter/j/8e8cbc/32.png) [@juajua](https://org-roam.discourse.group/u/juajua)\
**Post date:** [November 22, 2024, 11:55pm UTC](https://org-roam.discourse.group/t/installation-of-org-roam-fails/3676/5 "2024-11-22T23:55:58Z")

</div>

I tried this code in ~/.emacs, but it causes the same problem.

(require 'package)  
(add-to-list 'package-archives '(“melpa” . “[Package Listing](https://melpa.org/packages/)”) t)  
(package-initialize)

It seems the Discourse app changes the Melpa-org URL to the string “Package Listing”. But I added the correct URL like documented in the document “Getting Started”.

I don’t think that’s the problem. Other MELPA packages are correctly installed.

The package ‘emacsql-sqlite’ is not listed on MELPA and not on MELPA-STABLE.

---

<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:** [November 23, 2024, 8:13am UTC](https://org-roam.discourse.group/t/installation-of-org-roam-fails/3676/6 "2024-11-23T08:13:06Z")

</div>

I think what you may be missing in your steps is `M-x package-refresh-contents` or `M-x package-list-packages`. I use the latter in the video I share below.

These are noted in “[Getting started](https://melpa.org/#/getting-started)” of MELPA.

> Note that you’ll need to run `M-x package-refresh-contents` or `M-x package-list-packages` to ensure that Emacs has fetched the MELPA package list before you can install packages with `M-x package-install` or similar.

The current version available in MELPA does not require `emacsql-sqlite`. See this screenshot from Emacs. Note it equires `emacsql` (not `emacsql-sqlite`).

 ![20241123-org-roam](https://global.discourse-cdn.com/free1/uploads/orgroam/original/2X/0/047a7c22526bd3918252fcd4286c4407140cb423.png)

Here is a [40-second video](https://nobiot.com/assets/shared/20241123_org-roam-install.webm) where I install Org-roam (video taken on 2024-11-23). I have no problem. The steps are simply this:

1. Paste the snippet from MELPA
2. Evaluate the snippet
3. `M-x package-list-packages`
4. Wait for Emacs to fetch the MELPA package list (wait for “Loading” to finish)
5. Find `org-roam`
6. Install `org-roam`

---

<div class="post-metadata">

**Author:** ![juajua](https://avatars.discourse-cdn.com/v4/letter/j/8e8cbc/32.png) [@juajua](https://org-roam.discourse.group/u/juajua)\
**Post date:** [November 23, 2024, 6:38pm UTC](https://org-roam.discourse.group/t/installation-of-org-roam-fails/3676/7 "2024-11-23T18:38:26Z")

</div>

My solution is:

Add to ~/.emacs:

(require 'package)  
(add-to-list 'package-archives '(“melpa” . MELPA-URL) t)  
(package-initialize)  
(package-refresh-contents)

And later:

(use-package org-roam …

Then restart EMACS. This installs all my packages.
