|
1
|
Started GET "/projects/ecookbook/issues" for 127.0.0.1 at 2021-04-05 18:49:11 +0900
|
|
2
|
Processing by IssuesController#index as HTML
|
|
3
|
Parameters: {"project_id"=>"ecookbook"}
|
|
4
|
Token Update All (2.2ms) UPDATE "tokens" SET "updated_on" = ? WHERE "tokens"."user_id" = ? AND "tokens"."value" = ? AND "tokens"."action" = ? [["updated_on", "2021-04-05 18:49:11.950972"], ["user_id", 1], ["value", "6c06c7146d6b8fe3a020a7b2c59996e2c9f38e5d"], ["action", "session"]]
|
|
5
|
(0.3ms) SELECT MAX("settings"."updated_on") FROM "settings"
|
|
6
|
User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."type" IN (?, ?) AND "users"."status" = ? AND "users"."id" = ? LIMIT ? [[nil, "User"], [nil, "AnonymousUser"], ["status", 1], ["id", 1], ["LIMIT", 1]]
|
|
7
|
Current user: admin (id=1)
|
|
8
|
FilterRule Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT ? [["name", "plugin_redmine_ip_filter"], ["LIMIT", 1]]
|
|
9
|
Project Load (0.2ms) SELECT "projects".* FROM "projects" WHERE "projects"."identifier" = ? LIMIT ? [["identifier", "ecookbook"], ["LIMIT", 1]]
|
|
10
|
(0.3ms) SELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = ? [["project_id", 1]]
|
|
11
|
Tracker Load (0.7ms) 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" INNER JOIN "enabled_modules" ON "enabled_modules"."project_id" = "projects"."id" WHERE (projects.status <> 9) AND "enabled_modules"."name" = ? AND (projects.lft >= 1 AND projects.rgt <= 10) AND (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) ORDER BY "trackers"."position" ASC [["name", "issue_tracking"]]
|
|
12
|
IssuePriority Load (0.6ms) SELECT "enumerations".* FROM "enumerations" WHERE "enumerations"."type" = ? ORDER BY "enumerations"."position" ASC [["type", "IssuePriority"]]
|
|
13
|
IssueCustomField Load (1.4ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" = ? AND (is_for_all = 1 OR EXISTS (SELECT 1 FROM custom_fields_projects cfp JOIN projects p ON p.id = cfp.project_id WHERE cfp.custom_field_id = custom_fields.id AND p.lft >= 1 AND p.rgt <= 10)) AND "custom_fields"."is_filter" = ? ORDER BY "custom_fields"."position" ASC [["type", "IssueCustomField"], ["is_filter", 1]]
|
|
14
|
CustomField Load (0.6ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."is_filter" = ? [["is_filter", 1]]
|
|
15
|
IssueCustomField Load (0.6ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" = ? AND (is_for_all = 1 OR EXISTS (SELECT 1 FROM custom_fields_projects cfp JOIN projects p ON p.id = cfp.project_id WHERE cfp.custom_field_id = custom_fields.id AND p.lft >= 1 AND p.rgt <= 10)) ORDER BY "custom_fields"."position" ASC [["type", "IssueCustomField"]]
|
|
16
|
UserPreference Load (0.2ms) SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = ? LIMIT ? [["user_id", 1], ["LIMIT", 1]]
|
|
17
|
(0.4ms) SELECT "projects"."id" FROM "projects" WHERE (projects.lft > 1 AND projects.rgt < 10) AND "projects"."status" != ? ORDER BY "projects"."lft" ASC [["status", 9]]
|
|
18
|
(1.3ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_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 ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=0)) AND (issues.notes NOT LIKE '%note%') AND projects.lft >= 1 AND projects.rgt <= 10)
|
|
19
|
Query::StatementInvalid: SQLite3::SQLException: no such column: issues.notes
|
