Content
View differences
Updated by Jens Ulferts almost 9 years ago
Recorded in the log:
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at or near "ORDER"LINE 13: )) ORDER BY work_packages.id DESC, work_packages.root_id, wo... ^: SELECT "work_packages"."id" FROM "work_packages" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "work_packages"."status_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "work_packages"."project_id" LEFT OUTER JOIN "types" ON "types"."id" = "work_packages"."type_id" LEFT OUTER JOIN "users" ON "users"."id" = "work_packages"."assigned_to_id" LEFT OUTER JOIN "users" "responsibles_work_packages" ON "responsibles_work_packages"."id" = "work_packages"."responsible_id" LEFT OUTER JOIN "versions" ON "versions"."id" = "work_packages"."fixed_version_id" LEFT OUTER JOIN "work_packages" "parents_work_packages" ON "parents_work_packages"."id" = "work_packages"."parent_id" WHERE "work_packages"."project_id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL)) AND ((projects.id IN (2)) AND (statuses.is_closed='f') AND ( work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6') OR work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6')) AND projects.id IN (SELECT DISTINCT projects.id FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_package_watchers') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL)))) ORDER BY work_packages.id DESC, work_packages.root_id, work_packages.lft LIMIT $1 OFFSET $2
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at or near "ORDER"LINE 13: ...ND (work_packages.assigned_to_id IN ('74','24'))) ORDER BY w... ^: SELECT "work_packages"."id" FROM "work_packages" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "work_packages"."status_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "work_packages"."project_id" LEFT OUTER JOIN "types" ON "types"."id" = "work_packages"."type_id" LEFT OUTER JOIN "users" ON "users"."id" = "work_packages"."assigned_to_id" LEFT OUTER JOIN "users" "responsibles_work_packages" ON "responsibles_work_packages"."id" = "work_packages"."responsible_id" LEFT OUTER JOIN "versions" ON "versions"."id" = "work_packages"."fixed_version_id" LEFT OUTER JOIN "work_packages" "parents_work_packages" ON "parents_work_packages"."id" = "work_packages"."parent_id" WHERE "work_packages"."project_id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL)) AND ((projects.id IN (2)) AND (statuses.is_closed='f') AND ( work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6') OR work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6')) AND projects.id IN (SELECT DISTINCT projects.id FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_package_watchers') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL))) AND (work_packages.assigned_to_id IN ('74','24'))) ORDER BY work_packages.id DESC, work_packages.root_id, work_packages.lft LIMIT $1 OFFSET $2
**Steps**
- Be non admin
- Go to my page
- Have watched work packages block configured
- Follow “View all watched work packages”
OR
- Be non admin
- Go to wp list
- Add “watchers” filter and select “me” value
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at or near "ORDER"LINE 13: )) ORDER BY work_packages.id DESC, work_packages.root_id, wo... ^: SELECT "work_packages"."id" FROM "work_packages" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "work_packages"."status_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "work_packages"."project_id" LEFT OUTER JOIN "types" ON "types"."id" = "work_packages"."type_id" LEFT OUTER JOIN "users" ON "users"."id" = "work_packages"."assigned_to_id" LEFT OUTER JOIN "users" "responsibles_work_packages" ON "responsibles_work_packages"."id" = "work_packages"."responsible_id" LEFT OUTER JOIN "versions" ON "versions"."id" = "work_packages"."fixed_version_id" LEFT OUTER JOIN "work_packages" "parents_work_packages" ON "parents_work_packages"."id" = "work_packages"."parent_id" WHERE "work_packages"."project_id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL)) AND ((projects.id IN (2)) AND (statuses.is_closed='f') AND ( work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6') OR work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6')) AND projects.id IN (SELECT DISTINCT projects.id FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_package_watchers') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL)))) ORDER BY work_packages.id DESC, work_packages.root_id, work_packages.lft LIMIT $1 OFFSET $2
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at or near "ORDER"LINE 13: ...ND (work_packages.assigned_to_id IN ('74','24'))) ORDER BY w... ^: SELECT "work_packages"."id" FROM "work_packages" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "work_packages"."status_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "work_packages"."project_id" LEFT OUTER JOIN "types" ON "types"."id" = "work_packages"."type_id" LEFT OUTER JOIN "users" ON "users"."id" = "work_packages"."assigned_to_id" LEFT OUTER JOIN "users" "responsibles_work_packages" ON "responsibles_work_packages"."id" = "work_packages"."responsible_id" LEFT OUTER JOIN "versions" ON "versions"."id" = "work_packages"."fixed_version_id" LEFT OUTER JOIN "work_packages" "parents_work_packages" ON "parents_work_packages"."id" = "work_packages"."parent_id" WHERE "work_packages"."project_id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL)) AND ((projects.id IN (2)) AND (statuses.is_closed='f') AND ( work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6') OR work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6')) AND projects.id IN (SELECT DISTINCT projects.id FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_package_watchers') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL))) AND (work_packages.assigned_to_id IN ('74','24'))) ORDER BY work_packages.id DESC, work_packages.root_id, work_packages.lft LIMIT $1 OFFSET $2
**Steps**
- Be non admin
- Go to my page
- Have watched work packages block configured
- Follow “View all watched work packages”
OR
- Be non admin
- Go to wp list
- Add “watchers” filter and select “me” value