openerp-india team mailing list archive

[pin8 <1013631@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Outlook plugin "contact" option works ok.
"documents" option" throws the below error:


2012-06-15 12:01:47,905 16526 INFO ? mail: Parsing Message without message-id, generating a random one: 1339761707.91
2012-06-15 12:01:47,907 16526 ERROR ? openerp.sql_db: Programming error: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (133976...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT "mail_message".id FROM "mail_message" WHERE (mail_message."message_id" in (%s)) ORDER BY date desc
2012-06-15 12:01:47,907 16526 ERROR ? openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
  File "/data/openerp/production/server/6.1/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/data/openerp/production/server/6.1/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/data/openerp/production/server/6.1/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/data/openerp/production/server/6.1/addons/plugin/plugin_handler.py", line 51, in document_get
    msg_ids = mail_message_obj.search(cr, uid, [('message_id','in',references)])
  File "/data/openerp/production/server/6.1/openerp/osv/orm.py", line 2245, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/data/openerp/production/server/6.1/openerp/osv/orm.py", line 4595, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/data/openerp/production/server/6.1/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/data/openerp/production/server/6.1/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (133976...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

2012-06-15 12:01:47,908 16526 ERROR ? openerp.netsvc: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (133976...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.


I'm using openerp 6.1, with outlook plugin 64 bit installed on a "Windows7 Home Premium" computer.

Please assist. thanks.
pin8

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1013631

Title:
  Error with OpenERP Outlook plugin

Status in OpenERP Addons (modules):
  New

Bug description:
  Outlook plugin "contact" option works ok.
  "documents" option" throws the below error:

  
  2012-06-15 12:01:47,905 16526 INFO ? mail: Parsing Message without message-id, generating a random one: 1339761707.91
  2012-06-15 12:01:47,907 16526 ERROR ? openerp.sql_db: Programming error: operator does not exist: character varying = numeric
  LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (133976...
                                                               ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
  , in query SELECT "mail_message".id FROM "mail_message" WHERE (mail_message."message_id" in (%s)) ORDER BY date desc
  2012-06-15 12:01:47,907 16526 ERROR ? openerp.osv.osv: Uncaught exception
  Traceback (most recent call last):
    File "/data/openerp/production/server/6.1/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/data/openerp/production/server/6.1/openerp/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/data/openerp/production/server/6.1/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/data/openerp/production/server/6.1/addons/plugin/plugin_handler.py", line 51, in document_get
      msg_ids = mail_message_obj.search(cr, uid, [('message_id','in',references)])
    File "/data/openerp/production/server/6.1/openerp/osv/orm.py", line 2245, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/data/openerp/production/server/6.1/openerp/osv/orm.py", line 4595, in _search
      cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
    File "/data/openerp/production/server/6.1/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/data/openerp/production/server/6.1/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: operator does not exist: character varying = numeric
  LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (133976...
                                                               ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

  2012-06-15 12:01:47,908 16526 ERROR ? openerp.netsvc: operator does not exist: character varying = numeric
  LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (133976...
                                                               ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

  
  I'm using openerp 6.1, with outlook plugin 64 bit installed on a "Windows7 Home Premium" computer.

  Please assist. thanks.
  pin8

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1013631/+subscriptions