Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Project_timeline - DuplicateColumn planned_date_end #1433

Open
HugoCLU opened this issue Feb 10, 2025 · 0 comments
Open

Project_timeline - DuplicateColumn planned_date_end #1433

HugoCLU opened this issue Feb 10, 2025 · 0 comments
Labels

Comments

@HugoCLU
Copy link

HugoCLU commented Feb 10, 2025

On 16.0, I have this issue when I make a build (below) each time I tried to update my branch.

Module

project_timeline

Describe the bug

bad query:
CREATE view report_project_task_user as
SELECT
(select 1) AS nbr,
t.id as id,
t.id as task_id,
t.active,
t.create_date as create_date,
t.date_assign as date_assign,
t.date_end as date_end,
t.date_last_stage_update as date_last_stage_update,
t.date_deadline as date_deadline,
t.project_id,
t.priority,
t.name as name,
t.company_id,
t.partner_id,
t.parent_id as parent_id,
t.ancestor_id as ancestor_id,
t.stage_id as stage_id,
t.is_closed as is_closed,
t.kanban_state as state,
t.milestone_id,
pm.is_reached as milestone_reached,
pm.deadline as milestone_deadline,
NULLIF(t.rating_last_value, 0) as rating_last_value,
AVG(rt.rating) as rating_avg,
t.working_days_close as working_days_close,
t.working_days_open as working_days_open,
t.working_hours_open as working_hours_open,
t.working_hours_close as working_hours_close,
(extract('epoch' from (t.date_deadline-(now() at time zone 'UTC'))))/(3600*24) as delay_endings_days
,
(t.effective_hours * 100) / NULLIF(t.planned_hours, 0) as progress,
t.effective_hours as hours_effective,
t.planned_hours - t.effective_hours - t.subtask_effective_hours as remaining_hours,
NULLIF(t.planned_hours, 0) as hours_planned,
t.overtime as overtime
,
t.planned_date_begin as planned_date_begin,
t.planned_date_end as planned_date_end
,
t.planned_date_start,
t.planned_date_end
FROM
project_task t
LEFT JOIN rating_rating rt ON rt.res_id = t.id
AND rt.res_model = 'project.task'
AND rt.consumed = True
AND rt.rating >= 1
LEFT JOIN project_milestone pm ON pm.id = t.milestone_id

      WHERE 
            t.project_id IS NOT NULL
    
   GROUP BY 
            t.id,
            t.active,
            t.create_date,
            t.date_assign,
            t.date_end,
            t.date_last_stage_update,
            t.date_deadline,
            t.project_id,
            t.ancestor_id,
            t.priority,
            t.name,
            t.company_id,
            t.partner_id,
            t.parent_id,
            t.stage_id,
            t.is_closed,
            t.kanban_state,
            t.rating_last_value,
            t.working_days_close,
            t.working_days_open,
            t.working_hours_open,
            t.working_hours_close,
            t.milestone_id,
            pm.is_reached,
            pm.deadline
    ,
            t.effective_hours,
            t.subtask_effective_hours,
            t.planned_hours,
            t.overtime
    ,
        t.planned_date_begin,
        t.planned_date_end
    ,
        t.planned_date_start,
        t.planned_date_end

ERROR: column "planned_date_end" specified more than once

Failed to load registry
Traceback (most recent call last):
File "/home/odoo/src/odoo/odoo/modules/registry.py", line 87, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/home/odoo/src/odoo/odoo/modules/loading.py", line 485, in load_modules
processed_modules += load_marked_modules(cr, graph,
File "/home/odoo/src/odoo/odoo/modules/loading.py", line 373, in load_marked_modules
loaded, processed = load_module_graph(
File "/home/odoo/src/odoo/odoo/modules/loading.py", line 209, in load_module_graph
registry.init_models(cr, model_names, {'module': package.name}, new_install)
File "/home/odoo/src/odoo/odoo/modules/registry.py", line 527, in init_models
model.init()
File "/home/odoo/src/odoo/addons/project/report/project_report.py", line 148, in init
self._cr.execute("""
File "/home/odoo/src/odoo/odoo/sql_db.py", line 321, in execute
res = self._obj.execute(query, params)
psycopg2.errors.DuplicateColumn: column "planned_date_end" specified more than once

To Reproduce

Steps to reproduce the behavior:
I think it's specific to my DB but I'm not sure. I updated all my submodules and this happened.

Expected behavior
It's suppose to update the module whithout any issue and build my branch.

@HugoCLU HugoCLU added the bug label Feb 10, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant