NoSuchTableError: nuggets

[ychaouche]

Hello

I am batteling to get freex mode installed, I have resolved 3 issues so far

• pymacs takes more than 30 seconds te respond : freex comes with an unsupported version of pymacs.el, I needed to get it out of the way by renaming it with a suffix (-)

• (error "Pymacs loading freex_sqlalchemy...failed") : pymacs need to be aware that it needs to load python modules from where freex is installed, see https://github.com/gregdetre/emacs-freex/issues/5#issuecomment-283061119

• OperationalError: (pysqlite2.dbapi2.OperationalError) unable to open database file : that's because I've put a "~" in the path to the database file and the database file didn't exist, so I created it with touch.

Now that the empty file is there it seems I can't get freex to intialize it (create the tables).

Any tips ?

EDIT : full backtrace :

Debugger entered--Lisp error: (error "Python: Traceback (most recent call last):
  File \"/usr/lib/python2.7/dist-packages/Pymacs/pymacs.py\", line 146, in loop
    value = eval(text)
  File \"<string>\", line 1, in <module>
  File \"/home/ychaouche/.emacs.d/emacs-freex-master/freex_sqlalchemy.py\", line 598, in create_fsqa
    fsqa = Fsqa(database_file,use_lisp,in_memory,file_ext)
  File \"/home/ychaouche/.emacs.d/emacs-freex-master/freex_sqlalchemy.py\", line 326, in __init__
    self.load_db()
  File \"/home/ychaouche/.emacs.d/emacs-freex-master/freex_sqlalchemy.py\", line 511, in load_db
    autoload=True)
  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 436, in __new__
    metadata._remove_table(name, schema)
  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py\", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 431, in __new__
    table._init(name, metadata, *args, **kw)
  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 511, in _init
    include_columns, _extend_on=_extend_on)
  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 537, in _autoload
    _extend_on=_extend_on
  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 2036, in run_callable
    return conn.run_callable(callable_, *args, **kwargs)
  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 1525, in run_callable
    return callable_(self, *args, **kwargs)
  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py\", line 372, in reflecttable
    table, include_columns, exclude_columns, **opts)
  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py\", line 606, in reflecttable
    raise exc.NoSuchTableError(table.name)
NoSuchTableError: nuggets
")
  signal(error ("Python: Traceback (most recent call last):\n  File \"/usr/lib/python2.7/dist-packages/Pymacs/pymacs.py\", line 146, in loop\n    value = eval(text)\n  File \"<string>\", line 1, in <module>\n  File \"/home/ychaouche/.emacs.d/emacs-freex-master/freex_sqlalchemy.py\", line 598, in create_fsqa\n    fsqa = Fsqa(database_file,use_lisp,in_memory,file_ext)\n  File \"/home/ychaouche/.emacs.d/emacs-freex-master/freex_sqlalchemy.py\", line 326, in __init__\n    self.load_db()\n  File \"/home/ychaouche/.emacs.d/emacs-freex-master/freex_sqlalchemy.py\", line 511, in load_db\n    autoload=True)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 436, in __new__\n    metadata._remove_table(name, schema)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py\", line 60, in __exit__\n    compat.reraise(exc_type, exc_value, exc_tb)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 431, in __new__\n    table._init(name, metadata, *args, **kw)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 511, in _init\n    include_columns, _extend_on=_extend_on)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 537, in _autoload\n    _extend_on=_extend_on\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 2036, in run_callable\n    return conn.run_callable(callable_, *args, **kwargs)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 1525, in run_callable\n    return callable_(self, *args, **kwargs)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py\", line 372, in reflecttable\n    table, include_columns, exclude_columns, **opts)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py\", line 606, in reflecttable\n    raise exc.NoSuchTableError(table.name)\nNoSuchTableError: nuggets\n"))
  pymacs-report-error("Python: %s" "Traceback (most recent call last):\n  File \"/usr/lib/python2.7/dist-packages/Pymacs/pymacs.py\", line 146, in loop\n    value = eval(text)\n  File \"<string>\", line 1, in <module>\n  File \"/home/ychaouche/.emacs.d/emacs-freex-master/freex_sqlalchemy.py\", line 598, in create_fsqa\n    fsqa = Fsqa(database_file,use_lisp,in_memory,file_ext)\n  File \"/home/ychaouche/.emacs.d/emacs-freex-master/freex_sqlalchemy.py\", line 326, in __init__\n    self.load_db()\n  File \"/home/ychaouche/.emacs.d/emacs-freex-master/freex_sqlalchemy.py\", line 511, in load_db\n    autoload=True)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 436, in __new__\n    metadata._remove_table(name, schema)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py\", line 60, in __exit__\n    compat.reraise(exc_type, exc_value, exc_tb)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 431, in __new__\n    table._init(name, metadata, *args, **kw)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 511, in _init\n    include_columns, _extend_on=_extend_on)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py\", line 537, in _autoload\n    _extend_on=_extend_on\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 2036, in run_callable\n    return conn.run_callable(callable_, *args, **kwargs)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 1525, in run_callable\n    return callable_(self, *args, **kwargs)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py\", line 372, in reflecttable\n    table, include_columns, exclude_columns, **opts)\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py\", line 606, in reflecttable\n    raise exc.NoSuchTableError(table.name)\nNoSuchTableError: nuggets\n")
  pymacs-serve-until-reply("eval" (pymacs-print-for-apply (quote (pymacs-python . 1347)) (quote ("/home/ychaouche/.emacs.d/freex/freex.db" 1 0 "freex"))))
  pymacs-apply((pymacs-python . 1347) ("/home/ychaouche/.emacs.d/freex/freex.db" 1 0 "freex"))
  freex-sqlalchemy-create-fsqa("/home/ychaouche/.emacs.d/freex/freex.db" 1 0 "freex")
  freex-meta-connect-init-db()
  (setq fsqa (freex-meta-connect-init-db))
  eval-buffer(#<buffer  *load*-906674> nil "/home/ychaouche/.emacs.d/emacs-freex-master/freex-meta.el" nil t)  ; Reading at buffer position 4039
  load-with-code-conversion("/home/ychaouche/.emacs.d/emacs-freex-master/freex-meta.el" "/home/ychaouche/.emacs.d/emacs-freex-master/freex-meta.el" nil t)
  require(freex-meta)
  eval-buffer(#<buffer  *load*-25925> nil "/home/ychaouche/.emacs.d/emacs-freex-master/freex-mode.el" nil t)  ; Reading at buffer position 1000
  load-with-code-conversion("/home/ychaouche/.emacs.d/emacs-freex-master/freex-mode.el" "/home/ychaouche/.emacs.d/emacs-freex-master/freex-mode.el" nil nil)
  load("~/.emacs.d/emacs-freex-master/freex-mode.el")
  eval-buffer(#<buffer  *load*> nil "/home/ychaouche/.emacs.d/emacs-freex-master/freex-conf.el" nil t)  ; Reading at buffer position 2678
  load-with-code-conversion("/home/ychaouche/.emacs.d/emacs-freex-master/freex-conf.el" "/home/ychaouche/.emacs.d/emacs-freex-master/freex-conf.el" nil nil)
  load("~/.emacs.d/emacs-freex-master/freex-conf.el")
  eval((load "~/.emacs.d/emacs-freex-master/freex-conf.el") nil)
  eval-last-sexp-1(nil)
  eval-last-sexp(nil)
  call-interactively(eval-last-sexp nil nil)

[ychaouche]

Apparently I went too fast : I only needed to put full path and not touch the freex.db file. I removed it and now freex creates it correctly.