ProgrammingError: column project_task_history_cumulative.project_id does not exist.

Bug #1022509 reported by DJ Patel (OpenERP)
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Fix Released
Medium
OpenERP Publisher's Warranty Team

Bug Description

Install project.

Go to Reporting -> Project -> Cumulative Flow and click on filter 'My Projects'.

Its gives the following traceback:

Traceback (most recent call last):
  File "/home/mdi/openerp/rdtools/server/trunk/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/mdi/openerp/rdtools/server/trunk/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/mdi/openerp/rdtools/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/mdi/openerp/rdtools/server/trunk/openerp/osv/orm.py", line 2573, 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/mdi/openerp/rdtools/server/trunk/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/home/mdi/openerp/rdtools/server/trunk/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column project_task_history_cumulative.project_id does not exist
LINE 1: ...urs FROM "project_task_history_cumulative" WHERE (project_ta...

Thanks,
Divyesh

Tags: maintenance

Related branches

Amit Parik (amit-parik)
Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 1 (openerp-dev-addons1)
importance: Undecided → Medium
status: New → Confirmed
Changed in openobject-addons:
status: Confirmed → In Progress
Revision history for this message
DJ Patel (OpenERP) (mdi-openerp) wrote :

Hello,

The solution for this bug is proposed in the branch : https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-1022509-mdi/

with following Revision ID and Number.

Revision ID : <email address hidden>
Revision Number : 7007

Thanks,
Divyesh

Changed in openobject-addons:
status: In Progress → Fix Committed
Revision history for this message
Anto (abourguignon) wrote :

Removing a feature is not a bug fix...

A "JOIN" was missing in the init method's psql request. The fix has been released in trunk (revno 7740).

Regards,
Anto.

Changed in openobject-addons:
status: Fix Committed → Won't Fix
status: Won't Fix → Fix Released
Changed in openobject-addons:
assignee: OpenERP R&D Addons Team 1 (openerp-dev-addons1) → OpenERP Publisher's Warranty Team (openerp-opw)
tags: added: maintenance
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.