search

nobiot / Zero-to-Emacs-and-Org-roam

Step by step guide from zero to installing and setting up Emacs and Org-roam on Windows 10
Other
628 stars 47 forks source link

Windows 11: No EmacSQL SQLite binary available, aborting #19

Closed ghowoo closed 2 years ago

ghowoo commented 2 years ago

Roam is a very promising tool and I have followed the instructions to set up org roam on Windows. However, it still doesn't work. When I "C-c n l" to open a new org file, it just says "No EmacSQL SQLite binary available, aborting".

I did install gcc through msys64 and install sqlite3 and put them in the path. Any insights will be helpful if I should go to modify the roam .el file.

nobiot commented 2 years ago

Three things to begin with.

  1. I don’t know Windows 11. All I did is for Windows 10. I can only hope and assume that there is no or immaterial differences

  2. I don’t know what is msys64. I installed msys2. What did you install and how?

  3. What did you put in the path? Can you run cmd to open the command line prompt and then call gcc and sqlite3 inside the command line prompt? If you can’t, then the path is not correctly set.

If you installed msys2 with the official installer like I show in the guide, you shouldn’t have to set the path yourself; the installer does it for you (that’s what I get from my installation experienced, and confirmed multiple times). This suggests to me that you didn’t use the installer or something different is done

nobiot commented 2 years ago

One more thing. What is roam.el?

ghowoo commented 2 years ago

Thanks nobiot. You are very helpful. The problem has been solved.

I had installed msys2 64, not msys64. Sorry for the confusion, however, the default folder name is msys64. But I didn't set C:\msys64\user\bin to the path. After I set the path, roam works.

Great work!

nobiot commented 2 years ago

Good to know that Windows 11 also works. Thank you.