Comment 2 for bug 700470

Revision history for this message
xrg (xrg) wrote : Re: [Bug 700470] [NEW] [V6 rc2] Can't display project structure

On Sunday 09 January 2011, you wrote:
> You have been subscribed to a public bug:
>
> hello,
>
> Try to display the project structure (projects grouped by parent)
> ProgrammingError: column reference "parent_id" is ambiguous
> LINE 1: ... id, count(project_project.id) AS parent_id_count,parent_id,...
> ^

Is that a new db? against which addons revision was it created/last updated?

Because, at a recent patch, the "project.project.parent_id" column has been
removed, in favor of the "account.analytic.account.parent_id" column.
So, if your db still has the "project.parent_id" column, it may make that
mistake.

Please, do NOT drop the column, if you want to experiment anything, just
rename it!