Redmine

forgot to mention:

Postgresql 8.1
ruby 1.8.7
Rails 2.3.5

This is a defect alright, but it has already been tackled, see e.g. #3589. Can you give a way to reproduce this (and especially reproduce that yourself)? Please also give more info about your environment, see SubmittingBugs for what else we need.

ok.

ruby script/about:

About your application's environment
Ruby version              1.8.7 (x86_64-linux)
RubyGems version          1.3.7
Rack version              1.0
Rails version             2.3.5
Active Record version     2.3.5
Active Resource version   2.3.5
Action Mailer version     2.3.5
Active Support version    2.3.5
Application root          /home/redmine
Environment               production
Database adapter          postgresql
Database schema version   20100221100219

About your Redmine plugins
Redmine Wiki Extensions plugin   0.2.2

PostgreSQL server isn't on the localhost.

1. Before I begin:
   

    select id, login from users order by id;
    id | login
   ----+--------
     1 | admin
     3 | fe328
     6 | user1
   select value from settings where name='notified_events';
             value
   ------------------------
    ---
    - issue_added
    - issue_updated
    - news_added
    - document_added
    - file_added
    - message_posted
    - wiki_content_added
    - wiki_content_updated
   

2. Creating a project 'test' (private).
   testing:
   

   select id, name, is_public, status, lft, rgt from projects where name='test';
    id | name | is_public | status | lft | rgt
   ----+------+-----------+--------+-----+-----
     7 | test | f         |      1 |   3 |   4
   

3. Adding users to the project.
   testing:
   

   select user_id, project_id, mail_notification from members where project_id=7;
    user_id | project_id | mail_notification
   ---------+------------+-------------------
          3 |          7 | f
          6 |          7 | f
   

4. Adding a board. (as fe328)
   testing:
   

   select * from boards where project_id=7;
    id | project_id |    name    | description | position | topics_count | messages_count | last_message_id
   ----+------------+------------+-------------+----------+--------------+----------------+-----------------
    11 |          7 | test forum | test        |        1 |            0 |              0 |
   

5. Adding a message. (as fe328)
   testing:
   

   select id, subject, author_id from messages where board_id=11;
    id |    subject    | author_id
   ----+---------------+-----------
     9 | test message. |         3
   select * from watchers where watchable_id=9;
    id | watchable_type | watchable_id | user_id
   ----+----------------+--------------+---------
     7 | Message        |            9 |       3
   

6. Replying to that message. (as user1)
   testing:
   

   select id, subject, author_id, replies_count from messages where board_id=11;
    id |      subject      | author_id | replies_count
   ----+-------------------+-----------+---------------
     9 | test message.     |         3 |             1
    10 | RE: test message. |         6 |             0
   

   
   fe328 got a notification.

1. Removing fe328 from the project. (as admin)
   testing:
   

   select user_id, project_id, mail_notification from members where project_id=7;
    user_id | project_id | mail_notification
   ---------+------------+-------------------
          6 |          7 | f
   select * from watchers where watchable_id=9;
    id | watchable_type | watchable_id | user_id
   ----+----------------+--------------+---------
     8 | Message        |            9 |       6
   

   
   seems ok.

1. Replying once again. (as user1)
   testing:
   

   select id, subject, author_id, replies_count from messages where board_id=11;
    id |      subject      | author_id | replies_count
   ----+-------------------+-----------+---------------
     9 | test message.     |         3 |             2
    11 | RE: test message. |         6 |             0
    10 | RE: test message. |         6 |             0
   

   
   No notifications. Works just as it supposed to work.

1. Replying once again. (as admin)
   testing:
   

   select id, subject, author_id, replies_count from messages where board_id=11;
    id |      subject      | author_id | replies_count
   ----+-------------------+-----------+---------------
     9 | test message.     |         3 |             3
    12 | RE: test message. |         1 |             0
    11 | RE: test message. |         6 |             0
    10 | RE: test message. |         6 |             0
   select * from watchers where watchable_id=9;
    id | watchable_type | watchable_id | user_id
   ----+----------------+--------------+---------
     9 | Message        |            9 |       1
     8 | Message        |            9 |       6
   

   
   fe328 GOT notification
   Seams like this only happens if you post as administrator. But It's probably still wrong behavior.

• SQL used only to view information. No alteration was made there.
• Only related information displayed in SQL results (for example - the user list)

The info and way to reproduce look good, I'll try to have a look later on.

Alexey Kiryanov wrote:

1. Replying once again. (as admin)
   testing:
   [...]
   fe328 GOT notification
   Seams like this only happens if you post as administrator. But It's probably still wrong behavior.

See if the user watches anything else, like the board or the project.

Felix Schäfer wrote:

Alexey Kiryanov wrote:

1. Replying once again. (as admin)
   testing:
   [...]
   fe328 GOT notification
   Seams like this only happens if you post as administrator. But It's probably still wrong behavior.

See if the user watches anything else, like the board or the project.

Nope.

select * from watchers;
 id | watchable_type | watchable_id | user_id
----+----------------+--------------+---------
  6 | Message        |            5 |       1
  8 | Message        |            9 |       6
  9 | Message        |            9 |       1
(3 rows)

I personaly won't be able to confirm this as I stoped using redmine (still enjoyed using it though)