onaio/onadata

ProgrammingError: trailing junk after numeric literal at or near "39484A"

KipSigei opened this issue · 0 comments

SyntaxError: trailing junk after numeric literal at or near "39484A"
LINE 1: ...t(*) as count FROM logger_instance WHERE xform_id=39484AND d...
                                                             ^

  File "django/db/backends/utils.py", line 82, in _execute
    return self.cursor.execute(sql)

ProgrammingError: trailing junk after numeric literal at or near "39484A"
LINE 1: ...t(*) as count FROM logger_instance WHERE xform_id=39484AND d...
                                                             ^

(13 additional frame(s) were not displayed)
...
  File "onadata/apps/api/viewsets/charts_viewset.py", line 135, in retrieve
    data = get_chart_data_for_field(
  File "onadata/libs/utils/chart_tools.py", line 477, in get_chart_data_for_field
    data = build_chart_data_for_field(
  File "onadata/libs/utils/chart_tools.py", line 277, in build_chart_data_for_field
    result = get_form_submissions_grouped_by_select_one(
  File "onadata/libs/data/query.py", line 278, in get_form_submissions_grouped_by_select_one
    return _execute_query(
  File "onadata/libs/data/query.py", line 25, in _execute_query
    cursor.execute(query)