Actions
Defect #11099
closedSQL-query error when I'm execute "assigned_to_role" filter
Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:
0%
Estimated time:
Resolution:
Invalid
Affected version:
Description
SQL-query error when I'm execute "assigned_to_role" filter
In log file:
Started GET "/projects/redmine/issues?utf8=%E2%9C%93&set_filter=1&f%5B%5D=assigned_to_role&op%5Bassigned_to_role%5D=%3D&v%5Bassigned_to_role%5D%5B%5D=4&f%5B%5D=&c%5B%5D=tracker&c%5B%5D=status&c%5B%5D=priority&c%5B%5D=subject&c%5B%5D=author&c%5B%5D=assigned_to&c%5B%5D=category&c%5B%5D=due_date&c%5B%5D=cf_11&group_by=" for 192.168.3.63 at 2012-06-06 17:43:45 +1100 Processing by IssuesController#index as HTML Parameters: {"utf8"=>"✓", "set_filter"=>"1", "f"=>["assigned_to_role", ""], "op"=>{"assigned_to_role"=>"="}, "v"=>{"assigned_to_role"=>["4"]}, "c"=>["tracker", "status", "priority", "subject", "author", "assigned_to", "category", "due_date", "cf_11"], "group_by"=>"", "project_id"=>"redmine"} [1m[35m (0.2ms)[0m SELECT MAX(`settings`.`updated_on`) AS max_id FROM `settings` [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 10 AND (users.status = 1) LIMIT 1[0m [1m[35mProject Load (0.3ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`identifier` = 'redmine' LIMIT 1 [1m[36mEnabledModule Load (0.1ms)[0m [1mSELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 7[0m [1m[35mTracker Load (0.2ms)[0m SELECT DISTINCT trackers.* FROM `trackers` INNER JOIN `projects_trackers` ON `projects_trackers`.`tracker_id` = `trackers`.`id` INNER JOIN `projects` ON `projects`.`id` = `projects_trackers`.`project_id` WHERE (projects.lft >= 26 AND projects.rgt <= 27 AND projects.status = 1) ORDER BY trackers.position [1m[36mIssueStatus Load (0.2ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` ORDER BY position[0m [1m[35mIssuePriority Load (0.2ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') ORDER BY enumerations.position ASC [1m[36mPrincipal Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.`id` = `members`.`user_id` WHERE `members`.`project_id` = 7 AND (users.type='Group' OR (users.type='User' AND users.status=1))[0m [1m[35mGroup Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('Group') [1m[36mRole Load (0.4ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE (builtin = 0) ORDER BY position[0m [1m[35mIssueCategory Load (0.2ms)[0m SELECT `issue_categories`.* FROM `issue_categories` WHERE `issue_categories`.`project_id` = 7 ORDER BY issue_categories.name [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`parent_id` IS NULL AND (`projects`.`lft` <= 26 AND `projects`.`rgt` >= 27) ORDER BY `projects`.`lft` LIMIT 1[0m [1m[35mSQL (0.3ms)[0m SELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2, `versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5, `versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `versions`.`status` AS t0_r8, `versions`.`sharing` AS t0_r9, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `projects`.`dmsf_description` AS t1_r12 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.`id` = `versions`.`project_id` WHERE (projects.id = 7 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 28 AND versions.sharing = 'tree') OR (projects.lft < 26 AND projects.rgt > 27 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 26 AND projects.rgt < 27 AND versions.sharing = 'hierarchy')))) [1m[36mIssueCustomField Load (0.3ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position[0m [1m[35mIssueCustomField Load (0.2ms)[0m SELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.`id` = `custom_fields_projects`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_projects`.`project_id` = 7 ORDER BY custom_fields.position [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.`id` = `members`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `members`.`project_id` = 7 AND (users.type='User' AND users.status=1)[0m [1m[35mMilestone Load (0.2ms)[0m SELECT `milestones`.* FROM `milestones` WHERE `milestones`.`project_id` = 7 [1m[36mCACHE (0.0ms)[0m [1mSELECT `milestones`.* FROM `milestones` WHERE `milestones`.`project_id` = 7[0m [1m[35mCACHE (0.0ms)[0m SELECT `milestones`.* FROM `milestones` WHERE `milestones`.`project_id` = 7 [1m[36mCACHE (0.0ms)[0m [1mSELECT `milestones`.* FROM `milestones` WHERE `milestones`.`project_id` = 7[0m [1m[35mCACHE (0.0ms)[0m SELECT `milestones`.* FROM `milestones` WHERE `milestones`.`project_id` = 7 [1m[36mCACHE (0.0ms)[0m [1mSELECT `milestones`.* FROM `milestones` WHERE `milestones`.`project_id` = 7[0m [1m[35mCACHE (0.0ms)[0m SELECT `milestones`.* FROM `milestones` WHERE `milestones`.`project_id` = 7 [1m[36m (0.2ms)[0m [1mSELECT COUNT(*) FROM `projects` WHERE (`projects`.`lft` >= 26 AND `projects`.`rgt` <= 27) AND (`projects`.id != 7) AND (projects.status = 1)[0m [1m[35m (1.0ms)[0m SELECT COUNT(DISTINCT `issues`.`id`) FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (( issues.assigned_to_id IN (SELECT DISTINCT 10mbers.user_id FROM members, member_roles WHERE members.project_id = issues.project_id AND members.id = member_roles.member_id AND member_roles.role_id IN ('4'))) AND projects.id = 7) Mysql2::Error: Unknown column '10mbers.user_id' in 'field list': SELECT COUNT(DISTINCT `issues`.`id`) FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (( issues.assigned_to_id IN (SELECT DISTINCT 10mbers.user_id FROM members, member_roles WHERE members.project_id = issues.project_id AND members.id = member_roles.member_id AND member_roles.role_id IN ('4'))) AND projects.id = 7) Query::StatementInvalid: Mysql2::Error: Unknown column '10mbers.user_id' in 'field list': SELECT COUNT(DISTINCT `issues`.`id`) FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (( issues.assigned_to_id IN (SELECT DISTINCT 10mbers.user_id FROM members, member_roles WHERE members.project_id = issues.project_id AND members.id = member_roles.member_id AND member_roles.role_id IN ('4'))) AND projects.id = 7) Rendered common/error.html.erb within layouts/base (0.3ms) [1m[36mUserPreference Load (0.3ms)[0m [1mSELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 10 LIMIT 1[0m Rendered plugins/advanced_roadmap/app/views/hooks/_html_head.erb (0.1ms) Rendered plugins/categories_as_tags/app/views/hooks/categories_as_tags/_html_head.html.erb (1.4ms) [1m[35mSQL (0.3ms)[0m SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `members`.`dmsf_mail_notification` AS t0_r5, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `projects`.`dmsf_description` AS t1_r12, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5, `roles`.`issues_visibility` AS t2_r6 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.`id` = `members`.`project_id` LEFT OUTER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`user_id` = 10 AND (projects.status=1) ORDER BY projects.name [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (`projects`.`lft` <= 26 AND `projects`.`rgt` >= 27) AND (`projects`.id != 7) AND (projects.status=1) ORDER BY `projects`.`lft`[0m [1m[35mWiki Load (0.0ms)[0m SELECT `wikis`.* FROM `wikis` WHERE `wikis`.`project_id` = 7 LIMIT 1 [1m[36m (0.2ms)[0m [1mSELECT COUNT(*) FROM `boards` WHERE `boards`.`project_id` = 7[0m [1m[35mRepository Load (0.3ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`project_id` = 7 AND (is_default = 1) LIMIT 1 Completed 500 Internal Server Error in 289ms (Views: 194.0ms | ActiveRecord: 6.9ms)
Updated by Vladimir Pitin about 12 years ago
For some reason a table "10mbers" is used instead of a table "members".
Updated by Vladimir Pitin about 12 years ago
- Status changed from New to Resolved
Updated by Etienne Massip about 12 years ago
- Status changed from Resolved to Closed
- Resolution set to Invalid
Actions