Hemendra Paregi(Open ERP) has proposed merging
lp:~openerp-dev/openobject-addons/6.1-opw-577769-hpa into
lp:openobject-addons/6.1.
Requested reviews:
Olivier Dony (OpenERP) (odo-openerp)
Naresh(OpenERP) (nch-openerp)
For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/6.1-opw-577769-hpa/+merge/118677
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
--
https://code.launchpad.net/~openerp-dev/openobject-addons/6.1-opw-577769-hpa/+merge/118677
Your team OpenERP R&D Team is subscribed to branch
lp:~openerp-dev/openobject-addons/6.1-opw-577769-hpa.
=== 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','<=', (datetime.date.today() - relativedelta(day=31, months=1)).strftime('%%Y-%%m-%%d')),('create_date','>=',(datetime.date.today() - relativedelta(day=1,months=1)).strftime('%%Y-%%m-%%d'))]"/>
+ domain="[('date','<=', (datetime.date.today() - relativedelta(day=31, months=1)).strftime('%%Y-%%m-%%d')),('date','>=',(datetime.date.today() - relativedelta(day=1,months=1)).strftime('%%Y-%%m-%%d'))]"/>
<filter icon="terp-go-today"
string="Today"
_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help : https://help.launchpad.net/ListHelp
