search

tactlabs / error-archive

All issues related to tact and tact labs work
0 stars 0 forks source link

2 #267

Open rajacsp opened 4 years ago

rajacsp commented 4 years ago 
The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/apscheduler/scheduler.py", line 512, in _run_job
    retval = job.func(*job.args, **job.kwargs)
  File "app.py", line 144, in job_function
    c_sched.run_site_collector_scheduler()
  File "/home/ubuntu/kwikee/projects/category_search/scheduler/collector_scheduler.py", line 60, in run_site_collector_scheduler
    exec_time_seconds, exec_time_minutes = bs.add_brands_from_search_links(category_id, limit, offset)
  File "/home/ubuntu/kwikee/projects/category_search/services/brand_service.py", line 49, in add_brands_from_search_links
    brand_links = k_util.get_brand_details_with_links(c_cagtegory_id, category_type_plain, brand_type, search_links)
  File "/home/ubuntu/kwikee/projects/category_search/utils/kwikee_util.py", line 128, in get_brand_details_with_links
    current_brand_links = nlu.get_category_websites(c_cagtegory_id, content, category_plain)
  File "/home/ubuntu/kwikee/projects/category_search/nltk_util.py", line 153, in get_category_websites
    word_count = dbs.get_word_on_websites_count(brand_name_part, c_cagtegory_id)
  File "/home/ubuntu/kwikee/projects/category_search/services/db_service.py", line 963, in get_word_on_websites_count
    brandword_obj = session.query(BrandWord).filter_by(word = c_word).filter_by(category_id = c_category_id).first()
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3228, in first
    ret = list(self[0:1])
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3018, in __getitem__
    return list(res)
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3330, in __iter__
    return self._execute_and_instances(context)
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3355, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 988, in execute
    return meth(self, multiparams, params)
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
    distilled_params,
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
    e, statement, parameters, cursor, context
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
    cursor, statement, parameters, context
  File "/home/ubuntu/kwikee/projects/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column brand_word.foud_on_websites_count does not exist
LINE 1: ...d_word_rowid, brand_word.word AS brand_word_word, brand_word...
                                                             ^
HINT:  Perhaps you meant to reference the column "brand_word.found_on_websites_count".

[SQL: SELECT brand_word.rowid AS brand_word_rowid, brand_word.word AS brand_word_word, brand_word.foud_on_websites_count AS brand_word_foud_on_websites_count, brand_word.category_id AS brand_word_category_id 
FROM brand_word 
WHERE brand_word.word = %(word_1)s AND brand_word.category_id = %(category_id_1)s 
 LIMIT %(param_1)s]
[parameters: {'word_1': 'ebay', 'category_id_1': 27, 'param_1': 1}]
(Background on this error at: http://sqlalche.me/e/f405)