After M-x sql-postgres and clicking on the menu item SQL, I get this error: Debugger entered--Lisp error: (error "‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first.") signal(error ("‘'postgres’ is not a known product; use ‘sql-add-p...")) error("`%s' is not a known product; use `sql-add-product' to add it first." 'postgres) sql-get-product-feature('postgres :sqli-login) sql-make-alternate-buffer-name() #f(compiled-function () #<bytecode 0x1e00135e2041>)() funcall(#f(compiled-function () #<bytecode 0x1e00135e2041>)) (let ((sql-database '"my-database") (sql-password '"my-password") (sql-user '"my-username") (sql-product ''postgres)) (funcall '#f(compiled-function () #<bytecode 0x1e00135e2041>))) eval((let ((sql-database '"my-database") (sql-password '"my-password") (sql-user '"my-username") (sql-product ''postgres)) (funcall '#f(compiled-function () #<bytecode 0x1e00135e2041>)))) #f(compiled-function (conn) #<bytecode -0x96a03124cfe7158>)(("local" (sql-product 'postgres) (sql-user "my-username") (sql-password "my-password") (sql-database "my-database"))) mapcar(#f(compiled-function (conn) #<bytecode -0x96a03124cfe7158>) (("local" (sql-product 'postgres) (sql-user "my-username") (sql-password "my-password") (sql-database "my-database")))) sql-connection-menu-filter(("--" ["New SQLi Session" sql-product-interactive (sql-get-product-feature sql-product :sqli-comint-func)])) #f(compiled-function (menu) #<bytecode 0xfdb21298474a028>)(("--" ["New SQLi Session" sql-product-interactive (sql-get-product-feature sql-product :sqli-comint-func)])) The value of variable `sql-product-alist' is: Value: ((ansi :name "ANSI" :font-lock sql-mode-ansi-font-lock-keywords :statement sql-ansi-statement-starters) (db2 :name "DB2" :font-lock sql-mode-db2-font-lock-keywords :sqli-program sql-db2-program :sqli-options sql-db2-options :sqli-login sql-db2-login-params :sqli-comint-func sql-comint-db2 :prompt-regexp "^db2 => " :prompt-length 7 :prompt-cont-regexp "^db2 (cont\\.) => " :input-filter sql-escape-newlines-filter) (informix :name "Informix" :font-lock sql-mode-informix-font-lock-keywords :sqli-program sql-informix-program :sqli-options sql-informix-options :sqli-login sql-informix-login-params :sqli-comint-func sql-comint-informix :prompt-regexp "^> " :prompt-length 2 :syntax-alist ((123 . "<") (125 . ">"))) (ingres :name "Ingres" :font-lock sql-mode-ingres-font-lock-keywords :sqli-program sql-ingres-program :sqli-options sql-ingres-options :sqli-login sql-ingres-login-params :sqli-comint-func sql-comint-ingres :prompt-regexp "^\\* " :prompt-length 2 :prompt-cont-regexp "^\\* ") (interbase :name "Interbase" :font-lock sql-mode-interbase-font-lock-keywords :sqli-program sql-interbase-program :sqli-options sql-interbase-options :sqli-login sql-interbase-login-params :sqli-comint-func sql-comint-interbase :prompt-regexp "^SQL> " :prompt-length 5) (linter :name "Linter" :font-lock sql-mode-linter-font-lock-keywords :sqli-program sql-linter-program :sqli-options sql-linter-options :sqli-login sql-linter-login-params :sqli-comint-func sql-comint-linter :prompt-regexp "^SQL>" :prompt-length 4) (mariadb :name "MariaDB" :free-software t :font-lock sql-mode-mariadb-font-lock-keywords :sqli-program sql-mariadb-program :sqli-options sql-mariadb-options :sqli-login sql-mariadb-login-params :sqli-comint-func sql-comint-mariadb :list-all "SHOW TABLES;" :list-table "DESCRIBE %s;" :prompt-regexp "^MariaDB \\[.*]> " :prompt-cont-regexp "^ [\"'`-]> " :syntax-alist ((35 . "< b")) :input-filter sql-remove-tabs-filter) (ms :name "Microsoft" :font-lock sql-mode-ms-font-lock-keywords :sqli-program sql-ms-program :sqli-options sql-ms-options :sqli-login sql-ms-login-params :sqli-comint-func sql-comint-ms :prompt-regexp "^[0-9]*>" :prompt-cont-regexp "^[0-9]*>" :prompt-length 5 :syntax-alist ((64 . "_")) :terminator ("^go" . "go")) (mysql :name "MySQL" :free-software t :font-lock sql-mode-mysql-font-lock-keywords :sqli-program sql-mysql-program :sqli-options sql-mysql-options :sqli-login sql-mysql-login-params :sqli-comint-func sql-comint-mysql :list-all "SHOW TABLES;" :list-table "DESCRIBE %s;" :prompt-regexp "^mysql> " :prompt-length 6 :prompt-cont-regexp "^ -> " :syntax-alist ((35 . "< b") (92 . "\\")) :input-filter sql-remove-tabs-filter) (oracle :name "Oracle" :font-lock sql-mode-oracle-font-lock-keywords :sqli-program sql-oracle-program :sqli-options sql-oracle-options :sqli-login sql-oracle-login-params :sqli-comint-func sql-comint-oracle :list-all sql-oracle-list-all :list-table sql-oracle-list-table :completion-object sql-oracle-completion-object :prompt-regexp "^SQL> " :prompt-length 5 :prompt-cont-regexp "^\\(?:[ ][ ][1-9]\\|[ ][1-9][0-9]\\|[1-9][0-9]\\{2\\}\\)[ ]\\{2\\}" :statement sql-oracle-statement-starters :syntax-alist ((36 . "_") (35 . "_")) :terminator ("\\(^/\\|;\\)" . "/") :input-filter sql-placeholders-filter) (postgres :name "Postgres" :free-software t :font-lock sql-mode-postgres-font-lock-keywords :sqli-program sql-postgres-program :sqli-options sql-postgres-options :sqli-login sql-postgres-login-params :sqli-comint-func sql-comint-postgres :list-all ("\\d+" . "\\dS+") :list-table ("\\d+ %s" . "\\dS+ %s") :completion-object sql-postgres-completion-object :prompt-regexp "^[[:alnum:]_]*=[#>] " :prompt-length 5 :prompt-cont-regexp "^[[:alnum:]_]*[-(][#>] " :input-filter sql-remove-tabs-filter :terminator ("\\(^\\s-*\\\\g\\|;\\)" . "\\g")) (solid :name "Solid" :font-lock sql-mode-solid-font-lock-keywords :sqli-program sql-solid-program :sqli-options sql-solid-options :sqli-login sql-solid-login-params :sqli-comint-func sql-comint-solid :prompt-regexp "^" :prompt-length 0) (sqlite :name "SQLite" :free-software t :font-lock sql-mode-sqlite-font-lock-keywords :sqli-program sql-sqlite-program :sqli-options sql-sqlite-options :sqli-login sql-sqlite-login-params :sqli-comint-func sql-comint-sqlite :list-all ".tables" :list-table ".schema %s" :completion-object sql-sqlite-completion-object :prompt-regexp "^sqlite> " :prompt-length 8 :prompt-cont-regexp "^ \\.\\.\\.> ") (sybase :name "Sybase" :font-lock sql-mode-sybase-font-lock-keywords :sqli-program sql-sybase-program :sqli-options sql-sybase-options :sqli-login sql-sybase-login-params :sqli-comint-func sql-comint-sybase :prompt-regexp "^SQL> " :prompt-length 5 :syntax-alist ((64 . "_")) :terminator ("^go" . "go")) (vertica :name "Vertica" :sqli-program sql-vertica-program :sqli-options sql-vertica-options :sqli-login sql-vertica-login-params :sqli-comint-func sql-comint-vertica :list-all ("\\d" . "\\dS") :list-table "\\d %s" :prompt-regexp "^[[:alnum:]_]*=[#>] " :prompt-length 5 :prompt-cont-regexp "^[[:alnum:]_]*[-(][#>] ")) In GNU Emacs 28.0.50 (build 4, x86_64-pc-linux-gnu, X toolkit, cairo version 1.14.8, Xaw3d scroll bars) of 2021-01-01 built on protected.rcdrun.com Repository revision: 30a1d5da7a43d51a97cbe8d91add9a26dd99df90 Repository branch: master Windowing system distributor 'The X.Org Foundation', version 11.0.11907000 System Description: Hyperbola GNU/Linux-libre Configured using: 'configure --prefix=/package/text/emacs --with-modules --with-x-toolkit=lucid PKG_CONFIG_PATH=/home/data1/protected/GNUstep/Library/Libraries/pkgconfig:/usr/lib/pkgconfig' Configured features: XAW3D XPM JPEG TIFF GIF PNG RSVG CAIRO SOUND GPM DBUS GSETTINGS GLIB NOTIFY INOTIFY ACL GNUTLS LIBXML2 FREETYPE HARFBUZZ M17N_FLT LIBOTF ZLIB TOOLKIT_SCROLL_BARS LUCID X11 XDBE XIM MODULES THREADS JSON PDUMPER LCMS2 Important settings: value of $LC_ALL: en_US.UTF-8 value of $LANG: de_DE.UTF-8 value of $XMODIFIERS: @im=exwm-xim locale-coding-system: utf-8-unix Major mode: Lisp Interaction Minor modes in effect: tooltip-mode: t global-eldoc-mode: t eldoc-mode: t electric-indent-mode: t mouse-wheel-mode: t tool-bar-mode: t menu-bar-mode: t file-name-shadow-mode: t global-font-lock-mode: t font-lock-mode: t blink-cursor-mode: t auto-composition-mode: t auto-encryption-mode: t auto-compression-mode: t line-number-mode: t transient-mark-mode: t Load-path shadows: None found. Features: (shadow sort hashcash mail-extr emacsbug message rmc puny dired dired-loaddefs rfc822 mml easymenu mml-sec epa derived epg epg-config gnus-util rmail rmail-loaddefs auth-source cl-seq eieio eieio-core cl-macs eieio-loaddefs password-cache json map text-property-search time-date subr-x seq byte-opt gv bytecomp byte-compile cconv mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader cl-loaddefs cl-lib sendmail rfc2047 rfc2045 ietf-drums mm-util mail-prsvr mail-utils iso-transl tooltip eldoc electric uniquify ediff-hook vc-hooks lisp-float-type mwheel term/x-win x-win term/common-win x-dnd tool-bar dnd fontset image regexp-opt fringe tabulated-list replace newcomment text-mode elisp-mode lisp-mode prog-mode register page tab-bar menu-bar rfn-eshadow isearch timer select scroll-bar mouse jit-lock font-lock syntax facemenu font-core term/tty-colors frame minibuffer cl-generic cham georgian utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean japanese eucjp-ms cp51932 hebrew greek romanian slovak czech european ethiopic indian cyrillic chinese composite charscript charprop case-table epa-hook jka-cmpr-hook help simple abbrev obarray cl-preloaded nadvice button loaddefs faces cus-face macroexp files window text-properties overlay sha1 md5 base64 format env code-pages mule custom widget hashtable-print-readable backquote threads dbusbind inotify lcms2 dynamic-setting system-font-setting font-render-setting cairo x-toolkit x multi-tty make-network-process emacs) Memory information: ((conses 16 55368 5781) (symbols 48 7329 0) (strings 32 20348 2406) (string-bytes 1 649572) (vectors 16 13014) (vector-slots 8 226056 20087) (floats 8 26 39) (intervals 56 256 0) (buffers 984 12)) -- Thanks, Jean Louis ⎔ λ 🄯 𝍄 𝌡 𝌚
Jean Louis <bugs@gnu.support> writes: > After M-x sql-postgres and clicking on the menu item SQL, I get this > error: > > Debugger entered--Lisp error: (error "‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first.") What's the value of the `sql-connection-alist' variable in the SQL buffer? -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no
Hi jean, Jean Louis writes: > After M-x sql-postgres and clicking on the menu item SQL, I get this > error: I can not reproduce this with Emacs compiled from master and executed as "src/emacs -q". What else does this need? > Debugger entered--Lisp error: (error "‘'postgres’ is not a known > product; use ‘sql-add-product’ to add it first.") > signal(error ("‘'postgres’ is not a known product; use ‘sql-add-p...")) It looks like there is one ' too much in there? As in (quote 'postgres) instead of plain 'postgres. > #f(compiled-function (menu) #<bytecode 0xfdb21298474a028>)(("--" > ["New SQLi Session" sql-product-interactive (sql-get-product-feature > sql-product :sqli-comint-func)])) I do not have this menu item. When I execute M-: (sql-product-interactive (sql-get-product-feature sql-product :sqli-comint-func)) that returns fine, result is #<window 7 on *SQL: Postgres*> which is the window object I guess. benny
Lars Ingebrigtsen <larsi@gnus.org> writes: > Jean Louis <bugs@gnu.support> writes: > >> After M-x sql-postgres and clicking on the menu item SQL, I get this >> error: >> >> Debugger entered--Lisp error: (error "‘'postgres’ is not a known >> product; use ‘sql-add-product’ to add it first.") > > What's the value of the `sql-connection-alist' variable in the SQL buffer? More information was requested, but no response was given within a month, so I'm closing this bug report. If the problem still exists, please respond to this email and we'll reopen the bug report. (Benjamin Riefenstahl also reported that he couldn't reproduce the problem.) -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no
* Lars Ingebrigtsen <larsi@gnus.org> [2021-01-25 00:31]:
> Jean Louis <bugs@gnu.support> writes:
>
> > After M-x sql-postgres and clicking on the menu item SQL, I get this
> > error:
> >
> > Debugger entered--Lisp error: (error "‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first.")
>
> What's the value of the `sql-connection-alist' variable in the SQL buffer?
(("local" (sql-product 'postgres) (sql-user "username") (sql-password "password") (sql-database "mydatabase")))
This problem does not appear always and I cannot reproduce it.
Jean Louis <bugs@gnu.support> writes: >> What's the value of the `sql-connection-alist' variable in the SQL buffer? > > (("local" (sql-product 'postgres) (sql-user "username") (sql-password > "password") (sql-database "mydatabase"))) > > This problem does not appear always and I cannot reproduce it. OK; reopening. -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no
Lars Ingebrigtsen <larsi@gnus.org> writes:
> Jean Louis <bugs@gnu.support> writes:
>
>>> What's the value of the `sql-connection-alist' variable in the SQL buffer?
>>
>> (("local" (sql-product 'postgres) (sql-user "username") (sql-password
>> "password") (sql-database "mydatabase")))
>>
>> This problem does not appear always and I cannot reproduce it.
Just a wild guess, but is there a misplaced quote in `(sql-product
'postgres)', i.e., should it be `(sql-product postgres)' instead?
(Please feel free to ignore this mail if that's not the case.)
* Rudolf Schlatte <rudi@constantly.at> [2021-03-16 11:54]:
> Lars Ingebrigtsen <larsi@gnus.org> writes:
>
> > Jean Louis <bugs@gnu.support> writes:
> >
> >>> What's the value of the `sql-connection-alist' variable in the SQL buffer?
> >>
> >> (("local" (sql-product 'postgres) (sql-user "username") (sql-password
> >> "password") (sql-database "mydatabase")))
> >>
> >> This problem does not appear always and I cannot reproduce it.
>
> Just a wild guess, but is there a misplaced quote in `(sql-product
> 'postgres)', i.e., should it be `(sql-product postgres)' instead?
>
> (Please feel free to ignore this mail if that's not the case.)
I am on development version. This does not happen always.
I do:
- M-x sql-postgres and enter
- then at the exact moment when I click SQL menu, I get this error:
Debugger entered--Lisp error: (error "‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first.")
signal(error ("‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first."))
error("`%s' is not a known product; use `sql-add-product' to add it first." 'postgres)
sql-get-product-feature('postgres :sqli-login)
sql-make-alternate-buffer-name()
#f(compiled-function () #<bytecode 0x1e00184608d5>)()
funcall(#f(compiled-function () #<bytecode 0x1e00184608d5>))
(let ((sql-product ''postgres) (sql-user '"username") (sql-password '"password") (sql-database '"rcdbusiness")) (funcall '#f(compiled-function () #<bytecode 0x1e00184608d5>)))
eval((let ((sql-product ''postgres) (sql-user '"username") (sql-password '"password") (sql-database '"rcdbusiness")) (funcall '#f(compiled-function () #<bytecode 0x1e00184608d5>))))
#f(compiled-function (conn) #<bytecode -0x99cf3617ae0f94f>)(("local" (sql-product 'postgres) (sql-user "username") (sql-password "password") (sql-database "rcdbusiness")))
mapcar(#f(compiled-function (conn) #<bytecode -0x99cf3617ae0f94f>) (("local" (sql-product 'postgres) (sql-user "username") (sql-password "password") (sql-database "rcdbusiness"))))
sql-connection-menu-filter(("--" ["New SQLi Session" sql-product-interactive (sql-get-product-feature sql-product :sqli-comint-func)]))
#f(compiled-function (menu) #<bytecode 0x10470486be0d08fa>)(("--" ["New SQLi Session" sql-product-interactive (sql-get-product-feature sql-product :sqli-comint-func)]))
Jean Louis <louis@rcdsociety.com> writes: > - M-x sql-postgres and enter > > - then at the exact moment when I click SQL menu, I get this error: > > Debugger entered--Lisp error: (error "‘'postgres’ is not a known > product; use ‘sql-add-product’ to add it first.") > signal(error ("‘'postgres’ is not a known product; use > ‘sql-add-product’ to add it first.")) > error("`%s' is not a known product; use `sql-add-product' to add it > first." 'postgres) [...] > (("local" (sql-product 'postgres) (sql-user "username") (sql-password > "password") (sql-database "rcdbusiness")))) > sql-connection-menu-filter(("--" ["New SQLi Session" > sql-product-interactive (sql-get-product-feature sql-product > :sqli-comint-func)])) I think this has to mean that your sql-product is set to 'postgres instead of postgres. That is, somewhere you have (setq sql-product ''postgres) with an extra ' character. Or perhaps in a defcustom setting. Is this the case? -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no
* Lars Ingebrigtsen <larsi@gnus.org> [2021-05-13 15:03]: > Jean Louis <louis@rcdsociety.com> writes: > > > - M-x sql-postgres and enter > > > > - then at the exact moment when I click SQL menu, I get this error: > > > > Debugger entered--Lisp error: (error "‘'postgres’ is not a known > > product; use ‘sql-add-product’ to add it first.") > > signal(error ("‘'postgres’ is not a known product; use > > ‘sql-add-product’ to add it first.")) > > error("`%s' is not a known product; use `sql-add-product' to add it > > first." 'postgres) > > [...] > > > (("local" (sql-product 'postgres) (sql-user "username") (sql-password > > "password") (sql-database "rcdbusiness")))) > > sql-connection-menu-filter(("--" ["New SQLi Session" > > sql-product-interactive (sql-get-product-feature sql-product > > :sqli-comint-func)])) > > I think this has to mean that your sql-product is set to 'postgres > instead of postgres. > > That is, somewhere you have > > (setq sql-product ''postgres) > > with an extra ' character. Or perhaps in a defcustom setting. Is this > the case? I am choosing the product by using customize-variable, so the value is 'postgres as symbol. The same problem I have observed before 4 weeks, but I do not observe it now. The problem was there when I click with the mouse on SQL menu item, before the menu item even opens. I can see that I re-factored the settings and hard-coded it to: (setq sql-product (quote postgres)) I cannot reproduce it. I don't know why, and I don't see any log of changes in the git repository. It happened by rule when I clicked on the "SQL"menu. Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns Sign an open letter in support of Richard M. Stallman https://stallmansupport.org/ https://rms-support-letter.github.io/
Jean Louis <bugs@gnu.support> writes: > I can see that I re-factored the settings and hard-coded it to: > > (setq sql-product (quote postgres)) That should be correct; yes. I'm wondering if you'd earlier had a (custom-set-variables '(sql-product (quote postgres)) ...) or similar, which would result in the error you were seeing: > I cannot reproduce it. I don't know why, and I don't see any log of > changes in the git repository. It happened by rule when I clicked on > the "SQL"menu. But as you can no longer reproduce this bug, I'm closing it. If it turns up again later, please respond to the debbugs address and we'll reopen. -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no
* Lars Ingebrigtsen <larsi@gnus.org> [2021-05-16 16:57]: > > I cannot reproduce it. I don't know why, and I don't see any log of > > changes in the git repository. It happened by rule when I clicked on > > the "SQL"menu. > > But as you can no longer reproduce this bug, I'm closing it. If it > turns up again later, please respond to the debbugs address and we'll > reopen. Just to report that this bug is appearing sometimes, but I cannot reproduce it. It appears when I open a new SQL buffer and start doing some scratch. Problem is that I did not capture or notice what I do that it appears. No need to re-open the bug, I will report when I find the cause. -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns Sign an open letter in support of Richard M. Stallman https://stallmansupport.org/