CybroOdoo / CybroAddons

276 stars 623 forks source link

[v16 CE & v.17 CE] 21720 ERROR odoo17 odoo.sql_db: bad query: #310

Open hetulhh opened 5 months ago

hetulhh commented 5 months ago

Having this error when installing module gym_mgmt_system on odoo v.16 and v.17. Any help?

2024-04-15 12:50:06,675 21720 INFO odoo17 odoo.modules.loading: loading gym_mgmt_system/security/ir.model.access.csv 2024-04-15 12:50:06,743 21720 ERROR odoo17 odoo.sql_db: bad query: INSERT INTO ir_model_data (module,name,model,res_id,noupdate) VALUES ('gym_mgmt_system','access_assign_workout','ir.model.access',669,false), ('gym_mgmt_system','access_assign_workout','ir.model.access',670,false), ('gym_mgmt_system','access_assign_workout_operator','ir.model.access',671,false), ('gym_mgmt_system','access_hr_employee_trainer','ir.model.access',672,false), ('gym_mgmt_system','access_hr_employee_member','ir.model.access',673,false), ('gym_mgmt_system','access_hr_employee_operator','ir.model.access',674,false), ('gym_mgmt_system','access_sale_order_trainer','ir.model.access',675,false), ('gym_mgmt_system','access_sale_order_member','ir.model.access',676,false), ('gym_mgmt_system','access_sale_order_operator','ir.model.access',677,false), ('gym_mgmt_system','access_product_template_trainer','ir.model.access',678,false), ('gym_mgmt_system','access_product_template_member','ir.model.access',679,false), ('gym_mgmt_system','access_product_template_operator','ir.model.access',680,false), ('gym_mgmt_system','access_res_partner_trainer','ir.model.access',681,false), ('gym_mgmt_system','access_res_partner_operator','ir.model.access',682,false), ('gym_mgmt_system','access_res_partner_member','ir.model.access',683,false), ('gym_mgmt_system','access_gym_membership_operator','ir.model.access',684,false), ('gym_mgmt_system','access_gym_membership_trainer','ir.model.access',685,false), ('gym_mgmt_system','access_gym_membership_member','ir.model.access',686,false), ('gym_mgmt_system','access_measurement_history_operator','ir.model.access',687,false), ('gym_mgmt_system','access_measurement_history_trainer','ir.model.access',688,false), ('gym_mgmt_system','access_measurement_history_member','ir.model.access',689,false), ('gym_mgmt_system','access_trainer_skill_operator','ir.model.access',690,false), ('gym_mgmt_system','access_trainer_skill_member','ir.model.access',691,false), ('gym_mgmt_system','access_trainer_skill_trainer','ir.model.access',692,false), ('gym_mgmt_system','access_product_template_trainer','ir.model.access',693,false), ('gym_mgmt_system','access_product_template_member','ir.model.access',694,false), ('gym_mgmt_system','access_product_template_operator','ir.model.access',695,false), ('gym_mgmt_system','access_workout_plan_operator','ir.model.access',696,false), ('gym_mgmt_system','access_workout_plan_trainer','ir.model.access',697,false), ('gym_mgmt_system','access_workout_plan_member','ir.model.access',698,false), ('gym_mgmt_system','access_workout_plan_option_operator','ir.model.access',699,false), ('gym_mgmt_system','access_workout_plan_option_trainer','ir.model.access',700,false), ('gym_mgmt_system','access_workout_plan_option_member','ir.model.access',701,false), ('gym_mgmt_system','access_workout_days_operator','ir.model.access',702,false), ('gym_mgmt_system','access_workout_days_trainer','ir.model.access',703,false), ('gym_mgmt_system','access_workout_days_member','ir.model.access',704,false), ('gym_mgmt_system','access_gym_exercise_operator','ir.model.access',705,false), ('gym_mgmt_system','access_gym_exercise_trainer','ir.model.access',706,false), ('gym_mgmt_system','access_gym_exercise_member','ir.model.access',707,false), ('gym_mgmt_system','access_exercise_for_operator','ir.model.access',708,false), ('gym_mgmt_system','access_exercise_for_trainer','ir.model.access',709,false), ('gym_mgmt_system','access_exercise_for_member','ir.model.access',710,false), ('gym_mgmt_system','access_trainer_skill_operator','ir.model.access',711,false), ('gym_mgmt_system','access_trainer_skill_trainer','ir.model.access',712,false), ('gym_mgmt_system','access_trainer_skill_member','ir.model.access',713,false), ('gym_mgmt_system','access_my_workout_plan_operator','ir.model.access',714,false), ('gym_mgmt_system','access_my_workout_plan_trainer','ir.model.access',715,false), ('gym_mgmt_system','access_my_workout_plan_member','ir.model.access',716,false) ON CONFLICT (module, name) DO UPDATE SET (model, res_id, write_date) = (EXCLUDED.model, EXCLUDED.res_id, now() at time zone 'UTC') WHERE (ir_model_data.res_id != EXCLUDED.res_id OR ir_model_data.model != EXCLUDED.model) RETURNING module, name, model, res_id, create_date, write_date

ERROR: ON CONFLICT DO UPDATE command cannot affect row a second time HINT: Ensure that no rows proposed for insertion within the same command have duplicate constrained values.

2024-04-15 12:50:06,744 21720 ERROR odoo17 odoo.addons.base.models.ir_model: Failed to insert ir_model_data ('gym_mgmt_system', 'access_assign_workout', 'ir.model.access', 669, False) ('gym_mgmt_system', 'access_assign_workout', 'ir.model.access', 670, False) ('gym_mgmt_system', 'access_assign_workout_operator', 'ir.model.access', 671, False) ('gym_mgmt_system', 'access_hr_employee_trainer', 'ir.model.access', 672, False) ('gym_mgmt_system', 'access_hr_employee_member', 'ir.model.access', 673, False) ('gym_mgmt_system', 'access_hr_employee_operator', 'ir.model.access', 674, False) ('gym_mgmt_system', 'access_sale_order_trainer', 'ir.model.access', 675, False) ('gym_mgmt_system', 'access_sale_order_member', 'ir.model.access', 676, False) ('gym_mgmt_system', 'access_sale_order_operator', 'ir.model.access', 677, False) ('gym_mgmt_system', 'access_product_template_trainer', 'ir.model.access', 678, False) ('gym_mgmt_system', 'access_product_template_member', 'ir.model.access', 679, False) ('gym_mgmt_system', 'access_product_template_operator', 'ir.model.access', 680, False) ('gym_mgmt_system', 'access_res_partner_trainer', 'ir.model.access', 681, False) ('gym_mgmt_system', 'access_res_partner_operator', 'ir.model.access', 682, False) ('gym_mgmt_system', 'access_res_partner_member', 'ir.model.access', 683, False) ('gym_mgmt_system', 'access_gym_membership_operator', 'ir.model.access', 684, False) ('gym_mgmt_system', 'access_gym_membership_trainer', 'ir.model.access', 685, False) ('gym_mgmt_system', 'access_gym_membership_member', 'ir.model.access', 686, False) ('gym_mgmt_system', 'access_measurement_history_operator', 'ir.model.access', 687, False) ('gym_mgmt_system', 'access_measurement_history_trainer', 'ir.model.access', 688, False) ('gym_mgmt_system', 'access_measurement_history_member', 'ir.model.access', 689, False) ('gym_mgmt_system', 'access_trainer_skill_operator', 'ir.model.access', 690, False) ('gym_mgmt_system', 'access_trainer_skill_member', 'ir.model.access', 691, False) ('gym_mgmt_system', 'access_trainer_skill_trainer', 'ir.model.access', 692, False) ('gym_mgmt_system', 'access_product_template_trainer', 'ir.model.access', 693, False) ('gym_mgmt_system', 'access_product_template_member', 'ir.model.access', 694, False) ('gym_mgmt_system', 'access_product_template_operator', 'ir.model.access', 695, False) ('gym_mgmt_system', 'access_workout_plan_operator', 'ir.model.access', 696, False) ('gym_mgmt_system', 'access_workout_plan_trainer', 'ir.model.access', 697, False) ('gym_mgmt_system', 'access_workout_plan_member', 'ir.model.access', 698, False) ('gym_mgmt_system', 'access_workout_plan_option_operator', 'ir.model.access', 699, False) ('gym_mgmt_system', 'access_workout_plan_option_trainer', 'ir.model.access', 700, False) ('gym_mgmt_system', 'access_workout_plan_option_member', 'ir.model.access', 701, False) ('gym_mgmt_system', 'access_workout_days_operator', 'ir.model.access', 702, False) ('gym_mgmt_system', 'access_workout_days_trainer', 'ir.model.access', 703, False) ('gym_mgmt_system', 'access_workout_days_member', 'ir.model.access', 704, False) ('gym_mgmt_system', 'access_gym_exercise_operator', 'ir.model.access', 705, False) ('gym_mgmt_system', 'access_gym_exercise_trainer', 'ir.model.access', 706, False) ('gym_mgmt_system', 'access_gym_exercise_member', 'ir.model.access', 707, False) ('gym_mgmt_system', 'access_exercise_for_operator', 'ir.model.access', 708, False) ('gym_mgmt_system', 'access_exercise_for_trainer', 'ir.model.access', 709, False) ('gym_mgmt_system', 'access_exercise_for_member', 'ir.model.access', 710, False) ('gym_mgmt_system', 'access_trainer_skill_operator', 'ir.model.access', 711, False) ('gym_mgmt_system', 'access_trainer_skill_trainer', 'ir.model.access', 712, False) ('gym_mgmt_system', 'access_trainer_skill_member', 'ir.model.access', 713, False) ('gym_mgmt_system', 'access_my_workout_plan_operator', 'ir.model.access', 714, False) ('gym_mgmt_system', 'access_my_workout_plan_trainer', 'ir.model.access', 715, False) ('gym_mgmt_system', 'access_my_workout_plan_member', 'ir.model.access', 716, False)