Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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 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, 'SO066_.pdf', 1, 1,... ^ HINT: You will need to rewrite or cast the expression.
What would I need to do to correct this?
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.
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 9/30/14, 8:28 AM|
|Seen: 1813 times|
|Last updated: 3/16/15, 8:10 AM|