{"action":"created","issue":{"url":"https://api.github.com/repos/gunthercox/ChatterBot/issues/1578","repository_url":"https://api.github.com/repos/gunthercox/ChatterBot","labels_url":"https://api.github.com/repos/gunthercox/ChatterBot/issues/1578/labels{/name}","comments_url":"https://api.github.com/repos/gunthercox/ChatterBot/issues/1578/comments","events_url":"https://api.github.com/repos/gunthercox/ChatterBot/issues/1578/events","html_url":"https://github.com/gunthercox/ChatterBot/issues/1578","id":401297674,"node_id":"MDU6SXNzdWU0MDEyOTc2NzQ=","number":1578,"title":"sqlite3.OperationalError: table statement has no column named search_text","user":{"login":"po95","id":23643269,"node_id":"MDQ6VXNlcjIzNjQzMjY5","avatar_url":"https://avatars3.githubusercontent.com/u/23643269?v=4","gravatar_id":"","url":"https://api.github.com/users/po95","html_url":"https://github.com/po95","followers_url":"https://api.github.com/users/po95/followers","following_url":"https://api.github.com/users/po95/following{/other_user}","gists_url":"https://api.github.com/users/po95/gists{/gist_id}","starred_url":"https://api.github.com/users/po95/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/po95/subscriptions","organizations_url":"https://api.github.com/users/po95/orgs","repos_url":"https://api.github.com/users/po95/repos","events_url":"https://api.github.com/users/po95/events{/privacy}","received_events_url":"https://api.github.com/users/po95/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2019-01-21T10:55:26Z","updated_at":"2019-02-01T09:14:13Z","closed_at":"2019-01-25T14:19:28Z","author_association":"NONE","body":"I have already the  gone through the issue stated here ( `https://github.com/gunthercox/ChatterBot/issues/1493` ), but it didn't work for me. I am using chatterbot of version = 1.0.0.a2\r\n\r\nCan anyone provide any help to fix this issue. Sorry, for stating the whole error list.\r\n\r\n```\r\n`List Trainer: [##                  ] 10%Unhandled exception in thread started by <function check_errors.<locals>.wrapper at 0x037F5B28>\r\nTraceback (most recent call last):\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 1230, in _execute_context\r\n    cursor, statement, parameters, context\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\engine\\default.py\", line 536, in do_execute\r\n    cursor.execute(statement, parameters)\r\nsqlite3.OperationalError: table statement has no column named conversation\r\n\r\nThe above exception was the direct cause of the following exception:\r\n\r\nTraceback (most recent call last):\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\utils\\autoreload.py\", line 225, in wrapper\r\n    fn(*args, **kwargs)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\core\\management\\commands\\runserver.py\", line 117, in inner_run\r\n    self.check(display_num_errors=True)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\core\\management\\base.py\", line 379, in check\r\n    include_deployment_checks=include_deployment_checks,\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\core\\management\\base.py\", line 366, in _run_checks\r\n    return checks.run_checks(**kwargs)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\core\\checks\\registry.py\", line 71, in run_checks\r\n    new_errors = check(app_configs=app_configs)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\core\\checks\\urls.py\", line 13, in check_url_config\r\n    return check_resolver(resolver)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\core\\checks\\urls.py\", line 23, in check_resolver\r\n    return check_method()\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\urls\\resolvers.py\", line 396, in check\r\n    for pattern in self.url_patterns:\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\utils\\functional.py\", line 37, in __get__\r\n    res = instance.__dict__[self.name] = self.func(instance)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\urls\\resolvers.py\", line 533, in url_patterns\r\n    patterns = getattr(self.urlconf_module, \"urlpatterns\", self.urlconf_module)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\utils\\functional.py\", line 37, in __get__\r\n    res = instance.__dict__[self.name] = self.func(instance)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\urls\\resolvers.py\", line 526, in urlconf_module\r\n    return import_module(self.urlconf_name)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\importlib\\__init__.py\", line 127, in import_module\r\n    return _bootstrap._gcd_import(name[level:], package, level)\r\n  File \"<frozen importlib._bootstrap>\", line 1006, in _gcd_import\r\n  File \"<frozen importlib._bootstrap>\", line 983, in _find_and_load\r\n  File \"<frozen importlib._bootstrap>\", line 967, in _find_and_load_unlocked\r\n  File \"<frozen importlib._bootstrap>\", line 677, in _load_unlocked\r\n  File \"<frozen importlib._bootstrap_external>\", line 728, in exec_module\r\n  File \"<frozen importlib._bootstrap>\", line 219, in _call_with_frames_removed\r\n  File \"E:\\Final Thesis work\\targeted\\chat_app\\chat_app\\urls.py\", line 21, in <module>\r\n    url(r'^', include('alpha.urls')),\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\django\\urls\\conf.py\", line 34, in include\r\n    urlconf_module = import_module(urlconf_module)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\importlib\\__init__.py\", line 127, in import_module\r\n    return _bootstrap._gcd_import(name[level:], package, level)\r\n  File \"<frozen importlib._bootstrap>\", line 1006, in _gcd_import\r\n  File \"<frozen importlib._bootstrap>\", line 983, in _find_and_load\r\n  File \"<frozen importlib._bootstrap>\", line 967, in _find_and_load_unlocked\r\n  File \"<frozen importlib._bootstrap>\", line 677, in _load_unlocked\r\n  File \"<frozen importlib._bootstrap_external>\", line 728, in exec_module\r\n  File \"<frozen importlib._bootstrap>\", line 219, in _call_with_frames_removed\r\n  File \"E:\\Final Thesis work\\targeted\\chat_app\\alpha\\urls.py\", line 3, in <module>\r\n    from . import views\r\n  File \"E:\\Final Thesis work\\targeted\\chat_app\\alpha\\views.py\", line 17, in <module>\r\n    trainer.train(conv)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\chatterbot\\trainers.py\", line 97, in train\r\n    tags=statement.tags\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\chatterbot\\storage\\sql_storage.py\", line 189, in create\r\n    session.flush()\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\orm\\session.py\", line 2424, in flush\r\n    self._flush(objects)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\orm\\session.py\", line 2562, in _flush\r\n    transaction.rollback(_capture_exception=True)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\util\\langhelpers.py\", line 67, in __exit__\r\n    compat.reraise(exc_type, exc_value, exc_tb)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\util\\compat.py\", line 277, in reraise\r\n    raise value\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\orm\\session.py\", line 2522, in _flush\r\n    flush_context.execute()\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\orm\\unitofwork.py\", line 416, in execute\r\n    rec.execute(self)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\orm\\unitofwork.py\", line 583, in execute\r\n    uow,\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\orm\\persistence.py\", line 245, in save_obj\r\n    insert,\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\orm\\persistence.py\", line 1116, in _emit_insert_statements\r\n    statement, params\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 974, in execute\r\n    return meth(self, multiparams, params)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\sql\\elements.py\", line 273, in _execute_on_connection\r\n    return connection._execute_clauseelement(self, multiparams, params)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 1093, in _execute_clauseelement\r\n    distilled_params,\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 1234, in _execute_context\r\n    e, statement, parameters, cursor, context\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 1452, in _handle_dbapi_exception\r\n    util.raise_from_cause(sqlalchemy_exception, exc_info)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\util\\compat.py\", line 296, in raise_from_cause\r\n    reraise(type(exception), exception, tb=exc_tb, cause=cause)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\util\\compat.py\", line 276, in reraise\r\n    raise value.with_traceback(tb)\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 1230, in _execute_context\r\n    cursor, statement, parameters, context\r\n  File \"C:\\Users\\QA System\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages\\sqlalchemy\\engine\\default.py\", line 536, in do_execute\r\n    cursor.execute(statement, parameters)\r\nsqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table statement has no column named conversation [SQL: 'INSERT INTO statement (text, conversation, in_response_to, persona) VALUES (?, ?, ?, ?)'] [parameters: ('\\ufeffকেউ কি কখনো চাঁদের মালিক হতে পারবে?', 'training', None, None)] (Background on this error at: http://sqlalche.me/e/e3q8)`\r\n```"},"comment":{"url":"https://api.github.com/repos/gunthercox/ChatterBot/issues/comments/459656555","html_url":"https://github.com/gunthercox/ChatterBot/issues/1578#issuecomment-459656555","issue_url":"https://api.github.com/repos/gunthercox/ChatterBot/issues/1578","id":459656555,"node_id":"MDEyOklzc3VlQ29tbWVudDQ1OTY1NjU1NQ==","user":{"login":"po95","id":23643269,"node_id":"MDQ6VXNlcjIzNjQzMjY5","avatar_url":"https://avatars3.githubusercontent.com/u/23643269?v=4","gravatar_id":"","url":"https://api.github.com/users/po95","html_url":"https://github.com/po95","followers_url":"https://api.github.com/users/po95/followers","following_url":"https://api.github.com/users/po95/following{/other_user}","gists_url":"https://api.github.com/users/po95/gists{/gist_id}","starred_url":"https://api.github.com/users/po95/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/po95/subscriptions","organizations_url":"https://api.github.com/users/po95/orgs","repos_url":"https://api.github.com/users/po95/repos","events_url":"https://api.github.com/users/po95/events{/privacy}","received_events_url":"https://api.github.com/users/po95/received_events","type":"User","site_admin":false},"created_at":"2019-02-01T09:14:13Z","updated_at":"2019-02-01T09:14:13Z","author_association":"NONE","body":"You will face problem for the old versions of chatterbot for a large dataset. For large dataset and immediate response, use 1.0.0 version or later. Thanks"}}
{"actor":{"display_login":"po95"}}