Actions
Defect #3665
closed
No email notifications from whole project
Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Email notifications
Target version:
-
Start date:
2009-07-24
Due date:
% Done:
0%
Estimated time:
Resolution:
Invalid
Affected version:
Description
Hi,
I got problem with email notifications, there are multiple projects and one of them is not sending any emails about changes. There are no per project notification options so I'm bit confused. There is nothing in my mail server logs so redmine is not trying to send those mails.
ubuntu 9.04 with:
- redmine 0.8.4.stable.2824
- ruby 1.8.7 (2008-08-11 patchlevel 72) [i486-linux]
- rails 2.1.2
- postgresql 8.3.7
production.log:
Processing IssuesController#show (for 172.16.111.48 at 2009-07-24 14:25:20) [GET]
Session ID: 2f2d64e43f992c13edf17dbf79fef356
Parameters: {"action"=>"show", "id"=>"8486", "controller"=>"issues"}
SQL (0.000690) SELECT max("settings".updated_on) AS max_updated_on FROM "settings"
User Load (0.000604) SELECT * FROM "users" WHERE ("users"."id" = 66) AND (users.status = 1)
Issue Load (0.000541) SELECT * FROM "issues" WHERE ("issues"."id" = 8486)
Project Load (0.000462) SELECT * FROM "projects" WHERE ("projects"."id" = 117)
Tracker Load (0.000289) SELECT * FROM "trackers" WHERE ("trackers"."id" = 2)
IssueStatus Load (0.000286) SELECT * FROM "issue_statuses" WHERE ("issue_statuses"."id" = 1)
User Load (0.000378) SELECT * FROM "users" WHERE ("users"."id" = 66)
Enumeration Load (0.000286) SELECT * FROM "enumerations" WHERE ("enumerations"."id" = 3)
IssueCategory Load (0.000298) SELECT * FROM "issue_categories" WHERE ("issue_categories"."id" = NULL)
EnabledModule Load (0.000376) SELECT * FROM "enabled_modules" WHERE ("enabled_modules".project_id = 117)
Journal Load (0.000432) SELECT * FROM "journals" WHERE ("journals".journalized_id = 8486 AND "journals".journalized_type = E'Issue') ORDER BY journals.created_on ASC
UserPreference Load (0.000338) SELECT * FROM "user_preferences" WHERE ("user_preferences".user_id = 66) LIMIT 1
Member Load Including Associations (0.004417) SELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."role_id" AS t0_r3, "members"."created_on" AS t0_r4, "members"."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"."projects_count" AS t1_r6, "projects"."created_on" AS t1_r7, "projects"."updated_on" AS t1_r8, "projects"."identifier" AS t1_r9, "projects"."status" AS t1_r10, "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 FROM "members" LEFT OUTER JOIN "projects" ON "projects".id = "members".project_id LEFT OUTER JOIN "roles" ON "roles".id = "members".role_id WHERE ("members".user_id = 66 AND (projects.status=1)) ORDER BY projects.name
Workflow Load (0.000418) SELECT * FROM "workflows" WHERE ("workflows".old_status_id = 1 AND (role_id=5 and tracker_id=2))
IssueStatus Load (0.000362) SELECT * FROM "issue_statuses" WHERE ("issue_statuses"."id" IN (3,10,5))
Enumeration Load (0.000389) SELECT * FROM "enumerations" WHERE ("enumerations"."opt" = E'IPRI') ORDER BY position
Enumeration Load (0.000332) SELECT * FROM "enumerations" WHERE ("enumerations"."opt" = E'ACTI' AND "enumerations"."is_default" = 't') ORDER BY position LIMIT 1
Rendering template within layouts/base
Rendering issues/show.rhtml
Watcher Load (0.001664) SELECT * FROM "watchers" WHERE ("watchers".watchable_id = 8486 AND "watchers".watchable_type = E'Issue' AND (watchers.user_id = 66)) LIMIT 1
User Load (0.000562) SELECT * FROM "users" WHERE ("users"."id" = 18)
SQL (0.000401) SELECT sum("time_entries".hours) AS sum_hours FROM "time_entries" WHERE ("time_entries".issue_id = 8486)
IssueCustomField Load (0.000476) SELECT * FROM "custom_fields" WHERE (is_for_all='t') AND ( ("custom_fields"."type" = 'IssueCustomField' ) ) ORDER BY position
IssueCustomField Load (0.000533) SELECT * FROM "custom_fields" INNER JOIN "custom_fields_projects" ON "custom_fields".id = "custom_fields_projects".custom_field_id WHERE ("custom_fields_projects".project_id = 117 ) AND ( ("custom_fields"."type" = 'IssueCustomField' ) ) ORDER BY custom_fields.position
Attachment Load (0.002169) SELECT * FROM "attachments" WHERE ("attachments".container_id = 8486 AND "attachments".container_type = E'Issue') ORDER BY attachments.created_on
IssueRelation Load (0.000515) SELECT * FROM "issue_relations" WHERE ("issue_relations".issue_from_id = 8486)
IssueRelation Load (0.000484) SELECT * FROM "issue_relations" WHERE ("issue_relations".issue_to_id = 8486)
Rendered issue_relations/_form (0.00078)
Rendered issues/_relations (0.00385)
User Load (0.001866) SELECT "users".* FROM "users" INNER JOIN watchers ON users.id = watchers.user_id WHERE (("watchers".watchable_id = 8486) AND ("watchers".watchable_type = E'Issue'))
Rendered watchers/_watchers (0.00294)
Changeset Load (0.000591) SELECT * FROM "changesets" INNER JOIN "changesets_issues" ON "changesets".id = "changesets_issues".changeset_id WHERE ("changesets_issues".issue_id = 8486 ) ORDER BY changesets.committed_on ASC, changesets.id ASC
Member Load Including Associations (0.009726) SELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."role_id" AS t0_r3, "members"."created_on" AS t0_r4, "members"."mail_notification" AS t0_r5, "users"."id" AS t1_r0, "users"."login" AS t1_r1, "users"."hashed_password" AS t1_r2, "users"."firstname" AS t1_r3, "users"."lastname" AS t1_r4, "users"."mail" AS t1_r5, "users"."mail_notification" AS t1_r6, "users"."admin" AS t1_r7, "users"."status" AS t1_r8, "users"."last_login_on" AS t1_r9, "users"."language" AS t1_r10, "users"."auth_source_id" AS t1_r11, "users"."created_on" AS t1_r12, "users"."updated_on" AS t1_r13, "users"."type" AS t1_r14 FROM "members" LEFT OUTER JOIN "users" ON "users".id = "members".user_id WHERE ("members".project_id = 117 AND (users.status=1))
Role Load (0.000627) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
Role Load (0.000405) SELECT * FROM "roles" WHERE ("roles"."id" = 6)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 6)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 6)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 6)
Role Load (0.000335) SELECT * FROM "roles" WHERE ("roles"."id" = 3)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
Role Load (0.000581) SELECT * FROM "roles" WHERE ("roles"."id" = 4)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 6)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
CACHE (0.000000) SELECT * FROM "roles" WHERE ("roles"."id" = 5)
SQL (0.000536) SELECT count(*) AS count_all FROM "issue_categories" WHERE ("issue_categories".project_id = 117)
IssueCategory Load (0.000538) SELECT * FROM "issue_categories" WHERE ("issue_categories".project_id = 117) ORDER BY issue_categories.name
SQL (0.000742) SELECT count(*) AS count_all FROM "versions" WHERE ("versions".project_id = 117)
Rendered issues/_form_custom_fields (0.00003)
Rendered issues/_form (0.24976)
Enumeration Load (0.000527) SELECT * FROM "enumerations" WHERE ("enumerations"."opt" = E'ACTI') ORDER BY position
CustomField Load (0.000481) SELECT * FROM "custom_fields" WHERE (type = 'TimeEntryCustomField') ORDER BY position
Rendered attachments/_form (0.00032)
Rendered issues/_edit (0.25621)
Token Load (0.000575) SELECT * FROM "tokens" WHERE ("tokens".user_id = 66 AND (action='feeds')) LIMIT 1
Query Load (0.000707) SELECT * FROM "queries" WHERE (1=1 AND (is_public = 't' OR user_id = 66) AND (project_id IS NULL OR project_id = 117)) ORDER BY name ASC
Rendered issues/_sidebar (0.00790)
Project Load Including Associations (0.003334) SELECT "projects"."id" AS t0_r0, "projects"."name" AS t0_r1, "projects"."description" AS t0_r2, "projects"."homepage" AS t0_r3, "projects"."is_public" AS t0_r4, "projects"."parent_id" AS t0_r5, "projects"."projects_count" AS t0_r6, "projects"."created_on" AS t0_r7, "projects"."updated_on" AS t0_r8, "projects"."identifier" AS t0_r9, "projects"."status" AS t0_r10, "parents_projects"."id" AS t1_r0, "parents_projects"."name" AS t1_r1, "parents_projects"."description" AS t1_r2, "parents_projects"."homepage" AS t1_r3, "parents_projects"."is_public" AS t1_r4, "parents_projects"."parent_id" AS t1_r5, "parents_projects"."projects_count" AS t1_r6, "parents_projects"."created_on" AS t1_r7, "parents_projects"."updated_on" AS t1_r8, "parents_projects"."identifier" AS t1_r9, "parents_projects"."status" AS t1_r10 FROM "projects" LEFT OUTER JOIN "projects" parents_projects ON "parents_projects".id = "projects".parent_id INNER JOIN members ON projects.id = members.project_id WHERE (("members".user_id = 66) AND ((projects.status=1)))
Rendered layouts/_project_selector (0.02932)
Wiki Load (0.000582) SELECT * FROM "wikis" WHERE ("wikis".project_id = 117) LIMIT 1
Completed in 0.36858 (2 reqs/sec) | Rendering: 0.30361 (82%) | DB: 0.03985 (10%) | 200 OK [https://redmine.redefine.pl/issues/show/8486]
Updated by 
Updated by 
Updated by
Actions