On 01.02.23 12:10, Basil L. Contovounesios wrote:
> Gregor Kling [2023-02-01 09:00 +0100] wrote:
> 
>> The use of org-roam reveals only the symptom.
>>

> Have you tried updating/reinstalling your EmacSQL packages?

Yes.

> What versions do you have installed?

  Status: Installed in ‘emacsql-3.1.1/’ (unsigned).
     Version: 3.1.1


> Your examples evaluate for me without error on Emacs 29 and 30, with
> emacsql, emacsql-sqlite, and emacs-sqlite-builtin version
> 3.1.1.50snapshot0.20230120.213337 installed from NonGNU-devel ELPA.
Package emacsql-sqlite-builtin is installed.

      Status: Installed in ‘emacsql-sqlite-builtin-20221127.2146/’ 
(unsigned).
     Version: 20221127.2146

There is no functional difference between 
3.1.1.50snapshot0.20230120.213337 and emacsql-sqlite-builtin-20221127.2146:

diff emacsql-sqlite-builtin.el 
~/.emacs.d/elpa/emacsql-sqlite-builtin-20221127.2146/emacsql-sqlite-builtin.el
8c8,9
< ;; Package-Version: 3.1.1.50-git
---
> ;; Package-Version: 20221127.2146
> ;; Package-X-Original-Version: 3.1.1.50-git
9a11
> ;; Package-Commit: 6b2e65bdf785364cf7c34c31fea5812e1e58c657


> If they still don't work for you after updating/reinstalling, I suggest
> reporting the issue on the EmacSQL issue tracker[2].
> 
> [2] https://github.com/magit/emacsql/issues
> 

The fact that it is working for you, means there must
be some issue with my setup.

Before going down the road of further reporting, it seems to me i have 
to dig in front of my own door..

Thanks for the pointers.

> In case it's relevant: the EmacSQL packages are distributed by the Emacs
> project only on NonGNU-devel ELPA[3][4][5], not NonGNU ELPA[6] which is
> what the user option package-archives points to by default.
> 
> [3] https://elpa.nongnu.org/nongnu-devel/emacsql.html
> [4] https://elpa.nongnu.org/nongnu-devel/emacsql-sqlite.html
> [5] https://elpa.nongnu.org/nongnu-devel/emacsql-sqlite-builtin.html
> [6] https://elpa.nongnu.org/nongnu/
> 
> The EmacSQL packages are also distributed by MELPA[7][8][9], and have
> been for longer.
> 
> [7] https://melpa.org/#/emacsql
> [8] https://melpa.org/#/emacsql-sqlite
> [9] https://melpa.org/#/emacsql-sqlite-builtin
> 
> However, emacsql-sqlite-builtin doesn't seem to be available on MELPA
> Stable[10].
> 
> [10] https://stable.melpa.org
> 
> It seems like there were some issues with updating the packages from
> MELPA a few months ago[11], but I presume those have been fixed now.
> 
> [11] https://github.com/magit/emacsql/issues/103
> 
> HTH,
> 

-- 
Gregor Kling

Abteilung ITS, Sachgebiet ITS-N
Anwendungsentwicklung (IPAM, Tooling, Automation)
DNS, DHCP
Technische Hochschule Mittelhessen
University of Applied Sciences
Tel: 0641/309-1292
E-Mail: gregor.kling@its.thm.de