[Crash] when open Opportunity when base contact + mail (email_template) is installed

Bug #913732 reported by tfr (Openerp)
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Invalid
Medium
Unassigned

Bug Description

I found this error : [2012-01-09 11:35:52,519][?] ERROR:db.cursor:bad query: SELECT crm_lead."date_closed",date_trunc('second', crm_lead."create_date") as create_date,crm_lead."probability",crm_lead."type_id",crm_lead."color",crm_lead."partner_address_id",crm_lead."date_action_last",crm_lead."contact_id",crm_lead."day_open",crm_lead."contact_name",crm_lead."planned_revenue",crm_lead."date_action_next",crm_lead."city",crm_lead."user_id",crm_lead."zip",crm_lead."title",crm_lead."partner_name",crm_lead."partner_id",crm_lead."location_id",crm_lead."country_id",crm_lead."company_id",crm_lead."id",crm_lead."priority",crm_lead."state",crm_lead."email_cc",crm_lead."type",crm_lead."email",crm_lead."function",crm_lead."fax",crm_lead."optin",crm_lead."description",crm_lead."date_open",crm_lead."street2",crm_lead."ref2",crm_lead."section_id",crm_lead."title_action",crm_lead."phone",crm_lead."day_close",date_trunc('second', crm_lead."write_date") as write_date,crm_lead."active",crm_lead."date_action",crm_lead."categ_id",crm_lead."stage_id",crm_lead."name",crm_lead."date_deadline",crm_lead."optout",crm_lead."ref",crm_lead."birthdate",crm_lead."channel_id",crm_lead."street",crm_lead."state_id",crm_lead."email_from",crm_lead."referred",crm_lead.id FROM "crm_lead" WHERE crm_lead.id IN (16, 17, 14, 22, 15) ORDER BY priority,date_action,id desc
Traceback (most recent call last):
  File "/home/openerp/mck/openerp/server/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block

[2012-01-09 11:35:52,520][?] ERROR:db.cursor:bad query: SELECT res_partner."name",res_partner.id FROM "res_partner" WHERE res_partner.id IN (9, 26, 7, 22, 17) ORDER BY name
Traceback (most recent call last):
  File "/home/openerp/mck/openerp/server/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block

[2012-01-09 11:35:52,521][?] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/openerp/mck/openerp/server/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/openerp/mck/openerp/server/openerp/osv/osv.py", line 172, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/openerp/mck/openerp/server/openerp/osv/osv.py", line 163, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/openerp/mck/openerp/server/openerp/osv/orm.py", line 3372, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/openerp/mck/openerp/server/openerp/osv/orm.py", line 3495, in _read_flat
    res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
  File "/home/openerp/mck/openerp/server/openerp/osv/fields.py", line 409, in get
    context=context))
  File "/home/openerp/mck/openerp/server/openerp/addons/base/res/res_partner.py", line 208, in name_get
    res = [(r['id'], r[rec_name]) for r in self.read(cr, uid, ids, [rec_name], context)]
  File "/home/openerp/mck/openerp/server/openerp/osv/orm.py", line 3372, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/openerp/mck/openerp/server/openerp/osv/orm.py", line 3431, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/home/openerp/mck/openerp/server/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/openerp/mck/openerp/server/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block

When you just click on the menuitem "Opportunity or lead" when crm base_contact + email template
are installed

Revision history for this message
Amit Bhavsar (Open ERP) (amb-openerp) wrote :

Hello Thibaut,

I have checked your Issue at my,
Revision number,
server : 3952
client : 2029
addons : 6305
web-client : 1902
This error was produced since last day. And today it doesn't produced anymore. That's why I have attached the video.would you please check this video.

so would you please try with latest revision number and notify us have you still faced the problem or not.

Thanks!

Changed in openobject-addons:
status: New → Incomplete
Revision history for this message
Amit Bhavsar (Open ERP) (amb-openerp) wrote :
Revision history for this message
tfr (Openerp) (tfr) wrote :

Yes indeed, when I reported the bug I was unable to check on the last trunk. Thx

Changed in openobject-addons:
status: Incomplete → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.