harvest-dev team mailing list archive

[Daniel Holbach <daniel.holbach@xxxxxxxxxx>]

Public bug reported:

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.

** Affects: harvest
     Importance: Critical
     Assignee: Daniel Holbach (dholbach)
         Status: In Progress

-- 
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:
  In Progress

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