search

jcppkkk / redmine_mail_reminder

Plugin for Redmine to create different role based reminders for project(s)
52 stars 32 forks source link

MYSLQ2 ERROR when execute in [test] mode #122

Open jlsblasco opened 3 years ago

jlsblasco commented 3 years ago

I configure the querys ok, but the mail don't send. I execute rake in [test] mode and generate a sql problem: ActiveRecord::StatementInvalid: Mysql2::Error: Not unique table/alias: 'trackers': SELECT issues.id AS t0_r0, issues.tracker_id AS t0_r1, issues.project_id AS t0_r2, issues.subject AS t0_r3, issues.description AS t0_r4, issues.due_date AS t0_r5, issues.category_id AS t0_r6, issues.status_id AS t0_r7, issues.assigned_to_id AS t0_r8, issues.priority_id AS t0_r9, issues.fixed_version_id AS t0_r10, issues.author_id AS t0_r11, issues.lock_version AS t0_r12, issues.created_on AS t0_r13, issues.updated_on AS t0_r14, issues.start_date AS t0_r15, issues.done_ratio AS t0_r16, issues.estimated_hours AS t0_r17, issues.parent_id AS t0_r18, issues.root_id AS t0_r19, issues.lft AS t0_r20, issues.rgt AS t0_r21, issues.is_private AS t0_r22, issues.closed_on AS t0_r23, issues.reminder_notification AS t0_r24, issue_statuses.id AS t1_r0, issue_statuses.name AS t1_r1, issue_statuses.is_closed AS t1_r2, issue_statuses.position AS t1_r3, issue_statuses.default_done_ratio AS t1_r4, projects.id AS t2_r0, projects.name AS t2_r1, projects.description AS t2_r2, projects.homepage AS t2_r3, projects.is_public AS t2_r4, projects.parent_id AS t2_r5, projects.created_on AS t2_r6, projects.updated_on AS t2_r7, projects.identifier AS t2_r8, projects.status AS t2_r9, projects.lft AS t2_r10, projects.rgt AS t2_r11, projects.inherit_members AS t2_r12, projects.default_version_id AS t2_r13, projects.default_assigned_to_id AS t2_r14, users.id AS t3_r0, users.login AS t3_r1, users.hashed_password AS t3_r2, users.firstname AS t3_r3, users.lastname AS t3_r4, users.admin AS t3_r5, users.status AS t3_r6, users.last_login_on AS t3_r7, users.language AS t3_r8, users.auth_source_id AS t3_r9, users.created_on AS t3_r10, users.updated_on AS t3_r11, users.type AS t3_r12, users.identity_url AS t3_r13, users.mail_notification AS t3_r14, users.salt AS t3_r15, users.must_change_passwd AS t3_r16, users.passwd_changed_on AS t3_r17, users.reminder_notification AS t3_r18, trackers.id AS t4_r0, trackers.name AS t4_r1, trackers.is_in_chlog AS t4_r2, trackers.position AS t4_r3, trackers.is_in_roadmap AS t4_r4, trackers.fields_bits AS t4_r5, trackers.default_status_id AS t4_r6, enumerations.id AS t5_r0, enumerations.name AS t5_r1, enumerations.position AS t5_r2, enumerations.is_default AS t5_r3, enumerations.type AS t5_r4, enumerations.active AS t5_r5, enumerations.project_id AS t5_r6, enumerations.parent_id AS t5_r7, enumerations.position_name AS t5_r8, issue_categories.id AS t6_r0, issue_categories.project_id AS t6_r1, issue_categories.name AS t6_r2, issue_categories.assigned_to_id AS t6_r3, issue_categories.reminder_notification AS t6_r4, versions.id AS t7_r0, versions.project_id AS t7_r1, versions.name AS t7_r2, versions.description AS t7_r3, versions.effective_date AS t7_r4, versions.created_on AS t7_r5, versions.updated_on AS t7_r6, versions.wiki_page_title AS t7_r7, versions.status AS t7_r8, versions.sharing AS t7_r9 FROM issues INNER JOIN projects ON projects.id = issues.project_id INNER JOIN issue_statuses ON issue_statuses.id = issues.status_id LEFT OUTER JOIN users ON users.id = issues.assigned_to_id LEFT OUTER JOIN trackers ON trackers.id = issues.tracker_id LEFT OUTER JOIN enumerations ON enumerations.id = issues.priority_id AND enumerations.type IN ('IssuePriority') LEFT OUTER JOIN issue_categories ON issue_categories.id = issues.category_id LEFT OUTER JOIN versions ON versions.id = issues.fixed_version_id LEFT OUTER JOIN trackers ON trackers.id = issues.tracker_id WHERE (((projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND ((projects.id IN (149,274,372) AND (1=1))))) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=0)) AND (issues.project_id IN ('274')) AND projects.id = 274) ORDER BY trackers.position ASC, issues.id DESC

Execute in mysql the query and receive the same error.

Which its the problem? Regards

kevinfosterNG commented 3 years ago

There's 2 joins to the trackers table in that query.