Analytic Chart of Accounts not displaying

Hi

We have the same problem.

My guess is that in the file: /usr/lib/python2.5/site-packages/openerp-server/addons/account/project/project.py, @ line 117-120, one can read:
        cr.execute("SELECT a.id, r.currency_id "
                   "FROM account_analytic_account a "
                   "INNER JOIN res_company r ON (a.company_id = r.id) "
                   "WHERE a.id in %s", (tuple(ids),))

My proposition is that the query should use "tuple(ids2)" instead of "tuple(ids)", because "ids2" contains the children of "ids"

Hi,
I have the same problem.
But I don't understand what can I do to resolve this problem.
Can you help me Jay?

Hello Marco,

You need to update the code from Launchpad : https://code.launchpad.net/~openerp/openobject-addons/5.0

Else, apply the patch from here : http://bazaar.launchpad.net/~openerp/openobject-addons/5.0/revision/2752

Hope this helps.

Thanks.

Thank you Jay,
To update the code from launchpad, I have to update all single module that I have installed into my installation?
And to apply patch, I have to substitute account/project/project.py in my installed module with the patched ones?

Thank you again

Hi Marco,

You may simply replace the whole file from http://bazaar.launchpad.net/~openerp/openobject-addons/5.0/annotate/head:/account/project/project.py.

Else, Look at the link http://bazaar.launchpad.net/~openerp/openobject-addons/5.0/revision/2752; you can change the 2 lines and you will get it working.

Thanks.

Ok, thank you very much. It works!!!
Thanks.

Thanks Jay fo the fast response yesterday. I copied the project.py code into my own project.py code. Yesterday everything worked fine.
But today, after restarting I guess, I get an error, telling me the project task does not exist.
I tried my old databases and created a new one, both are not working. The error:

Environment Information :
System : Linux-2.6.32-22-generic-x86_64-with-Ubuntu-10.04-lucid
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 10.04 LTS
Release: 10.04
Codename: lucid
Operating System Release : 2.6.32-22-generic
Operating System Version : #36-Ubuntu SMP Thu Jun 3 19:31:57 UTC 2010
Operating System Architecture : 64bit
Operating System Locale : en_US.UTF8
Python Version : 2.6.5
OpenERP-Client Version : 5.0.11
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/home/openerp/OpenERP/5.0/server/bin/netsvc.py", line 247, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/home/openerp/OpenERP/5.0/server/bin/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/home/openerp/OpenERP/5.0/server/bin/service/web_services.py", line 633, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File "/home/openerp/OpenERP/5.0/server/bin/service/web_services.py", line 613, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File "/home/openerp/OpenERP/5.0/server/bin/wizard/__init__.py", line 178, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File "/home/openerp/OpenERP/5.0/server/bin/wizard/__init__.py", line 73, in execute_cr
    action_res = action(self, cr, uid, data, context)
  File "/home/openerp/OpenERP/5.0/server/bin/addons/base_setup/wizard/wizard_base_setup.py", line 208, in _update
    (db, pool)=pooler.restart_pool(cr.dbname, update_module=True)
  File "/home/openerp/OpenERP/5.0/server/bin/pooler.py", line 62, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/home/openerp/OpenERP/5.0/server/bin/pooler.py", line 40, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/home/openerp/OpenERP/5.0/server/bin/addons/__init__.py", line 741, in load_modules
    r = load_module_graph(cr, graph, status, report=report)
  File "/home/openerp/OpenERP/5.0/server/bin/addons/__init__.py", line 584, in load_module_graph
    init_module_objects(cr, package.name, modules)
  File "/home/openerp/OpenERP/5.0/server/bin/addons/__init__.py", line 373, in init_module_objects
    obj.init(cr)
  File "/home/openerp/OpenERP/5.0/server/bin/addons/report_task/report_task.py", line 59, in init
    ''')
  File "/home/openerp/OpenERP/5.0/server/bin/sql_db.py", line 77, in wrapper
    return f(self, *args, **kwargs)
  File "/home/openerp/OpenERP/5.0/server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: relation "project_task" does not exist
LINE 14: project_task t on (u.id = t.user_id)
                             ^

Hannes

Hi Hannes,

I fear that you copied a wrong file.
Please follow comment #5 on this thread.

The file is account/project/project.py , not project/project.py.

Thanks.

Ah.. Thanks Jay!