statement-invalid-log.txt

Go MAEDA, 2021-04-05 11:58

Download (3.78 KB)

 
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