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 _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
