Odoo Help


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

Brandon Fox
on 9/30/14, 8:28 AM 1,813 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. 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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: 1813 times
Last updated: 3/16/15, 8:10 AM