c2c-oerpscenario team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

Hello Ashvin Rathod,

Thanks for the reporting, and i am confirming this bug.

Thanks again.

** Changed in: openobject-addons
   Importance: Undecided => Low

** Changed in: openobject-addons
       Status: New => Confirmed

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)

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

Title:
  [Trunk] account: Group by doesn't work on Journal items

Status in OpenERP Modules (addons):
  Confirmed

Bug description:
  Accounting>journal items> Press F2 on 'account' field of editable tree
  view

  I am getting new form then press any group by button give the
  following traceback

  [2011-01-21 10:53:53,768][test] ERROR:db.cursor:Programming error: column account_account.journal_id does not exist
  LINE 1: ...nt" WHERE (account_account.active = E'True') AND (account_ac...
                                                               ^
  , in query SELECT min(account_account.id) AS id, count(account_account.id) AS parent_id_count,"account_account".parent_id FROM "account_account" WHERE (account_account.active = %s) AND (account_account.journal_id = '2') AND (account_account.type <> %s) AND (account_account.type <> %s) GROUP BY "account_account".parent_id
  [2011-01-21 10:53:53,768][test] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/home/ara/workspace/trunk/openobject-server/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/ara/workspace/trunk/openobject-server/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/ara/workspace/trunk/openobject-server/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/ara/workspace/trunk/openobject-server/bin/osv/orm.py", line 2186, 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/ara/workspace/trunk/openobject-server/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/home/ara/workspace/trunk/openobject-server/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column account_account.journal_id does not exist
  LINE 1: ...nt" WHERE (account_account.active = E'True') AND (account_ac...