clocking is empty

[ikegami4]

Thank you for a good project. I am not sure whether the .el is capturing clocking data. I can see data in healines and timestamps tables but cloking tables is empty. my .org file is as below. I do not get any error message when I do M-x org-sql-user-update . Please let me know if you need more information. Thank you.

test.org.txt

[ndwarshuis]

I can't reproduce; running org-sql-user-reset and org-sql-user-update gives me one entry in the clocking table as expected. What is the value of org-clock-into-drawer for you (mine is t)?

[ikegami4]

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 emacs. I wonder it can be a cause. I do not want to waste your time and let us give up now.

[brunoro]

@ikegami4 I had the same issue and fixed it by setting org-clock-into-drawer to t. Note that you have to run org-sql-user-reset or make some change to your org file before trying again, as org-sql checks if files were modified since last run by comparing checksums.

[ikegami4]

@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 issue?

[ndwarshuis]

@ikegami4 please keep it open since this might be an issue with running org-sql on spacemacs. Even if it is just a simple settings issue then at the very least the documentation should be changed to alert spacemacs users to any caveats like this.

Since I'm still not sure what the problem is, do you have more precise information as to what you have tried thus far? Is there a reason (setq org-clock-into-drawer t) doesn't work on spacemacs?

[ikegami4]

@ndwarshuis sorry for my late reply. I use org layer on spacemacs https://github.com/syl20bnr/spacemacs/tree/develop/layers/+emacs/org I did not find anything which may affect org-clock-into-drawer there. I tried adding (org :variables org-clock-into-drawer t) in dotspacemacs-configuration-layers '( ) on .spacemacs. Instead, I tried adding (setq org-clock-into-drawer t) in (defun dotspacemacs/user-config ()) on .spacemacs. To check whether either of these two gives me t for org-clock-into-drawer, I wrote (org-clock-into-drawer) on *scratch* buffer, and M-x eval-defun and it returned "LOGBOOK" instead of t.

[ndwarshuis]

@ikegami4 what does M-x org-version return?

[ikegami4]

@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]

@ikegami4 ok that's one possible issue, I've only tested this with the org version that came with emacs 26.3 (which is 9.1.9). I realize I say that it was tested with 9,x but this might not be specific enough.

Before I conclude that though, one thing I don't know yet is if this affects clocking or all logbook entries. What is the output when you run org-sql-dump-update-transactions with this:

* DONE foo
:LOGBOOK:
- State "DONE"       from "TODO"       [2020-06-17 Wed 09:13]
:END:

This will put all the SQL transactions in a buffer, and there should be one to insert the DONE/TODO change into a table called 'state_changes'.

[ikegami4]

@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 file and M-x org-sql-user-update. It changes headlines and timestamp tables but state_changes table is empty.

[ndwarshuis]

@ikegami4 ok in that case this is no longer just about clocking since it isn't picking up on other logbook entries either. Several things:

1. what are the values of org-sql-included-logbook-types, org-sql-store-clocks, and org-sql-store-clock-notes? Unless you changed the defaults these shouldn't be the problem but we should check first.
2. what is the value of org-log-note-headings?
3. please run org-sql-user-reset before org-sql-dump-update-transactions again and paste the output here (it should be in a buffer called "SQL: Org-update-dump")

[ikegami4]

@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 on .spacemacs :
(use-package org-sql :ensure t :config (setq org-sql-files '("~/Dropbox/org/test_org_sql.org")) )
2.
org-log-note-headings :
((done . "CLOSING NOTE %t") (state . "State %-12s from %-12S %t") (note . "Note taken on %t") (reschedule . "Rescheduled from %S on %t") (delschedule . "Not scheduled, was %S on %t") (redeadline . "New deadline from %S on %t") (deldeadline . "Removed deadline, was %S on %t") (refile . "Refiled on %t") (clock-out . ""))
3.
I did M-x org-sql-user-reset. M-x org-sql-dump-update-transactions still says no match.

[ndwarshuis]

@ikegami4
1 and 2 look fine. Please run (toggle-debug-on-error) and (org-sql-dump-update-transactions) non-interactively and then paste the exact error here.

[ikegami4]

@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 (org-sql-dump-update-transactions) nil nil 127) call-interactively(eval-expression nil nil) command-execute(eval-expression)

[ndwarshuis]

@ikegami4 my bad, try that with the 'develop' branch. I forgot I only put org-sql-dump-update-transactions in there for now