Odoo Help


Error when sending a sales order (quote) email to customer on a contract.

Brandon Fox
on 9/30/14, 8:28 AM 2,420 views

If I have a contract with a customer, after clicking the sales order link on the contract page to create a new sales order, I try to send this new quote to the customer by clicking the "Send by Email" button. After, I get this error:

OpenERP Server Error

Traceback (most recent call last): File "/home/odoo/src/odoo/saas-3/openerp/http.py", line 379, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/home/odoo/src/odoo/saas-3/openerp/http.py", line 398, in dispatch result = self._call_function(**self.params) File "/home/odoo/src/odoo/saas-3/openerp/http.py", line 235, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/odoo/src/odoo/saas-3/openerp/service/model.py", line 114, in wrapper return f(dbname, *args, **kwargs) File "/home/odoo/src/odoo/saas-3/openerp/http.py", line 232, in checked_call return self.func(*a, **kw) File "/home/odoo/src/odoo/saas-3/openerp/http.py", line 562, in __call__ return self.method(*args, **kw) File "/home/odoo/src/odoo/saas-3/addons/web/controllers/main.py", line 1236, in call_kw return self._call_kw(model, method, args, kwargs) File "/home/odoo/src/odoo/saas-3/addons/web/controllers/main.py", line 1228, in _call_kw return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs) File "/home/odoo/src/odoo/saas-3/addons/email_template/wizard/mail_compose_message.py", line 53, in default_get res.get('model'), res.get('res_id', context.get('active_id')), context=context File "/home/odoo/src/odoo/saas-3/addons/email_template/wizard/mail_compose_message.py", line 120, in onchange_template_id values['attachment_ids'].append(ir_attach_obj.create(cr, uid, data_attach, context=context)) File "/home/odoo/src/odoo/saas-3/addons/document/document.py", line 129, in create return super(document_file, self).create(cr, uid, vals, context) File "/home/odoo/src/odoo/saas-3/openerp/addons/base/ir/ir_attachment.py", line 301, in create return super(ir_attachment, self).create(cr, uid, values, context) File "/home/odoo/src/odoo/saas-3/openerp/osv/orm.py", line 4221, in create tuple([f[2] for f in columns if len(f) > 2]) File "/home/odoo/src/odoo/saas-3/openerp/sql_db.py", line 156, in wrapper return f(self, *args, **kwargs) File "/home/odoo/src/odoo/saas-3/openerp/sql_db.py", line 221, in execute res = self._obj.execute(query, params) ProgrammingError: column "partner_id" is of type integer but expression is of type integer[] LINE 68: ', 1, NULL, 'binary', 0, 0, ARRAY[1028], 'SO066_.pdf', 1, 1,... ^ HINT: You will need to rewrite or cast the expression.

What would I need to do to correct this?


Noble Man
On 9/30/14, 9:06 AM

@Brandon Fox  you may need to check the following 

  •  make sure you install fetchmail module
  •  you need to configure the outgoing and incoming mail server
  • make sure your customer has an email address specified in their porfile 


Brandon Fox
On 9/30/14, 10:42 AM

@Noble Man

I can send and receive email through messaging, sales order modules and everywhere else in the system. Its just this one way of trying to send a quote that I get this error. Its only when i create a sale order through the contract menu and try to send it. If i back out and go directly to that sales order from the Sales>Sales Order menu, it works fine. 

Double checked all your suggestions, all are working fine and installed. 

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/30/14, 8:28 AM
Seen: 2420 times
Last updated: 3/16/15, 8:10 AM