← Back to team overview

openerp-india team mailing list archive

[Bug 1217707] Re: accounts pagination bug

 

Hello Chris! I found where was the problem! I comment here in case it
may helps somebody else.

I found that parent_left and parent_right column in account_account
table were populated with wrong values which were not reflecting
correctly my accounts structure, so also some reports (like Balance
Sheet) were wrongly formatted (with some accounts belonging to wrong
parents).

I fixed it with:
alter table account_account drop parent_left;
alter table account_account drop parent_right;
and restart the server with –update=account on the same db

Now everything is working fine.

Tip: I don't know why parent_left and parent_right were containing wrong
values, could be a OpenERP error when adding new accounts?

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1217707

Title:
  accounts pagination bug

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  When you have many accounts so that a child account belongs to the
  next page where the parent account is currently showed you get a
  KeyError:

  [code]
  Client Traceback (most recent call last):
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\openerp\addons\web\http.py", line 204, in dispatch
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\openerp\addons\web\controllers\main.py", line 1054, in search_read
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\openerp\addons\web\controllers\main.py", line 1089, in do_search_read
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\openerp\addons\web\session.py", line 42, in proxy
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\openerp\addons\web\session.py", line 30, in proxy_method
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\openerp\addons\web\session.py", line 103, in send

  
  Server Traceback (most recent call last):
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\openerp\addons\web\session.py", line 89, in send
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\.\openerp\netsvc.py", line 292, in dispatch_rpc
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\.\openerp\service\web_services.py", line 626, in dispatch
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\.\openerp\osv\osv.py", line 188, in execute_kw
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\.\openerp\osv\osv.py", line 131, in wrapper
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\.\openerp\osv\osv.py", line 197, in execute
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\.\openerp\osv\osv.py", line 185, in execute_cr
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\.\openerp\osv\orm.py", line 3606, in read
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\.\openerp\osv\orm.py", line 3714, in _read_flat
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\.\openerp\osv\fields.py", line 1133, in get
    File "C:\Program Files (x86)\OpenERP 7.0-20130825-231127\Server\server\openerp\addons\account\account.py", line 348, in __compute
  KeyError: 401
  [/code]

  Steps to reproduce:
  insert more then 80 accounts
  set the 80+1 account as child of a smaller-code account
  load the first page (1 - 80) of accounts

  Result expected:
  no error

  Browser:
  Google Chrome 29.0.1547.57 m

  OpenERP version:
  OpenERP 7.0-20130825-231127

  OS:
  Win7

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1217707/+subscriptions