MySQLTalk.org

Hemant Madaan · Guest

Hi There,

First of all, thanks for creating such a useful and wonderful tool. Can
anyone let me know if its possible to receive a mail notification any time a
new issue is created and assigned to someone. I know the settings can be
changed by going into preferences for each user, but, we need it to be a
default option already selected for all the users, and they should receive
notifications if a new issue is created or assigned to them, not just the
default 'updating an issue' option. Any help will be much appreciated.

Thanks & Regards,
Hemant Madaan
Technical Director
OTS Solutions Pvt. Ltd.

PH: +91 124 4101350, 4101351
FAX: +91 124 4102353
Mobile: +91 9811809230

www.otssolutions.com <http://www.otssolutions.com/>

**********************************************************************

Private, Confidential and Privileged. This e-mail and any files and
attachments transmitted with it are confidential and/or privileged. They are
intended solely for the use of the intended recipient. The content of this
e-mail and any file or attachment transmitted with it may have been changed
or altered without the consent of the author. If you are not the intended
recipient, please note that any review, dissemination, disclosure,
alteration, printing, circulation or transmission of this e-mail and/or any
file or attachment transmitted with it, is prohibited and may be unlawful.
If you have received this e-mail or any file or attachment transmitted with
it in error please notify OTS Solutions Pvt Ltd at info (AT) otssolutions (DOT) com

***********************************************************************

Bryan Alsdorf · Guest

Hi Hemant,

Hemant Madaan wrote:

Bryan Alsdorf · Guest

Hi,

You can edit the preferences for new users by opening config.inc.php and
changing the values for "APP_DEFAULT_ASSIGNED_EMAILS" and
"APP_DEFAULT_NEW_EMAILS". Unfortunately there is no way to easily change
this for current users. If you are interested in the detailed way to
change the preferences for all users just let me know.

/bryan

Hemant Madaan wrote:

Hemant Madaan · Guest

Hi Bryan,

Thanks for your response. I tried setting both of them to 1 and then
assigned while creating a new issue to myself for testing. Unfortunately, I
didn't receive any emails yet. I confirm that other emails are working fine.
Please let me know.

Thanks & Regards,
Hemant Madaan
Technical Director
OTS Solutions Pvt. Ltd.

PH: +91 124 4101350, 4101351
FAX: +91 124 4102353
Mobile: +91 9811809230

www.otssolutions.com

**********************************************************************

Private, Confidential and Privileged. This e-mail and any files and
attachments transmitted with it are confidential and/or privileged. They are
intended solely for the use of the intended recipient. The content of this
e-mail and any file or attachment transmitted with it may have been changed
or altered without the consent of the author. If you are not the intended
recipient, please note that any review, dissemination, disclosure,
alteration, printing, circulation or transmission of this e-mail and/or any
file or attachment transmitted with it, is prohibited and may be unlawful.
If you have received this e-mail or any file or attachment transmitted with
it in error please notify OTS Solutions Pvt Ltd at info (AT) otssolutions (DOT) com

***********************************************************************

-----Original Message-----
From: Bryan Alsdorf [mailto:bryan (AT) mysql (DOT) com]
Sent: Monday, January 29, 2007 11:31 AM
To: Hemant Madaan
Cc: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: Issue of getting emails when new issue is created/assigned

Hi,

You can edit the preferences for new users by opening config.inc.php and
changing the values for "APP_DEFAULT_ASSIGNED_EMAILS" and
"APP_DEFAULT_NEW_EMAILS". Unfortunately there is no way to easily change
this for current users. If you are interested in the detailed way to change
the preferences for all users just let me know.

/bryan

Hemant Madaan wrote:

Brian E. Bothwell · Guest

This is a follow up the post below. I am trying to figure out how make
it so all existing users will automatically receive emails for any
projects they are added to. I have this working fine with new users, but
can't seem to get it working for existing users. I tried the SQL update
below (on just one user) and it didn't seem to work. I am hoping to
understand the serialized array a bit better so I can understand what
kind of change is needed to alter a user to ensure that for each project
they are added to, they have the "*Receive emails when new issues are
assigned to you?*" option set to "yes" every time.

The change below did not seem to work with existing users and existing
projects, nor with existing users and new projects.

Maybe I am missing something.

thanks,

-Brian

Barry Benowitz · Guest

The fix for this is on the wiki.

Barry

-----Original Message-----
From: Brian E. Bothwell [mailto:brian.bothwell (AT) wisdomtools (DOT) com]
Sent: Thursday, May 10, 2007 7:09 PM
To: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: Issue of getting emails when new issue is created/assigned

This is a follow up the post below. I am trying to figure out how make
it so all existing users will automatically receive emails for any
projects they are added to. I have this working fine with new users, but
can't seem to get it working for existing users. I tried the SQL update
below (on just one user) and it didn't seem to work. I am hoping to
understand the serialized array a bit better so I can understand what
kind of change is needed to alter a user to ensure that for each project
they are added to, they have the "*Receive emails when new issues are
assigned to you?*" option set to "yes" every time.

The change below did not seem to work with existing users and existing
projects, nor with existing users and new projects.

Maybe I am missing something.

thanks,

-Brian

Brian E. Bothwell · Guest

There is a typo in the diff you posted:

$tpl->assign("assigned_projects",
Project::getAssocList($assigned_prj_ids);

This is missing a ')' on the end.

I tried adapting this fix for 2.0.1, but got this error when trying to
use the new preferences.php to update my prefs, which seems be caused by
an array getting passed to Project::getAssocList() instead of a usr_id:

An error was found at 05/11/2007 10:48:28 (1178894908) on line '651'
of script '/www/eventum-2.0.1/include/class.project.php'.

The error message passed to us was:

'DB Error: no such field'

A more detailed error message follows:

'SELECT
prj_id,
prj_title
FROM
eventum.eventum_project,
eventum.eventum_project_user
WHERE
prj_id=pru_prj_id AND
pru_usr_id=Array
ORDER BY
prj_title [nativecode=1054 ** Unknown column 'Array' in 'where clause']'

Barry Benowitz wrote:

Barry Benowitz · Guest

Thanks, I will fix on the wiki

Barry

________________________________

From: Brian E. Bothwell [mailto:brian.bothwell (AT) wisdomtools (DOT) com]
Sent: Friday, May 11, 2007 11:56 AM
To: Barry Benowitz
Cc: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: Issue of getting emails when new issue is created/assigned

There is a typo in the diff you posted:

$tpl->assign("assigned_projects",
Project::getAssocList($assigned_prj_ids);

This is missing a ')' on the end.

I tried adapting this fix for 2.0.1, but got this error when trying to
use the new preferences.php to update my prefs, which seems be caused by
an array getting passed to Project::getAssocList() instead of a usr_id:

An error was found at 05/11/2007 10:48:28 (1178894908) on line '651' of
script '/www/eventum-2.0.1/include/class.project.php'.

The error message passed to us was:

'DB Error: no such field'

A more detailed error message follows:

'SELECT
prj_id,
prj_title
FROM
eventum.eventum_project,
eventum.eventum_project_user
WHERE
prj_id=pru_prj_id AND
pru_usr_id=Array
ORDER BY
prj_title [nativecode=1054 ** Unknown column 'Array' in 'where clause']'

Barry Benowitz wrote:

The fix for this is on the wiki.

Barry

-----Original Message-----
From: Brian E. Bothwell [mailto:brian.bothwell (AT) wisdomtools (DOT) com]
Sent: Thursday, May 10, 2007 7:09 PM
To: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: Issue of getting emails when new issue is created/assigned

This is a follow up the post below. I am trying to figure out how make
it so all existing users will automatically receive emails for any
projects they are added to. I have this working fine with new users, but
can't seem to get it working for existing users. I tried the SQL update
below (on just one user) and it didn't seem to work. I am hoping to
understand the serialized array a bit better so I can understand what
kind of change is needed to alter a user to ensure that for each project
they are added to, they have the "*Receive emails when new issues are
assigned to you?*" option set to "yes" every time.

The change below did not seem to work with existing users and existing
projects, nor with existing users and new projects.

Maybe I am missing something.

thanks,

-Brian

Hemant Madaan wrote:

Hi Bryan,

The problem is that we have created all our users
already. Is there

any

script or any DB changes which we can do to the settings
for the

existing

users in bulk. Look forward to your response.

Those settings are stored in a serialized array in the
usr_preferences
field of the eventum_user table. Here is a statement that will
update
all users to have "yes" for those to settings. It will also
overwrite
any other preferences they might have already set.

UPDATE eventum_user SET usr_preferences

'a:9:{s:19:"close_popup_windows";s:1:"0";s:23:"receive_assigned_emails";
a:1:{i:1;s:1:"1";}s:18:"receive_new_emails";a:1:{i:1;s:1:"1";}s:8:"timez
one";s:10:"Etc/GMT+12";s:17:"list_refresh_rate";s:1:"5";s:19:"emails_ref
resh_rate";s:1:"5";s:15:"email_signature";s:0:"";s:15:"auto_append_sig";
N;s:20:"auto_append_note_sig";N;}';

Note: email clients may wrap the above statement, you need to
make

sure

it is all on one line.

/bryan