c2c-oerpscenario team mailing list archive

["Ashvin Rathod \(OpenERP\)" <705739@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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...

** Affects: openobject-addons
     Importance: Low
     Assignee: OpenERP R&D Addons Team 3 (openerp-dev-addons3)
         Status: Confirmed

-- 
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...