c2c-oerpscenario team mailing list archive

["Anup \(OpenERP\)" <ach@xxxxxxxxxxx>]

*** This bug is a duplicate of bug 666857 ***
    https://bugs.launchpad.net/bugs/666857

** This bug has been marked a duplicate of bug 666857
   [6.0] fetchmail module check_duplicate code sql query is wrong
 * You can subscribe to bug 666857 by following this link: https://bugs.launchpad.net/openobject-addons/+bug/666857/+subscribe

-- 
Cannot add mail server (imap or pop)
https://bugs.launchpad.net/bugs/667763
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Addons Modules: New

Bug description:
Version 6.0 RC1
trying to add imap or pop server get the following when trying to save

, in query select count(id) from email_server where user='%s' and password='%s'
[2010-10-28 14:14:01,808][OpenErp62] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/mnt/downloads/OpenERP/Openerp-6.0/openerp-server-6.0.0-rc1/bin/osv/osv.py", line 57, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/mnt/downloads/OpenERP/Openerp-6.0/openerp-server-6.0.0-rc1/bin/osv/osv.py", line 140, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/mnt/downloads/OpenERP/Openerp-6.0/openerp-server-6.0.0-rc1/bin/osv/osv.py", line 130, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/mnt/downloads/OpenERP/Openerp-6.0/openerp-server-6.0.0-rc1/bin/osv/orm.py", line 3740, in create
    self._validate(cr, user, [id_new], context)
  File "/mnt/downloads/OpenERP/Openerp-6.0/openerp-server-6.0.0-rc1/bin/osv/orm.py", line 1025, in _validate
    if not fun(self, cr, uid, ids):
  File "/mnt/downloads/OpenERP/Openerp-6.0/openerp-server-6.0.0-rc1/bin/addons/fetchmail/fetchmail.py", line 76, in check_duplicate
    cr.execute("select count(id) from email_server where user='%s' and password='%s'", (vals['user'], vals['password']))
  File "/mnt/downloads/OpenERP/Openerp-6.0/openerp-server-6.0.0-rc1/bin/sql_db.py", line 75, in wrapper
    return f(self, *args, **kwargs)
  File "/mnt/downloads/OpenERP/Openerp-6.0/openerp-server-6.0.0-rc1/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: syntax error at or near "xxxxx"
LINE 1: select count(id) from email_server where user='E'xxxxx'' and...