Munenobu Ikegami

https://github.com/org-roam/org-roam/issues/1732#issuecomment-1465326574 looks related to this issue and it worked for me

Thank you for the response. (org-clock-into-drawer) returned "LOGBOOK" . Then, I add (setq org-clock-into-drawer t) and (org-clock-into-drawer) still returns "LOGBOOK" I am using spacemacs and I guess you are using...

@brunoro Thank you for your message. I tried it again. I think the problem is how to set `org-clock-into-drawer` to `t` on spacemacs rather than org-sql. Should I close this...

@ndwarshuis sorry for my late reply. I use org layer on spacemacs [https://github.com/syl20bnr/spacemacs/tree/develop/layers/+emacs/org](url) I did not find anything which may affect `org-clock-into-drawer` there. I tried adding `(org :variables org-clock-into-drawer t)`...

@ndwarshuis `M-x org-version` returns `org mode version 9.3.2 9.3.2-24-g5c72d6-elpaplus @ /home/username/.emacs.d./elpa/26.3/develop/org-puls-contrib-20200203/`

@ndwarshuis sorry I tried but I could not eval `org-sql-dump-update-transactions` M-x says no match and eval-defun says symbol's function defiition is void. I added your 4 lines above to .org...

@ndwarshuis sorry for my late reply. 1. `org-sql-included-logbook-types` : `(done state note reschedule delschedule redeadline deldeadline refile)` `org-sql-store-clocks` : `t` `org-sql-store-clock-notes` : `t` The following is my setting for org-sql...

@ndwarshuis I did `M-: (toggle-debug-on-error) Enter` `M-: (org-sql-dump-update-transactions) Enter` and the following is on `*Backtrace*` buffer: ` Debugger entered--Lisp error: (void-function org-sql-dump-update-transactions) (org-sql-dump-update-transactions) eval((org-sql-dump-update-transactions) nil) eval-expression((org-sql-dump-update-transactions) nil nil 127) funcall-interactively(eval-expression...

@ndwarshuis sorry for my late reply... I did the followings: clone develop branch M-: (toggle-debug-on-error) Enter M-: (org-sql-dump-update-transactions) Enter and the following is on *Backtrace* buffer: ` Debugger entered--Lisp error:...

@ndwarshuis sorry I should have commented out ` (use-package org-sql :ensure t :config (setq org-sql-files '("~/Dropbox/org/test_org_sql.org")) ` on .spacemacs. my current revised setting is ` (add-to-list 'load-path "~/org_sql/") (require 'org-sql)...