Oultool plugin , archiving sent mails problem

[Jad Tabet]

Hello,
When I try to push a sent email using outlook plugin, I get the following error

Fault response contains string value where integer expected [ fault response : struct mapped to type Fault : member faultCode mapped to type Int32].

In order to get the error :
Go to your sent items folder.
Select a sent email.
Click OpenERP-> Document.
The above error is shown.

Am using outlook 2010 32 bit. on a 64 bit OS

[Amit Bhavsar (Open ERP) (amb-openerp)]

Hello Jad Tabet,

I have checked you Issue, I have faced the same problem and traceback.
------------------------------------------
Traceback
-----------------
2012-06-25 06:27:33,967 3128 ERROR None openerp.sql_db: Programming error: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (134060...
                                                             ^
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-25 06:27:33,968 3128 ERROR None openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
  File "/home/amb/rdtolls/server/trunk/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/amb/rdtolls/server/trunk/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/amb/rdtolls/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/amb/rdtolls/addons/trunk/plugin/plugin_handler.py", line 51, in document_get
    msg_ids = mail_message_obj.search(cr, uid, [('message_id','in',references)])
  File "/home/amb/rdtolls/server/trunk/openerp/osv/orm.py", line 2264, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/amb/rdtolls/server/trunk/openerp/osv/orm.py", line 4627, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/amb/rdtolls/server/trunk/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/home/amb/rdtolls/server/trunk/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 (134060...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

2012-06-25 06:27:34,099 3128 ERROR None openerp.netsvc: operator does not exist: character varying = numeric
LINE 1: ...M "mail_message" WHERE (mail_message."message_id" in (134060...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
================================================================================

Also I have attached the screen-cast for reproduce. So I confirm this Issue with medium Importance.
@Team : please give look into lp: 931523

Thanks for reporting!

[Wim Audenaert (wim-audenaert)]

I have the same problem in Thunderbird 14.0.

[Yannick Gouin (yannick-gouin)]

Hi everyone,

The problem seems to be that the column "message_id' (table "mail_message") is a string but you gave it an integer.
It should'nt be WHERE (mail_message."message_id" in (134060)) but: WHERE (mail_message."message_id" in ('134060'))

So you can either :
-change the field "message_id' in the object "mail_message" (from addon "mail") but you assume that all your message_id will always contain only digits.
- or (much better) you keep "message_id" as a string but transform your integer to a string.

[Rob Hill (rhill-az)]

The following proposed merge would fix this bug for both Outlook and Thunderbird:
https://code.launchpad.net/~openerp-dev/openobject-addons/6.1-opw-579592-ado/+merge/128480