openerp-india team mailing list archive

["Aline \(OpenERP\)" <985461@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

in a fresh db (without demo data),

- install leaves management 
- go to opportunities, click in the menu: 


2012-04-19 07:58:52,813 2650 INFO None werkzeug: 127.0.0.1 - - [19/Apr/2012 07:58:52] "POST /web/dataset/search_read HTTP/1.1" 200 -
2012-04-19 07:58:52,818 2650 ERROR None openerp.sql_db: Programming error: column crm_lead.opt_out does not exist
LINE 1: ...e_action_next",crm_lead."city",crm_lead."user_id",crm_lead."...
                                                             ^
, in query SELECT crm_lead."comment",crm_lead."ean13",crm_lead."probability",crm_lead."type_id",crm_lead."color",crm_lead."photo",crm_lead."date_action_last",crm_lead."day_close",crm_lead."active",crm_lead."day_open",crm_lead."date_action_next",crm_lead."city",crm_lead."user_id",crm_lead."opt_out",crm_lead."zip",crm_lead."title",crm_lead."company_id",crm_lead."priority",crm_lead."parent_id",crm_lead."employee",crm_lead."email_cc",crm_lead."type",crm_lead."vat",crm_lead."website",crm_lead."fax",crm_lead."title_action",crm_lead."phone",crm_lead."customer",crm_lead."name",crm_lead."date_deadline",crm_lead."birthdate",crm_lead."email",crm_lead."channel_id",crm_lead."street",crm_lead."state_id",crm_lead."email_from",crm_lead."referred",crm_lead."date_closed",crm_lead."function",date_trunc('second', crm_lead."create_date") as create_date,crm_lead."use_parent_address",crm_lead."contact_name",crm_lead."planned_revenue",crm_lead."id",crm_lead."date_open",crm_lead."partner_name",crm_lead."partner_id",crm_lead."country_id",crm_lead."state",crm_lead."supplier",crm_lead."ref",crm_lead."is_company",crm_lead."optin",crm_lead."description",crm_lead."street2",crm_lead."ref2",crm_lead."section_id",date_trunc('second', crm_lead."write_date") as write_date,crm_lead."date",crm_lead."date_action",crm_lead."categ_id",crm_lead."lang",crm_lead."stage_id",crm_lead."credit_limit",crm_lead."optout",crm_lead."mobile",crm_lead.id FROM "crm_lead" WHERE crm_lead.id IN %s ORDER BY priority,date_action,id desc
2012-04-19 07:58:52,825 2650 ERROR None openerp.sql_db: bad query: SELECT crm_lead."comment",crm_lead."ean13",crm_lead."probability",crm_lead."type_id",crm_lead."color",crm_lead."photo",crm_lead."date_action_last",crm_lead."day_close",crm_lead."active",crm_lead."day_open",crm_lead."date_action_next",crm_lead."city",crm_lead."user_id",crm_lead."opt_out",crm_lead."zip",crm_lead."title",crm_lead."company_id",crm_lead."priority",crm_lead."parent_id",crm_lead."employee",crm_lead."email_cc",crm_lead."type",crm_lead."vat",crm_lead."website",crm_lead."fax",crm_lead."title_action",crm_lead."phone",crm_lead."customer",crm_lead."name",crm_lead."date_deadline",crm_lead."birthdate",crm_lead."email",crm_lead."channel_id",crm_lead."street",crm_lead."state_id",crm_lead."email_from",crm_lead."referred",crm_lead."date_closed",crm_lead."function",date_trunc('second', crm_lead."create_date") as create_date,crm_lead."use_parent_address",crm_lead."contact_name",crm_lead."planned_revenue",crm_lead."id",crm_lead."date_open",crm_lead."partner_name",crm_lead."partner_id",crm_lead."country_id",crm_lead."state",crm_lead."supplier",crm_lead."ref",crm_lead."is_company",crm_lead."optin",crm_lead."description",crm_lead."street2",crm_lead."ref2",crm_lead."section_id",date_trunc('second', crm_lead."write_date") as write_date,crm_lead."date",crm_lead."date_action",crm_lead."categ_id",crm_lead."lang",crm_lead."stage_id",crm_lead."credit_limit",crm_lead."optout",crm_lead."mobile",crm_lead.id FROM "crm_lead" WHERE crm_lead.id IN (24, 25) ORDER BY priority,date_action,id desc
Traceback (most recent call last):
  File "/home/aline/source/server/trunk/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block

** Affects: openobject-addons
     Importance: Medium
         Status: Confirmed

** Changed in: openobject-addons
       Status: New => Confirmed

** Changed in: openobject-addons
   Importance: Undecided => Medium

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/985461

Title:
  [trunk] column crm_lead.opt_out does not exist

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  in a fresh db (without demo data),

  - install leaves management 
  - go to opportunities, click in the menu: 

  
  2012-04-19 07:58:52,813 2650 INFO None werkzeug: 127.0.0.1 - - [19/Apr/2012 07:58:52] "POST /web/dataset/search_read HTTP/1.1" 200 -
  2012-04-19 07:58:52,818 2650 ERROR None openerp.sql_db: Programming error: column crm_lead.opt_out does not exist
  LINE 1: ...e_action_next",crm_lead."city",crm_lead."user_id",crm_lead."...
                                                               ^
  , in query SELECT crm_lead."comment",crm_lead."ean13",crm_lead."probability",crm_lead."type_id",crm_lead."color",crm_lead."photo",crm_lead."date_action_last",crm_lead."day_close",crm_lead."active",crm_lead."day_open",crm_lead."date_action_next",crm_lead."city",crm_lead."user_id",crm_lead."opt_out",crm_lead."zip",crm_lead."title",crm_lead."company_id",crm_lead."priority",crm_lead."parent_id",crm_lead."employee",crm_lead."email_cc",crm_lead."type",crm_lead."vat",crm_lead."website",crm_lead."fax",crm_lead."title_action",crm_lead."phone",crm_lead."customer",crm_lead."name",crm_lead."date_deadline",crm_lead."birthdate",crm_lead."email",crm_lead."channel_id",crm_lead."street",crm_lead."state_id",crm_lead."email_from",crm_lead."referred",crm_lead."date_closed",crm_lead."function",date_trunc('second', crm_lead."create_date") as create_date,crm_lead."use_parent_address",crm_lead."contact_name",crm_lead."planned_revenue",crm_lead."id",crm_lead."date_open",crm_lead."partner_name",crm_lead."partner_id",crm_lead."country_id",crm_lead."state",crm_lead."supplier",crm_lead."ref",crm_lead."is_company",crm_lead."optin",crm_lead."description",crm_lead."street2",crm_lead."ref2",crm_lead."section_id",date_trunc('second', crm_lead."write_date") as write_date,crm_lead."date",crm_lead."date_action",crm_lead."categ_id",crm_lead."lang",crm_lead."stage_id",crm_lead."credit_limit",crm_lead."optout",crm_lead."mobile",crm_lead.id FROM "crm_lead" WHERE crm_lead.id IN %s ORDER BY priority,date_action,id desc
  2012-04-19 07:58:52,825 2650 ERROR None openerp.sql_db: bad query: SELECT crm_lead."comment",crm_lead."ean13",crm_lead."probability",crm_lead."type_id",crm_lead."color",crm_lead."photo",crm_lead."date_action_last",crm_lead."day_close",crm_lead."active",crm_lead."day_open",crm_lead."date_action_next",crm_lead."city",crm_lead."user_id",crm_lead."opt_out",crm_lead."zip",crm_lead."title",crm_lead."company_id",crm_lead."priority",crm_lead."parent_id",crm_lead."employee",crm_lead."email_cc",crm_lead."type",crm_lead."vat",crm_lead."website",crm_lead."fax",crm_lead."title_action",crm_lead."phone",crm_lead."customer",crm_lead."name",crm_lead."date_deadline",crm_lead."birthdate",crm_lead."email",crm_lead."channel_id",crm_lead."street",crm_lead."state_id",crm_lead."email_from",crm_lead."referred",crm_lead."date_closed",crm_lead."function",date_trunc('second', crm_lead."create_date") as create_date,crm_lead."use_parent_address",crm_lead."contact_name",crm_lead."planned_revenue",crm_lead."id",crm_lead."date_open",crm_lead."partner_name",crm_lead."partner_id",crm_lead."country_id",crm_lead."state",crm_lead."supplier",crm_lead."ref",crm_lead."is_company",crm_lead."optin",crm_lead."description",crm_lead."street2",crm_lead."ref2",crm_lead."section_id",date_trunc('second', crm_lead."write_date") as write_date,crm_lead."date",crm_lead."date_action",crm_lead."categ_id",crm_lead."lang",crm_lead."stage_id",crm_lead."credit_limit",crm_lead."optout",crm_lead."mobile",crm_lead.id FROM "crm_lead" WHERE crm_lead.id IN (24, 25) ORDER BY priority,date_action,id desc
  Traceback (most recent call last):
    File "/home/aline/source/server/trunk/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  InternalError: current transaction is aborted, commands ignored until end of transaction block

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/985461/+subscriptions