`emacsql-sqlite` is installed but seems to be catastrophically redundant.

[peteWT]

I've scoured scimax-jupyter, user.el, init.el and can't seem to find where exclude emacsql-sqlite from the dependency graph. Thanks for any insight on this.

⛔ Error (use-package): scimax-jupyter/:catch: Eager macro-expansion failure: (void-function compat--plist-get)
⛔ Emergency (emacsql): Uninstall all `emacsql-*' packages.

All EmacSQL back-ends are now distributed as part of the `emacsql'
package itself, and you must uninstall all `emacsql-*' packages.
These packages now do nothing but display this warning, but if they
are located earlier on the `load-path' than `emacsql' is, then they
prevent the respective libraries from `emacsql' from being loaded,
rendering EmacSQL unusable.

⛔ Error (use-package): scimax-contacts/:catch: Symbol’s function definition is void: emacsql-sqlite

[jkitchin]

maybe you have some old .elc files around? I don't think there are any references to emacsql in scimax anymore.

if you see any thing from running this in your scimax directory:

grep emacsql *.el

it probably means you need to update the scimax files. that might be as easy as git pull in the repo.

[peteWT]

just pulled it looks like there are a lot of references:

❯ pwd
/opt/homebrew/Cellar/scimax/3.0/share/emacs/site-lisp/scimax
❯ grep emacsql *.el
org-db-agenda.el:                (emacsql org-db [:select [headlines:level headlines:title headlines:tags
org-db-agenda.el:            (emacsql org-db [:select [headlines:level headlines:title headlines:tags
org-db-agenda.el:           (emacsql org-db [:delete :from files :where (= rowid $s2)] filename-id)
org-db-fulltext.el:     (unless (and org-db-ft (emacsql-live-p org-db-ft))
org-db-fulltext.el:       (setq org-db-ft (emacsql-sqlite (expand-file-name org-db-fulltext org-db-root) :debug t)))
org-db-fulltext.el:       (emacsql-close org-db-ft)
org-db-fulltext.el:       (emacsql-close org-db-ft)
org-db-fulltext.el: (emacsql org-db-ft [:create-virtual-table :if :not :exists fulltext
org-db-fulltext.el:   (emacsql org-db-ft [:delete :from fulltext :where (= filename $s1)] (buffer-file-name))
org-db-fulltext.el:   (emacsql org-db-ft [:insert :into fulltext :values [$s1 $s2]]
org-db-fulltext.el:emacsql query like :match '\"something.\" Alternatively, I may
org-db-fulltext.el:          (emacsql org-db-ft [:select [contents filename] :from fulltext]))))
org-db-images.el: (emacsql org-db [:create-table :if :not :exists images
org-db-images.el:     (emacsql org-db [:delete :from images :where (= images:filename-id $s1)]
org-db-images.el:         (emacsql org-db [:insert :into images :values [nil $s1 $s2 $s3 $s4]]
org-db-images.el:            (emacsql org-db [:select [images:text
org-db-images.el:  (let ((imgs (mapcar 'car (with-org-db (emacsql org-db [:select images:img-filename :from images])))))
org-db-images.el:       (emacsql org-db [:delete :from images :where (= images:img-filename $s1)]
org-db.el:;; you can build emacsql queries on org-db to do lots of things.
org-db.el:(use-package emacsql-sqlite)
org-db.el:     (unless (and org-db (emacsql-live-p org-db))
org-db.el:       (setq org-db (emacsql-sqlite (expand-file-name org-db-name org-db-root) :debug t)))
org-db.el: (emacsql org-db [:PRAGMA (= foreign_keys 1)])
org-db.el: (emacsql org-db [:create-table :if :not :exists files
org-db.el: (emacsql org-db [:create-table :if :not :exists tags
org-db.el: (emacsql org-db [:create-table :if :not :exists properties
org-db.el: (emacsql org-db [:create-table :if :not :exists keywords
org-db.el: (emacsql org-db [:create-table :if :not :exists headlines
org-db.el: (emacsql org-db [:create-table :if :not :exists headline-tags
org-db.el: (emacsql org-db [:create-table :if :not :exists headline-properties
org-db.el: (emacsql org-db [:create-table :if :not :exists file-keywords
org-db.el: (emacsql org-db [:create-table :if :not :exists links
org-db.el: (emacsql org-db [:create-table :if :not :exists targets
org-db.el: (emacsql org-db [:create-table :if :not :exists file-targets
org-db.el: (emacsql org-db [:create-table :if :not :exists hashtags
org-db.el: (emacsql org-db [:create-table :if :not :exists file-hashtags
org-db.el: (emacsql org-db [:create-table :if :not :exists atlabels
org-db.el: (emacsql org-db [:create-table :if :not :exists file-atlabels
org-db.el: (emacsql org-db [:create-table :if :not :exists email-addresses
org-db.el: (emacsql org-db [:create-table :if :not :exists file-email-addresses
org-db.el: (emacsql org-db [:create-table :if :not :exists file-editmarks
org-db.el: (emacsql org-db [:create-table :if :not :exists src-blocks
org-db.el:    (caar (emacsql org-db [:select rowid :from files
org-db.el:  (emacsql org-db [:insert :into files :values [nil $s1 $s2 $s3]]
org-db.el:  (caar (emacsql org-db [:select (funcall last-insert-rowid)]))))))
org-db.el:       (emacsql org-db [:delete :from links :where (= links:filename-id $s1)] filename-id)
org-db.el:       (emacsql org-db [:delete :from file-keywords
org-db.el:       (emacsql org-db [:delete :from headlines :where (= headlines:filename-id $s1)]
org-db.el:       (emacsql org-db [:delete :from files :where (= rowid $s2)] filename-id)
org-db.el:   (emacsql org-db [:delete :from src-blocks
org-db.el:     (emacsql org-db [:insert :into src-blocks :values [nil $s1 $s2 $s3 $s4]]
org-db.el:     (emacsql org-db [:delete :from file-keywords
org-db.el:        (setq keyword-id (or (caar (emacsql org-db [:select rowid :from keywords
org-db.el:                 (emacsql org-db [:insert :into keywords :values [nil $s1]]
org-db.el:                 (caar (emacsql org-db
org-db.el:        (emacsql org-db [:insert :into file-keywords :values [nil $s1 $s2 $s3 $s4]]
org-db.el:     (emacsql org-db [:delete :from file-hashtags
org-db.el:        (setq hashtag-id (or (caar (emacsql org-db [:select rowid :from hashtags
org-db.el:                 (emacsql org-db [:insert :into hashtags :values [nil $s1]]
org-db.el:                 (caar (emacsql org-db
org-db.el:        (emacsql org-db [:insert :into file-hashtags :values [nil $s1 $s2 $s3]]
org-db.el:   (emacsql org-db [:delete :from file-targets :where (= file-targets:filename-id $s1)] filename-id)
org-db.el:       (let ((target-id (or (caar (emacsql org-db [:select rowid :from targets
org-db.el:              (emacsql org-db [:insert :into targets :values [nil $s1]]
org-db.el:              (caar (emacsql org-db
org-db.el:   (emacsql org-db [:insert :into file-targets :values [nil $s1 $s2 $s3]]
org-db.el:     (emacsql org-db [:delete :from file-editmarks
org-db.el:        (emacsql org-db [:insert :into file-editmarks
org-db.el:     (emacsql org-db [:delete :from file-email-addresses
org-db.el:        (setq email-address-id (or (caar (emacsql org-db [:select rowid :from email-addresses
org-db.el:                   (emacsql org-db [:insert :into email-addresses :values [nil $s1]]
org-db.el:                   (caar (emacsql org-db
org-db.el:        (emacsql org-db [:insert :into file-email-addresses :values [nil $s1 $s2 $s3]]
org-db.el:     (emacsql org-db [:delete :from file-atlabels
org-db.el:        (setq atlabel-id (or (caar (emacsql org-db [:select rowid :from atlabels
org-db.el:                 (emacsql org-db [:insert :into atlabels :values [nil $s1]]
org-db.el:                 (caar (emacsql org-db
org-db.el:        (emacsql org-db [:insert :into file-atlabels :values [nil $s1 $s2 $s3]]
org-db.el:     (emacsql org-db [:delete :from links :where (= links:filename-id $s1)] filename-id)
org-db.el:       (emacsql org-db [:insert :into links :values $v1] handle)
org-db.el:     (emacsql org-db [:delete :from headlines :where (= headlines:filename-id $s1)]
org-db.el:        (emacsql org-db [:insert :into headlines :values $v1] hlv)
org-db.el:        (setq headline-id (caar (emacsql org-db
org-db.el:        (emacsql org-db [:delete :from headline-tags
org-db.el:              (or (caar (with-org-db (emacsql org-db [:select rowid :from tags
org-db.el:               (emacsql org-db [:insert :into tags :values [nil $s1]]
org-db.el:               (caar (emacsql org-db [:select (funcall last-insert-rowid)])))))
org-db.el:             (emacsql org-db [:insert :into headline-tags :values $v1]
org-db.el:        (emacsql org-db [:delete :from headline-properties
org-db.el:                (with-org-db (emacsql org-db [:select rowid :from properties
org-db.el:                (emacsql org-db [:insert :into properties
org-db.el:                (caar (emacsql org-db [:select (funcall last-insert-rowid)])))))
org-db.el:             (emacsql org-db [:insert :into headline-properties
org-db.el:      (null (caar (with-org-db (emacsql org-db [:select [md5] :from files
org-db.el:            (caar (with-org-db (emacsql org-db [:select [md5] :from files
org-db.el:      (emacsql org-db [:update files :set (= md5 $s1) :where (= rowid $s2)]
org-db.el:      (emacsql org-db [:update files :set (= last-updated $s1) :where (= rowid $s2)]
org-db.el:   ;; (emacsql-close org-db)
org-db.el:   ;; (emacsql-close org-db)
org-db.el:     ;; (setq files (emacsql org-db [:select [filename] :from files :order-by last-updated :desc])
org-db.el:     (setq files (emacsql org-db [:select [filename] :from files])
org-db.el:            (caar (with-org-db (emacsql org-db [:select [md5] :from files
org-db.el:        (emacsql org-db [:delete :from files :where (= filename $s1)] fname)))))
org-db.el:   (cl-loop for (fname) in (emacsql org-db [:select :distinct [filename] :from files])
org-db.el:      (emacsql org-db [:delete :from files :where (= filename $s1)] fname))))
org-db.el:   (emacsql org-db [:delete :from files])
org-db.el:   (emacsql org-db [:delete :from tags])
org-db.el:   (emacsql org-db [:delete :from properties])
org-db.el:   (emacsql org-db [:delete :from keywords])
org-db.el:   (emacsql org-db [:delete :from headlines])
org-db.el:   (emacsql org-db [:delete :from headline-tags])
org-db.el:   (emacsql org-db [:delete :from headline-properties])
org-db.el:   (emacsql org-db [:delete :from file-keywords])
org-db.el:   (emacsql org-db [:delete :from links])
org-db.el:   (emacsql org-db [:delete :from hashtags])
org-db.el:   (emacsql org-db [:delete :from file-hashtags])
org-db.el:   (emacsql org-db [:delete :from atlabels])
org-db.el:   (emacsql org-db [:delete :from file-atlabels])
org-db.el:   (emacsql org-db [:delete :from email-addresses])
org-db.el:   (emacsql org-db [:delete :from file-email-addresses])
org-db.el:   (emacsql org-db [:delete :from src-blocks])
org-db.el:   (emacsql org-db [:delete :from file-editmarks])
org-db.el:   (emacsql org-db [:delete :from file-targets])
org-db.el:   (emacsql org-db [:delete :from targets]))
org-db.el:   (let ((contacts (with-org-db (emacsql org-db
org-db.el:   (let ((locations (emacsql org-db [:select [headlines:title headline-properties:value headlines:tags files:filename headlines:begin]
org-db.el:  (let* ((src-blocks (with-org-db (emacsql org-db [:select [src-blocks:language
org-db.el:  (let* ((headings (with-org-db (emacsql org-db [:select [headlines:level headlines:todo-keyword headlines:title headlines:tags
org-db.el:  (let ((candidates (mapcar 'car (with-org-db (emacsql org-db [:select [filename]
org-db.el:          (emacsql org-db [:delete :from files :where (= filename $s1)]
org-db.el:              (with-org-db (emacsql org-db [:select [filename last-updated]
org-db.el:            (emacsql org-db [:select [raw-link filename begin]
org-db.el:         (emacsql org-db [:select [target file-targets:begin files:filename]
org-db.el:  (let* ((hashtag-id (caar (with-org-db (emacsql org-db [:select rowid :from hashtags
org-db.el:       (emacsql org-db [:delete :from file-hashtags
org-db.el:       (emacsql org-db [:delete :from hashtags
org-db.el:   (emacsql org-db [:delete :from hashtags])
org-db.el:   (emacsql org-db [:delete :from file-hashtags])))
org-db.el:         (emacsql org-db [:select [hashtag file-hashtags:begin files:filename]
org-db.el:          (emacsql org-db [:select [hashtag file-hashtags:begin files:filename]
org-db.el:        (emacsql org-db [:select [atlabel file-atlabels:begin files:filename]
org-db.el:        (emacsql org-db
org-db.el:                    (-flatten (with-org-db (emacsql org-db
org-db.el:         (emacsql org-db
org-db.el:         (emacsql org-db
org-db.el:         (emacsql org-db
org-db.el:               (emacsql org-db [:select [filename path begin]
org-db.el:;; (emacsql org-db (org-db-table [headlines:title
org-db.el:             (caar (emacsql org-db [:select (funcall count) :from files])))))
org-db.el:             (caar (emacsql org-db [:select (funcall count) :from headlines])))))
org-db.el:              (caar (eval `(emacsql org-db [:select (funcall count) :from $s1]
scimax-@-links.el:   (hashtag-data (emacsql org-db [:select [hashtag file-hashtags:begin files:filename]
scimax-contacts.el:               (with-org-db (emacsql org-db
scimax-contacts.el:       (emacsql org-db
scimax-contacts.el:            (-flatten (with-org-db (emacsql org-db [:select [tags:tag]
scimax-contacts.el:             (emacsql org-db [:select [raw-link filename begin ]
scimax-contacts.el:  (results (with-org-db (emacsql org-db
scimax-contacts.el:  (results (with-org-db (emacsql org-db
scimax-contacts.el:  (not (null (with-org-db (emacsql org-db
scimax-editmarks.el:               (emacsql org-db [:select [raw-link filename begin ]
scimax-editmarks.el:     (results (emacsql org-db
scimax-editmarks.el:     (results (emacsql org-db

[jkitchin]

Have you installed scimax from homebrew? If so, you probably have to uninstall and reinstall it update it. This is definitely old code that is not current with this repo. This might also be related to issue #503, maybe there is an elpa in there that is getting loaded.

How do you start your emacs?

[peteWT]

i install via homebrew and start with:

~/src ❯ scimax

[jkitchin]

I think if you run brew uninstall scimax, brew update, brew install --head scimaxit will be fixed.

[peteWT]

That did it. not sure why the upgrade originally did not work. I've done brew upgrade on scimax homebrew several times. Thanks for the help!