Unable to send RFQ by email

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

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

Unable to send RFQ by email

3 Replies

5252 Views

Farook

Hi I'm getting below error while trying to send an RFQ by mail to a supplier. Can anybody please help?

OpenERP Server Error
Client Traceback (most recent call last):
  File "C:\Program Files\OpenERP 7.0-20130207-002327\Server\server\openerp\addons\web\http.py", line 195, in dispatch
  File "C:\Program Files\OpenERP 7.0-20130207-002327\Server\server\openerp\addons\web\controllers\main.py", line 1078, in call_kw
  File "C:\Program Files\OpenERP 7.0-20130207-002327\Server\server\openerp\addons\web\controllers\main.py", line 1070, in _call_kw
  File "C:\Program Files\OpenERP 7.0-20130207-002327\Server\server\openerp\addons\web\session.py", line 43, in proxy
  File "C:\Program Files\OpenERP 7.0-20130207-002327\Server\server\openerp\addons\web\session.py", line 31, in proxy_method
  File "C:\Program Files\OpenERP 7.0-20130207-002327\Server\server\openerp\addons\web\session.py", line 104, in send

Andreas Brueckl

Do you have any additional log files? The logs you posted are not significant enough.

Landis Arnold

I am getting the same problem in a Debian install, trying to email Suppliers and Customers (PO and SO as well as quotations). This is my error file. Client Traceback (most recent call last): File "/opt/openerp/web/addons/web/http.py", line 195, in dispatch response["result"] = method(self, **self.params) File "/opt/openerp/web/addons/web/controllers/main.py", line 1079, in call_kw return self._call_kw(req, model, method, args, kwargs) File "/opt/openerp/web/addons/web/controllers/main.py", line 1071, in _call_kw return getattr(req.session.model(model), method) (SHORTENED)

Landis Arnold

I am having the same problem with RFQ/Purchase orders as well as Quotation/Sales Orders. Full error message is the following. (I have posted elsewhere on this with no responses and I find this that seems also unsolved).

(I post this as an answer only because there is not enough space in Comments to post the full error message. It is not an answer, but a confirmation of the same problem. There should be some granularity provided rather than the binary yes/no of an answer.)

Client Traceback (most recent call last):
  File "/opt/openerp/web/addons/web/http.py", line 195, in dispatch
    response["result"] = method(self, **self.params)
  File "/opt/openerp/web/addons/web/controllers/main.py", line 1079, in call_kw
    return self._call_kw(req, model, method, args, kwargs)
  File "/opt/openerp/web/addons/web/controllers/main.py", line 1071, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/opt/openerp/web/addons/web/session.py", line 43, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/opt/openerp/web/addons/web/session.py", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/opt/openerp/web/addons/web/session.py", line 104, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/opt/openerp/web/addons/web/session.py", line 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/netsvc.py", line 295, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 614, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/openerp/osv/osv.py", line 198, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/addons/email_template/wizard/mail_compose_message.py", line 85, in onchange_template_id
    values['attachment_ids'].append(ir_attach_obj.create(cr, uid, data_attach, context=context))
  File "/opt/openerp/addons/document/document.py", line 121, in create
    vals['file_type'], vals['index_content'] = self._index(cr, uid, vals['datas'].decode('base64'), vals.get('datas_fname', False), None)
  File "/opt/openerp/addons/document/document.py", line 132, in _index
    mime, icont = cntIndex.doIndex(data, datas_fname,  file_type or None, None)
TypeError: 'NoneType' object is not iterable

rishi kesh

Same problem here. Everything was working smoothly till i started getting this error:

OpenERP Server Error
Client Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/addons/web/http.py", line 203, in dispatch
    response["result"] = method(self, **self.params)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/addons/web/controllers/main.py", line 1129, in call_kw
    return self._call_kw(req, model, method, args, kwargs)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/addons/web/controllers/main.py", line 1121, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/addons/web/session.py", line 43, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/addons/web/session.py", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/addons/web/session.py", line 104, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/addons/web/session.py", line 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/netsvc.py", line 293, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/addons/email_template/wizard/mail_compose_message.py", line 85, in onchange_template_id
    values['attachment_ids'].append(ir_attach_obj.create(cr, uid, data_attach, context=context))
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/addons/base/ir/ir_attachment.py", line 290, in create
    return super(ir_attachment, self).create(cr, uid, values, context)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/osv/orm.py", line 4434, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20130326_002357-py2.6.egg/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "write_uid" of relation "ir_attachment" does not exist
LINE 1: ...ze","res_id","datas_fname",create_uid,create_date,write_uid,...
                                                             ^

rishi kesh

I have solved it. I had uninstalled some unused modules and it was creating the problem. I re installed the modules and it started working properly.

Landis Arnold

nice fix. I was early in my testing and simply abandoned the database. I have been finding I can get past some errors, but it is complicated process. What were the modules you uninstalled and reinstalled? Likely forgotten, understood.

Alex Ferrer

Same problem here,

Odoo Version 8.0dev-20140416-230101

Ubuntu 14.04

Traceback (most recent call last): File "/opt/openerp/openerp/http.py", line 470, in dispatch result = self._call_function(**self.params) File "/opt/openerp/openerp/http.py", line 294, in _call_function return checked_call(self.db, *args, **kwargs) File "/opt/openerp/openerp/service/model.py", line 113, in wrapper return f(dbname, *args, **kwargs) File "/opt/openerp/openerp/http.py", line 291, in checked_call return self.endpoint(*a, **kw) File "/opt/openerp/openerp/http.py", line 638, in __call__ return self.method(*args, **kw) File "/opt/openerp/openerp/http.py", line 337, in response_wrap response = f(*args, **kw) File "/opt/openerp/openerp/addons/web/controllers/main.py", line 1242, in call_kw return self._call_kw(model, method, args, kwargs) File "/opt/openerp/openerp/addons/web/controllers/main.py", line 1234, in _call_kw return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs) File "/opt/openerp/openerp/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 "/opt/openerp/openerp/addons/email_template/wizard/mail_compose_message.py", line 99, in onchange_template_id values = self.generate_email_for_composer_batch(cr, uid, template_id, [res_id], context=context)[res_id] File "/opt/openerp/openerp/addons/email_template/wizard/mail_compose_message.py", line 174, in generate_email_for_composer_batch template_values = self.pool.get('email.template').generate_email_batch(cr, uid, template_id, res_ids, fields=fields, context=context) File "/opt/openerp/openerp/addons/email_template/email_template.py", line 452, in generate_email_batch result, format = self.pool['report'].get_pdf(cr, uid, [res_id], report_service, context=ctx), 'pdf' File "/opt/openerp/openerp/addons/report/models/report.py", line 255, in get_pdf html = self.get_html(cr, uid, ids, report_name, data=data, context=context) File "/opt/openerp/openerp/addons/report/models/report.py", line 246, in get_html return self.render(cr, uid, [], report.report_name, docargs, context=context) File "/opt/openerp/openerp/addons/report/models/report.py", line 222, in render return view_obj.render(cr, uid, template, values, context=context) File "/opt/openerp/openerp/addons/base/ir/ir_ui_view.py", line 870, in render return self.pool[engine].render(cr, uid, id_or_xml_id, qcontext, loader=loader, context=context) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 233, in render return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 277, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 294, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 275, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 388, in render_tag_call d[0] = self.render_element(element, template_attributes, generated_attributes, d) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 294, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 275, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 374, in render_tag_foreach ru.append(self.render_element(element, template_attributes, generated_attributes, copy_qwebcontext)) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 294, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 275, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 388, in render_tag_call d[0] = self.render_element(element, template_attributes, generated_attributes, d) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 294, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 277, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 299, in render_element raise_qweb_exception(message="Could not render element %r" % element.nodeName, node=element, template=template) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 294, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 275, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/opt/openerp/openerp/addons/base/ir/ir_qweb.py", line 420, in render_tag_field column = record._model._all_columns[field_name].column QWebException: 'NoneType' object has no attribute '_model'

This question has been flagged