no such table: knowledge_base？ 哪个配置错误导致的呢？

[BigGeneral666]

from langchain_community.output_parsers.rail_parser import GuardrailsOutputParser warnings.warn( Traceback (most recent call last): File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\engine\base.py", line 1964, in _exec_single_context self.dialect.do_execute( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\engine\default.py", line 942, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such table: knowledge_base

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "", line 1, in File "C:\Users\liuzj.conda\envs\chatchat\lib\multiprocessing\spawn.py", line 116, in spawn_main exitcode = _main(fd, parent_sentinel) File "C:\Users\liuzj.conda\envs\chatchat\lib\multiprocessing\spawn.py", line 125, in _main prepare(preparation_data) File "C:\Users\liuzj.conda\envs\chatchat\lib\multiprocessing\spawn.py", line 236, in prepare _fixup_main_from_path(data['init_main_from_path']) File "C:\Users\liuzj.conda\envs\chatchat\lib\multiprocessing\spawn.py", line 287, in _fixup_main_from_path main_content = runpy.run_path(main_path, File "C:\Users\liuzj.conda\envs\chatchat\lib\runpy.py", line 289, in run_path return _run_module_code(code, init_globals, run_name, File "C:\Users\liuzj.conda\envs\chatchat\lib\runpy.py", line 96, in _run_module_code _run_code(code, mod_globals, init_globals, File "C:\Users\liuzj.conda\envs\chatchat\lib\runpy.py", line 86, in run_code exec(code, run_globals) File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\cli.py", line 6, in from chatchat.startup import main as startup_main File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\startup.py", line 18, in from server.script.video import main1 File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\server\script\video.py", line 17, in from chatchat.server.api_new.api_other import create_openai_chat_input File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\server\api_new\api_other.py", line 14, in from chatchat.server.api_server.kb_routes import kb_chat_endpoint File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\server\api_server\kb_routes.py", line 10, in from chatchat.server.chat.kb_chat import kb_chat File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\server\chat\kb_chat.py", line 15, in from chatchat.server.agent.tools_factory.search_internet import search_engine File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\server\agent\tools_factory_init.py", line 4, in from .search_local_knowledgebase import search_local_knowledgebase File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\server\agent\tools_factory\search_local_knowledgebase.py", line 38, in choices=[kb.kb_name for kb in list_kbs().data], File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\server\knowledge_base\kb_api.py", line 18, in list_kbs return ListResponse(data=list_kbs_from_db()) File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\server\db\session.py", line 28, in wrapper result = f(session, *args, **kwargs) File "C:\AI\code\chatchat\libs\chatchat-server\chatchat\server\db\repository\knowledge_base_repository.py", line 33, in list_kbs_from_db .all() File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\orm\query.py", line 2699, in all return self._iter().all() # type: ignore File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\orm\query.py", line 2853, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\orm\session.py", line 2365, in execute return self._execute_internal( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\orm\session.py", line 2251, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\orm\context.py", line 305, in orm_execute_statement result = conn.execute( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\engine\base.py", line 1416, in execute return meth( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\sql\elements.py", line 515, in _execute_on_connection return connection._execute_clauseelement( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\engine\base.py", line 1638, in _execute_clauseelement ret = self._execute_context( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\engine\base.py", line 1843, in _execute_context return self._exec_single_context( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\engine\base.py", line 1983, in _exec_single_context self._handle_dbapi_exception( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\engine\base.py", line 2352, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\engine\base.py", line 1964, in _exec_single_context self.dialect.do_execute( File "C:\Users\liuzj.conda\envs\chatchat\lib\site-packages\sqlalchemy\engine\default.py", line 942, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: knowledge_base [SQL: SELECT knowledge_base.id AS knowledge_base_id, knowledge_base.kb_name AS knowledge_base_kb_name, knowledge_base.kb_info AS knowledge_base_kb_info, knowledge_base.vs_type AS knowledge_base_vs_type, knowledge_base.embed_model AS knowledge_base_embed_model, knowledge_base.file_count AS knowledge_base_file_count, knowledge_base.create_time AS knowledge_base_create_time FROM knowledge_base WHERE knowledge_base.file_count > ?] [parameters: (-1,)] (Background on this error at: https://sqlalche.me/e/20/e3q8)

[dosubot[bot]]

The error "no such table: knowledge_base" indicates that the database schema has not been initialized correctly, and the knowledge_base table is missing. To resolve this issue, you need to initialize the database schema for Langchain-Chatchat.

Here are the steps to initialize the database:

1. Initialize the Knowledge Base: Run the following command to initialize the knowledge base, which will create the necessary tables:

   cd libs/chatchat-server
   python chatchat/cli.py kb --recreate-vs
   

2. Set Up Data Directory and Configuration: Ensure that the root path for storing data is set using the CHATCHAT_ROOT environment variable, or it will default to the current directory:

   export CHATCHAT_ROOT=/path/to/chatchat_data
   

3. Initialize Data and Configuration Templates: Execute the following command to initialize data and YAML configuration templates:

   chatchat init
   

These steps should create the knowledge_base table and resolve the error you're encountering ^[1][2].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[github-actions[bot]]

这个问题已经被标记为 stale ，因为它已经超过 30 天没有任何活动。

[github-actions[bot]]

这个问题已经被自动关闭，因为它被标为 stale 后超过 14 天没有任何活动。