harvest-dev team mailing list archive

[Daniel Holbach <daniel.holbach@xxxxxxxxxx>]

** Changed in: harvest
       Status: In Progress => Fix Committed

** Changed in: harvest
    Milestone: None => 0.2.11

-- 
You received this bug notification because you are a member of harvest-
dev, which is the registrant for harvest.
https://bugs.launchpad.net/bugs/918172

Title:
  Type mismatch in Harvest's updateopportunities

Status in Harvest Service:
  Fix Committed

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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/harvest/+bug/918172/+subscriptions