Type mismatch in Harvest's updateopportunities

Bug #918172 reported by Daniel Holbach
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
harvest
Fix Released
Critical
Daniel Holbach

Bug Description

STDOUT + STDERR Output
Traceback (most recent call last):
  File "./manage.py", line 13, in <module>
    execute_manager(settings)
  File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py", line 362, in execute_manager
    utility.execute()
  File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py", line 303, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line 195, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line 222, in execute
    output = self.handle(*args, **options)
  File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line 351, in handle
    return self.handle_noargs(**options)
  File "/srv/harvest.ubuntu.com/harvest/opportunities/management/commands/updateopportunities.py", line 66, in handle_noargs
    self.update_lists()
  File "/srv/harvest.ubuntu.com/harvest/opportunities/management/commands/updateopportunities.py", line 30, in update_lists
    opportunitylist=op_list)
  File "/usr/lib/pymodules/python2.6/django/db/models/manager.py", line 120, in get
    return self.get_query_set().get(*args, **kwargs)
  File "/usr/lib/pymodules/python2.6/django/db/models/query.py", line 300, in get
    num = len(clone)
  File "/usr/lib/pymodules/python2.6/django/db/models/query.py", line 81, in __len__
    self._result_cache = list(self.iterator())
  File "/usr/lib/pymodules/python2.6/django/db/models/query.py", line 238, in iterator
    for row in self.query.results_iter():
  File "/usr/lib/pymodules/python2.6/django/db/models/sql/query.py", line 287, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/usr/lib/pymodules/python2.6/django/db/models/sql/query.py", line 2369, in execute_sql
    cursor.execute(sql, params)
  File "/usr/lib/pymodules/python2.6/django/db/backends/util.py", line 19, in execute
    return self.cursor.execute(sql, params)
psycopg2.ProgrammingError: operator does not exist: text = integer
LINE 1: ...46 AND "opportunities_opportunity"."description" = 152349 )...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Related branches

Changed in harvest:
milestone: none → 0.2.11
status: In Progress → Fix Committed
Changed in harvest:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.