Org-roam on emacs28.1 cant find emacsql-sqlite definition

Previously org-roam has been functioning with no problems, however after the latest update via package org-roam is having trouble finding the definition of emacsql-sqlite despite emacsql being installed.

I’ve reinstalled org-roam and emacsql to no avail. I’ve also tried using emacs 29.4, but it also does not solve the problem. The same problem also presents itself with emacs -q and following the suggestions for troubleshooting. I’m at a loss.

The backtrace when using emacs --debug-init is:

Debugger entered–Lisp error: (void-function emacsql-sqlite)
emacsql-sqlite(“~/.emacs.d/org-roam.db”)
org-roam-db()
org-roam-db-query([:select [ref nodes:file id pos title type] :from refs :left-join nodes :on (= refs:node-id nodes:id) :where (= type $s1)] “cite”)
orb-get-db-cite-refs()
orb-make-notes-cache()
org-roam-bibtex-mode()
eval-buffer(#<buffer load> nil “/home/pete/.emacs” nil t) ; Reading at buffer position 24003
load-with-code-conversion(“/home/pete/.emacs” “/home/pete/.emacs” t t)
load(“~/.emacs” noerror nomessage)
startup–load-user-init-file(#f(compiled-function () #<bytecode -0x5685283fed8bf4>) #f(compiled-function () #<bytecode -0x1f3c686ddc0ca9b5>) t)
command-line()
normal-top-level()

Any suggestions for next steps in troubleshooting appreciated.

I think this will help:

Thanks for responding. The versions of emacsql that i have available are:

melpa - 20241201.1551
melpa stable - 4.1.0
nongnu - 4.1.0

I have 20241201.1551 installed. Is the library version a problem here by any chance? I note that in your reply your referred to version 20241117.1614.

Ok I upgraded to a different build of emacs29.4 which was obviously compiled with the right flags and now all is good. Thanks for your help again.

1 Like