Merge lp:~openerp-dev/openobject-addons/6.1-opw-577769-hpa into lp:openobject-addons/6.1

Proposed by Hemendra Paregi (OpenERP)
Status: Needs review
Proposed branch: lp:~openerp-dev/openobject-addons/6.1-opw-577769-hpa
Merge into: lp:openobject-addons/6.1
Diff against target: 12 lines (+1/-1)
1 file modified
marketing_campaign/report/campaign_analysis_view.xml (+1/-1)
To merge this branch: bzr merge lp:~openerp-dev/openobject-addons/6.1-opw-577769-hpa
Reviewer Review Type Date Requested Status
Olivier Dony (Odoo) Pending
Naresh(OpenERP) Pending
Review via email:

Description of the change


Open this menu in WEB Marketing/Reporting/Campaign Analysis
Clear/Find and click on "Month-1" GOT ERROR:

OpenERP Server Error

Client Traceback (most recent call last):
   File "/home/hemendra/rdtool/ver-6.1/web/addons/web/common/",
  line 180, in dispatch
     response["result"] = method(controller, self, **self.params)
   File "/home/hemendra/rdtool/ver-6.1/web/addons/web/controllers/",
  line 1082, in read
     dict(context, group_by=group_by_fields), sort or False)
  line 250, in proxy
     args, kw)
  line 117, in proxy
     result = self.connector.send(self.service_name, method, *args)
   File "/home/hemendra/rdtool/ver-6.1/web/addons/web/common/",
line 608, in send
     raise xmlrpclib.Fault(,

Server Traceback (most recent call last):
   File "/home/hemendra/rdtool/ver-6.1/web/addons/web/common/",
line 593, in send
     return openerp.netsvc.dispatch_rpc(service_name, method, args)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/", line 360,
  in dispatch_rpc
     result = ExportService.getService(service_name).dispatch(method,
  line 586, in dispatch
     res = fn(db, uid, *params)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/osv/", line 167,
  in execute_kw
     return self.execute(db, uid, obj, method, *args, **kw or {})
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/osv/", line 121,
  in wrapper
     return f(self, dbname, *args, **kwargs)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/osv/", line 176,
  in execute
     res = self.execute_cr(cr, uid, obj, method, *args, **kw)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/osv/", line
in execute_cr
     return getattr(object, method)(cr, uid, *args, **kw)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/osv/", line
  in read_group
     cr.execute('SELECT min( AS id, count( AS %s_count'
% (self._table, self._table, group_count) + (flist and ',') + flist +
  ' FROM ' + from_clause + where_clause + gb + limit_str + offset_str,
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/", line
152, in wrapper
     return f(self, *args, **kwargs)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/", line
212, in execute
     res = self._obj.execute(query, params)
ProgrammingError: column campaign_analysis.create_date does not exist
LINE 1: ...nue") AS revenue FROM "campaign_analysis" WHERE ((campaign_a...
This fixes the issue.


To post a comment you must log in.
Revision history for this message
Naresh(OpenERP) (nch-openerp) wrote :


This bug was qualified as Not Relevant on Trunk (means that architecture on trunk has changed and so this bug has no meaning anymore). If this Merge Proposal could not be merged in v6.1 at the release of v7.0, it will be closed.

Naresh Soni

Unmerged revisions

6938. By Hemendra Paregi (OpenERP)

[FIX] marketing_campaign: Error in Campaign Analysis because create_date field not found in view' (Case:577769)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'marketing_campaign/report/campaign_analysis_view.xml'
2--- marketing_campaign/report/campaign_analysis_view.xml 2011-11-11 08:43:58 +0000
3+++ marketing_campaign/report/campaign_analysis_view.xml 2012-08-08 06:03:25 +0000
4@@ -41,7 +41,7 @@
5 string="Month" name="This Month"
6 domain="[('month','=',time.strftime('%%m'))]"/>
7 <filter icon="terp-go-month" string=" Month-1 "
8- domain="[('create_date','&lt;=', ( - relativedelta(day=31, months=1)).strftime('%%Y-%%m-%%d')),('create_date','&gt;=',( - relativedelta(day=1,months=1)).strftime('%%Y-%%m-%%d'))]"/>
9+ domain="[('date','&lt;=', ( - relativedelta(day=31, months=1)).strftime('%%Y-%%m-%%d')),('date','&gt;=',( - relativedelta(day=1,months=1)).strftime('%%Y-%%m-%%d'))]"/>
11 <filter icon="terp-go-today"
12 string="Today"