openerp-india team mailing list archive

["Amit Bhavsar \(Open ERP\)" <1017110@xxxxxxxxxxxxxxxxxx>]

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!

** Attachment added: "Step for reproduce"
   https://bugs.launchpad.net/openobject-addons/+bug/1017110/+attachment/3203250/+files/Outlook2010.avi

** Changed in: openobject-addons
       Status: New => Confirmed

** Changed in: openobject-addons
   Importance: Undecided => Medium

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 1 (openerp-dev-addons1)

-- 
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/1017110

Title:
  Oultool plugin , archiving sent mails problem

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  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

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