c2c-oerpscenario team mailing list archive

[Amós Oviedo <798655@xxxxxxxxxxxxxxxxxx>]

** Description changed:

+ Version 6.0.2
  My revno. is 4663
  
  When I update the modules this error appears, the column country_id is
  removed in crm_lead but when creating crm_lead_report, in the select for
  creating table the column still appears:
  
  [2011-06-17 13:49:17,957][Isonor_601_110303] INFO:orm:column country_id
  (Country) in table crm_lead removed: converted to a function !
  
  [2011-06-17 13:49:18,170][Isonor_601_110303] ERROR:db.cursor:Programming error: no existe la columna c.country_id
  LÍNEA 23:                     c.country_id,
-                               ^
- , in query 
-             CREATE OR REPLACE VIEW crm_lead_report AS (
-                 SELECT
-                     id,
-                     to_char(c.create_date, 'YYYY') as name,
-                     to_char(c.create_date, 'MM') as month,
-                     to_char(c.create_date, 'YYYY-MM-DD') as day,
-                     to_char(c.create_date, 'YYYY-MM-DD') as creation_date,
-                     to_char(c.date_open, 'YYYY-MM-DD') as opening_date,
-                     to_char(c.date_closed, 'YYYY-mm-dd') as date_closed,
-                     c.state,
-                     c.user_id,
-                     c.probability,
-                     c.stage_id,
-                     c.type,
-                     c.company_id,
-                     c.priority,
-                     c.section_id,
-                     c.channel_id,
-                     c.type_id,
-                     c.categ_id,
-                     c.partner_id,
-                     c.country_id,
-                     c.planned_revenue,
-                     c.planned_revenue*(c.probability/100) as probable_revenue, 
-                     1 as nbr,
-                     (SELECT count(id) FROM mailgate_message WHERE model='crm.lead' AND res_id=c.id AND history=True) AS email,
-                     date_trunc('day',c.create_date) as create_date,
-                     extract('epoch' from (c.date_closed-c.create_date))/(3600*24) as  delay_close,
-                     abs(extract('epoch' from (c.date_deadline - c.date_closed))/(3600*24)) as  delay_expected,
-                     extract('epoch' from (c.date_open-c.create_date))/(3600*24) as  delay_open
-                 FROM
-                     crm_lead c
-             )
+                               ^
+ , in query
+             CREATE OR REPLACE VIEW crm_lead_report AS (
+                 SELECT
+                     id,
+                     to_char(c.create_date, 'YYYY') as name,
+                     to_char(c.create_date, 'MM') as month,
+                     to_char(c.create_date, 'YYYY-MM-DD') as day,
+                     to_char(c.create_date, 'YYYY-MM-DD') as creation_date,
+                     to_char(c.date_open, 'YYYY-MM-DD') as opening_date,
+                     to_char(c.date_closed, 'YYYY-mm-dd') as date_closed,
+                     c.state,
+                     c.user_id,
+                     c.probability,
+                     c.stage_id,
+                     c.type,
+                     c.company_id,
+                     c.priority,
+                     c.section_id,
+                     c.channel_id,
+                     c.type_id,
+                     c.categ_id,
+                     c.partner_id,
+                     c.country_id,
+                     c.planned_revenue,
+                     c.planned_revenue*(c.probability/100) as probable_revenue,
+                     1 as nbr,
+                     (SELECT count(id) FROM mailgate_message WHERE model='crm.lead' AND res_id=c.id AND history=True) AS email,
+                     date_trunc('day',c.create_date) as create_date,
+                     extract('epoch' from (c.date_closed-c.create_date))/(3600*24) as  delay_close,
+                     abs(extract('epoch' from (c.date_deadline - c.date_closed))/(3600*24)) as  delay_expected,
+                     extract('epoch' from (c.date_open-c.create_date))/(3600*24) as  delay_open
+                 FROM
+                     crm_lead c
+             )

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/798655

Title:
  country_id in crm_lead doesn't exist and can't start server when
  updating modules

Status in OpenERP Modules (addons):
  New

Bug description:
  Version 6.0.2
  My revno. is 4663

  When I update the modules this error appears, the column country_id is
  removed in crm_lead but when creating crm_lead_report, in the select
  for creating table the column still appears:

  [2011-06-17 13:49:17,957][Isonor_601_110303] INFO:orm:column
  country_id (Country) in table crm_lead removed: converted to a
  function !

  [2011-06-17 13:49:18,170][Isonor_601_110303] ERROR:db.cursor:Programming error: no existe la columna c.country_id
  LÍNEA 23:                     c.country_id,
                                ^
  , in query
              CREATE OR REPLACE VIEW crm_lead_report AS (
                  SELECT
                      id,
                      to_char(c.create_date, 'YYYY') as name,
                      to_char(c.create_date, 'MM') as month,
                      to_char(c.create_date, 'YYYY-MM-DD') as day,
                      to_char(c.create_date, 'YYYY-MM-DD') as creation_date,
                      to_char(c.date_open, 'YYYY-MM-DD') as opening_date,
                      to_char(c.date_closed, 'YYYY-mm-dd') as date_closed,
                      c.state,
                      c.user_id,
                      c.probability,
                      c.stage_id,
                      c.type,
                      c.company_id,
                      c.priority,
                      c.section_id,
                      c.channel_id,
                      c.type_id,
                      c.categ_id,
                      c.partner_id,
                      c.country_id,
                      c.planned_revenue,
                      c.planned_revenue*(c.probability/100) as probable_revenue,
                      1 as nbr,
                      (SELECT count(id) FROM mailgate_message WHERE model='crm.lead' AND res_id=c.id AND history=True) AS email,
                      date_trunc('day',c.create_date) as create_date,
                      extract('epoch' from (c.date_closed-c.create_date))/(3600*24) as  delay_close,
                      abs(extract('epoch' from (c.date_deadline - c.date_closed))/(3600*24)) as  delay_expected,
                      extract('epoch' from (c.date_open-c.create_date))/(3600*24) as  delay_open
                  FROM
                      crm_lead c
              )

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