Redmine

Go to Administration > Settings > Email Notifications. Is "Issue added" checked?

And if you go to http://<redmine install path>/admin/test_email does the administrator get an email?

Yee with the test redmine sends the email

Last one: does the user (the assignee) have notifications enabled ? If not, this behaviour is normal.
If yes, please provide informations requested at SubmittingBugs and minimal steps to reproduce so that we can confirm it's a defect.
It's probably just a configuration or migration problem on your instance.

I have the same problem after updating to redmine 1.1.0. My user email notification is set to "For any event on all my projects" and I don't receive notification emails. The test email works fine and if I watch an issue I receive notification emails succesfully.
Let me know if you need more information.

Fixed the problem. Looks like I somehow forgot to run the migrations after updating. My bad.

How to do the migration? I did what it says on the website must be done to upgrade Redmine

Thanks

Hello Maxim could you help me ? Thanos

Hello Maxim, could you help me ? Thanks

Guess he is talking about running rake migrate:db, but you said you did it before ?

I've been able to migrate the BBDD and Redmine still send mail

I migrated the database but redmine not send e-mails

What's your redmine version ?

Ups sorry 1.1.1

Did you manage to make it work ?

If not, what's the result of rake db:migrate ?

I did not succeed, when I do a migrate Redmine returns nothing. I will review the problem with Aptana and the debugger.

What do you mean by nothing ?

Did you set RAILS_ENV to production ?
Did you try to run it with the --trace argument ?

• Invoke db:migrate (first_time)
• Invoke environment (first_time)
• Execute environment
• Execute db:migrate
• Invoke db:schema:dump (first_time)
• Invoke environment
• Execute db:schema:dump
  lserrano@robotica:/var/www/redmine$

What's the type of your users.mail_notification column ?
What do you find in log when creating an issue ?

What's the type of your users.mail_notification column ? tinyint(1)
What do you find in log when creating an issue ?

Processing IssuesController#create (for 127.0.0.1 at 2011-03-09 16:32:59) [POST]
Parameters: {"commit"=>"Crear", "project_id"=>"red", "action"=>"create", "authenticity_token"=>"wR52W1Qu9EUY6397mYrgNPErhqu7uxet7ekKc5QSRYo=", "issue"=>{"start_date"=>"2011-03-09", "estimated_hours"=>"", "priority_id"=>"4", "parent_issue_id"=>"", "fixed_version_id"=>"1", "done_ratio"=>"0", "assigned_to_id"=>"3", "subject"=>"Test", "tracker_id"=>"2", "due_date"=>"", "status_id"=>"1", "description"=>""}, "controller"=>"issues", "attachments"=>{"1"=>{"description"=>""}, "screenshot"=>{"name"=>"screenshot", "content"=>"", "description"=>""}}}
Sending email notification to:
Redirected to https://127.0.0.1/issues/2518
Completed in 148ms (DB: 93) | 302 Found [https://127.0.0.1/projects/red/issues]

Processing IssuesController#show (for 127.0.0.1 at 2011-03-09 16:32:59) [GET]
Parameters: {"action"=>"show", "id"=>"2518", "controller"=>"issues"}
Rendering template within layouts/base
Rendering issues/show.rhtml
Completed in 311ms (View: 268, DB: 24) | 200 OK [https://127.0.0.1/issues/2518]

Processing AdminController#index (for 127.0.0.1 at 2011-03-09 16:33:02) [GET]
Parameters: {"action"=>"index", "controller"=>"admin"}
Rendering template within layouts/admin
Rendering admin/index
Completed in 22ms (View: 16, DB: 4) | 200 OK [https://127.0.0.1/admin]

Processing LogsController#index (for 127.0.0.1 at 2011-03-09 16:33:03) [GET]
Parameters: {"action"=>"index", "controller"=>"logs"}
Rendering template within layouts/admin
Rendering logs/index
Completed in 33ms (View: 28, DB: 2) | 200 OK [https://127.0.0.1/logs]

Ok, tinyint is not good, should be a varchar, something must have gone wrong in your migration.

You can try to run the missing migration with rake db:migrate:up VERSION=20100129193402

Actually, this should not work as migrations can't be ran twice.

Just an idea : maybe you could copy db/migrate/20100129193402_change_users_mail_notification_to_string.rb to, e.g., db/migrate/99990129193402_change_users_mail_notification_to_string.rb, run migrations then remove the new 99990129193402 record from table schema_migration ?

After make rake db:migrate:up VERSION=20100129193402 redmine dont'send email and the log return:

The following error occured while sending email notification: "550 <luis.serrano.aranda@gmail.com>, Recipient unknown

Ant the email test works

Could you do what explained in note 26 then check your users.mail_notification column data type ?

If a make the up the redmain not send emails and the user.mail_notification is a VARCHAR (STRING)

Luis Serrano Aranda wrote:

If a make the up the redmain not send emails and the user.mail_notification is a VARCHAR (STRING)

Ok, now you column has the right format.
What's the value of the last record of the schema_migration table ?

The value of the last record is 99

In the development environment I have make a test, load the redmine 1.1.2 and load the default BBDD

(With the same email.yml) and the email test return the 550 error ¿?

1) I guess you've chosen to display only the first 100 records, hence the 99, you have to display all records
=)

2) what's on in log when you send a test e-mail on your production environment (not the test one) ?

Not not I have displayed all the record I attach the schema capture

Not not I have displayed all the record I attach the schema capture

2) The test works

any suggestions?

Luis Serrano Aranda wrote:

Not not I have displayed all the record I attach the schema capture

This is not possible. Could you please attach the full schema_migrations contents ?

The sql export ?

Now I have a new problem... when I make a new issue if I put watchers (after the creation of the issue) redmine returns the message translation missiong: es, field_watcher_users no es valido.

Etienne thanks for you job and your help

Luis Serrano Aranda wrote:

The sql export ?

Yes, please.

Etienne any news ?
comparethe tables of my database current (updated) with a new and empty database of the version 1.1.2?

Thanks

I just say that you last schema_migrations record can't be 99 (at least, should not be) since 99 is a very old migration (see source:trunk/db/migrate, migrations are run by rake db:migrate in their file name alphabetic order).

So, please check twice or / and attach here the contents of the schema_migrations table ?

Edit : numeric order :/

Well, your db is missing migration 20100129193402 and only this one.

1. copy file db/migrate/20100129193402_change_users_mail_notification_to_string.rb to db/migrate/99990129193402_change_users_mail_notification_to_string.rb
2. run rake db:migrate RAILS_ENV=production --trace
3. If no error then :
   1. update the new 99990129193402 record from table schema_migration to the value 20100129193402
   2. remove the newly created file db/migrate/99990129193402_change_users_mail_notification_to_string.rb so that it can't be run again accidentally

...And finally works.

A lot of thanks !!!!

Very good job !!!