c2c-oerpscenario team mailing list archive

[debaetsr <703105@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

orm.py, class orm function readgroup line 2167

There are no tablenames added to the fieldname, leading to the following
error when grouping projects by parent


1. Create some analytic accounts with parent/childs
2. Create some projects with parent/childs
3. Try a grouped view by parent.

Environment Information : 
System : Linux-2.6.35-22-generic-i686-with-Ubuntu-10.04-lucid
OS Name : posix
Distributor ID:	Ubuntu
Description:	Ubuntu 10.04.1 LTS
Release:	10.04
Codename:	lucid
Operating System Release : 2.6.35-22-generic
Operating System Version : #34~lucid1-Ubuntu SMP Mon Oct 11 14:36:18 UTC 2010
Operating System Architecture : 32bit
Operating System Locale : nl_BE.UTF8
Python Version : 2.6.5
OpenERP-Client Version : 6.0.0-rc2
Last revision No. & ID :0 null:
Traceback (most recent call last):
  File "/home/ruben/workspace/openerp/trunk/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/ruben/workspace/openerp/trunk/server/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/home/ruben/workspace/openerp/trunk/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/ruben/workspace/openerp/trunk/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/ruben/workspace/openerp/trunk/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/ruben/workspace/openerp/trunk/server/bin/osv/orm.py", line 2182, 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/ruben/workspace/openerp/trunk/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/ruben/workspace/openerp/trunk/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column reference "parent_id" is ambiguous
LINE 1: ... id, count(project_project.id) AS parent_id_count,parent_id,...
                                                             ^

Solution my be to force the tablename to be joined to the fieldname.

Regards,
Ruben

** Affects: openobject-server
     Importance: Undecided
         Status: New

-- 
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/703105

Title:
  [6.0RC2] orm groupby doesn't add tablenames to fields and groupby
  clause

Status in OpenObject Server:
  New

Bug description:
  orm.py, class orm function readgroup line 2167

  There are no tablenames added to the fieldname, leading to the
  following error when grouping projects by parent

  
  1. Create some analytic accounts with parent/childs
  2. Create some projects with parent/childs
  3. Try a grouped view by parent.

  Environment Information : 
  System : Linux-2.6.35-22-generic-i686-with-Ubuntu-10.04-lucid
  OS Name : posix
  Distributor ID:	Ubuntu
  Description:	Ubuntu 10.04.1 LTS
  Release:	10.04
  Codename:	lucid
  Operating System Release : 2.6.35-22-generic
  Operating System Version : #34~lucid1-Ubuntu SMP Mon Oct 11 14:36:18 UTC 2010
  Operating System Architecture : 32bit
  Operating System Locale : nl_BE.UTF8
  Python Version : 2.6.5
  OpenERP-Client Version : 6.0.0-rc2
  Last revision No. & ID :0 null:
  Traceback (most recent call last):
    File "/home/ruben/workspace/openerp/trunk/server/bin/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/home/ruben/workspace/openerp/trunk/server/bin/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/home/ruben/workspace/openerp/trunk/server/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/ruben/workspace/openerp/trunk/server/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/ruben/workspace/openerp/trunk/server/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/ruben/workspace/openerp/trunk/server/bin/osv/orm.py", line 2182, 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/ruben/workspace/openerp/trunk/server/bin/sql_db.py", line 76, in wrapper
      return f(self, *args, **kwargs)
    File "/home/ruben/workspace/openerp/trunk/server/bin/sql_db.py", line 129, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column reference "parent_id" is ambiguous
  LINE 1: ... id, count(project_project.id) AS parent_id_count,parent_id,...
                                                               ^

  Solution my be to force the tablename to be joined to the fieldname.

  Regards,
  Ruben