armoner24 / chat-bot-with-sentiment-analysis Goto Github PK

[nltk_data] Downloading package stopwords to
[nltk_data] C:\Users\TMRND\AppData\Roaming\nltk_data...
[nltk_data] Package stopwords is already up-to-date!
[nltk_data] Downloading package averaged_perceptron_tagger to
[nltk_data] C:\Users\TMRND\AppData\Roaming\nltk_data...
[nltk_data] Package averaged_perceptron_tagger is already up-to-
[nltk_data] date!
You: I hate you
Sentiment Analysis=>
neg: 0.787,
neu: 0.213,
pos: 0.0,
compound: -0.5719,

Traceback (most recent call last):
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\engine\base.py", line 1236, in _execute_context
cursor, statement, parameters, context
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\engine\default.py", line 536, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such column: statement.search_text

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

Traceback (most recent call last):
File "chatbot_with_sa.py", line 148, in
response=bot.get_response(request)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\chatterbot\chatterbot.py", line 139, in get_response
response = self.generate_response(input_statement, additional_response_selection_parameters)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\chatterbot\chatterbot.py", line 175, in generate_response
output = adapter.process(input_statement, additional_response_selection_parameters)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\chatterbot\logic\best_match.py", line 29, in process
closest_match = next(search_results, input_statement)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\chatterbot\search.py", line 74, in search
for statement in statement_list:
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\chatterbot\storage\sql_storage.py", line 168, in filter
total_statements = statements.count()
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\orm\query.py", line 3318, in count
return self.from_self(col).scalar()
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\orm\query.py", line 3069, in scalar
ret = self.one()
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\orm\query.py", line 3039, in one
ret = self.one_or_none()
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\orm\query.py", line 3008, in one_or_none
ret = list(self)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\orm\query.py", line 3081, in iter
return self._execute_and_instances(context)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\orm\query.py", line 3106, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\engine\base.py", line 980, in execute
return meth(self, multiparams, params)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\sql\elements.py", line 273, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\engine\base.py", line 1099, in _execute_clauseelement
distilled_params,
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\engine\base.py", line 1240, in _execute_context
e, statement, parameters, cursor, context
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\engine\base.py", line 1458, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\util\compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\util\compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\engine\base.py", line 1236, in _execute_context
cursor, statement, parameters, context
File "C:\Users\TMRND\Anaconda3\envs\textcategorize\lib\site-packages\sqlalchemy\engine\default.py", line 536, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: statement.search_text [SQL: "SELECT count(*) AS count_1 \nFROM (SELECT statement.id AS statement_id, statement.text AS statement_text, statement.search_text AS statement_search_text, statement.conversation AS statement_conversation, statement.created_at AS statement_created_at, statement.in_response_to AS statement_in_response_to, statement.search_in_response_to AS statement_search_in_response_to, statement.persona AS statement_persona \nFROM statement \nWHERE (statement.persona NOT LIKE ? || '%') AND (statement.search_text LIKE '%' || ? || '%')) AS anon_1"] [parameters: ('bot:', 'PRP:dislike')] (Background on this error at: http://sqlalche.me/e/e3q8)