Read_group() needs correction on query,

Bug #692259 reported by Jay Vora (Serpent Consulting Services)
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Server (MOVED TO GITHUB)
Fix Released
Low
OpenERP's Framework R&D

Bug Description

Install Accounting modules.
Go to Sales/Address Book /customers.

Click on (act_window) monthly turn over(which is a PSQL report).
Click on 'Events' or 'Related docs'(if knowledge is installed) afterwards.

Traceback:

Traceback (most recent call last):
  File "/home/jvo/workspace/trunk/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/jvo/workspace/trunk/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/jvo/workspace/trunk/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/jvo/workspace/trunk/server/bin/osv/orm.py", line 2325, in read_group
    cr.execute('SELECT min(%s.id) AS id, count(%s.id) AS %s_count, ' % (self._table, self._table, group_count) + flist + ' FROM ' + from_clause + where_clause + gb + limit_str + offset_str, where_clause_params)
  File "/home/jvo/workspace/trunk/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/jvo/workspace/trunk/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: syntax error at or near "FROM"
LINE 1: ... AS id, count(res_partner_event.id) AS __count, FROM "res_...

The problem is with ',' just after __count.

Related branches

Changed in openobject-server:
status: New → Confirmed
importance: Undecided → Low
assignee: nobody → OpenERP's Framework R&D (openerp-dev-framework)
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

Fix landed in revision 3134 <email address hidden>
Thanks for reporting!

Changed in openobject-server:
milestone: none → 6.0-rc2
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.