Odoo Help

Welcome!

This community 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.

0

Unable to send RFQ by email

By
Farook
on 2/20/13, 7:32 AM 2,393 views

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

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

Andreas Brueckl
on 2/20/13, 8:01 AM

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
on 2/28/13, 11:16 AM
0
rishi kesh
On 4/4/13, 10:40 AM

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,...
                                                             ^

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.

rishi kesh
on 4/4/13, 5:31 PM

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.

Landis Arnold
on 12/10/13, 3:10 PM
0
Landis Arnold
On 2/28/13, 11:19 AM

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
0
Alex Ferrer
On 7/11/14, 3:43 AM

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'

 

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 2/20/13, 7:32 AM
Seen: 2393 times
Last updated: 3/16/15, 8:10 AM