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

[Hemendra Paregi (OpenERP)]

Hello,

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/http.py",
  line 180, in dispatch
     response["result"] = method(controller, self, **self.params)
   File "/home/hemendra/rdtool/ver-6.1/web/addons/web/controllers/main.py",
  line 1082, in read
     dict(context, group_by=group_by_fields), sort or False)
   File
"/home/hemendra/rdtool/ver-6.1/web/addons/web/common/openerplib/main.py",
  line 250, in proxy
     args, kw)
   File
"/home/hemendra/rdtool/ver-6.1/web/addons/web/common/openerplib/main.py",
  line 117, in proxy
     result = self.connector.send(self.service_name, method, *args)
   File "/home/hemendra/rdtool/ver-6.1/web/addons/web/common/http.py",
line 608, in send
     raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e),
formatted_info)

Server Traceback (most recent call last):
   File "/home/hemendra/rdtool/ver-6.1/web/addons/web/common/http.py",
line 593, in send
     return openerp.netsvc.dispatch_rpc(service_name, method, args)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/netsvc.py", line 360,
  in dispatch_rpc
     result = ExportService.getService(service_name).dispatch(method,
params)
   File
"/home/hemendra/rdtool/ver-6.1/server/openerp/service/web_services.py",
  line 586, in dispatch
     res = fn(db, uid, *params)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/osv/osv.py", 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/osv.py", line 121,
  in wrapper
     return f(self, dbname, *args, **kwargs)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/osv/osv.py", line 176,
  in execute
     res = self.execute_cr(cr, uid, obj, method, *args, **kw)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/osv/osv.py", line
164,
in execute_cr
     return getattr(object, method)(cr, uid, *args, **kw)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/osv/orm.py", line
2557,
  in read_group
     cr.execute('SELECT min(%s.id) AS id, count(%s.id) AS %s_count'
% (self._table, self._table, group_count) + (flist and ',') + flist +
  ' FROM ' + from_clause + where_clause + gb + limit_str + offset_str,
where_clause_params)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/sql_db.py", line
152, in wrapper
     return f(self, *args, **kwargs)
   File "/home/hemendra/rdtool/ver-6.1/server/openerp/sql_db.py", 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.

Thanks

[Naresh(OpenERP) (nch-openerp)]

Hello,

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.

Thanks,
Naresh Soni

Unmerged revisions

6938. By Hemendra Paregi (OpenERP) on 2012-08-08

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

=== modified file 'marketing_campaign/report/campaign_analysis_view.xml'
--- marketing_campaign/report/campaign_analysis_view.xml	2011-11-11 08:43:58 +0000
+++ marketing_campaign/report/campaign_analysis_view.xml	2012-08-08 06:03:25 +0000
@@ -41,7 +41,7 @@
                             string="Month" name="This Month"
                             domain="[('month','=',time.strftime('%%m'))]"/>
                     <filter icon="terp-go-month" string="    Month-1    "
-                            domain="[('create_date','&lt;=', (datetime.date.today() - relativedelta(day=31, months=1)).strftime('%%Y-%%m-%%d')),('create_date','&gt;=',(datetime.date.today() - relativedelta(day=1,months=1)).strftime('%%Y-%%m-%%d'))]"/>
+                            domain="[('date','&lt;=', (datetime.date.today() - relativedelta(day=31, months=1)).strftime('%%Y-%%m-%%d')),('date','&gt;=',(datetime.date.today() - relativedelta(day=1,months=1)).strftime('%%Y-%%m-%%d'))]"/>
 
                     <filter icon="terp-go-today"
                             string="Today"