OCS Notify Users email without recipient address

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
Posts: 51
Joined: Mon Dec 07, 2009 1:41 pm

OCS Notify Users email without recipient address

Postby JohnGrobler » Sun Sep 19, 2010 7:37 am

Good day,

In OCS, we've found that when trying to use the "Notify Users" page ([url.com]/index.php/[conference]/[conf]/director/notifyUsers):

When trying to send an email notification to all users without selecting any filters (All users associated with this conference, All readers, etc not selected) on the Home > [conference] > User > Email page, the emails are transmitted as expected. But when selecting a filter such as "All published presenters" on this same page, no emails will be delivered. It seems that the generated email To address field is blank for all published presenters emails.

After code inspection we've found the following, which seems to be the cause of the problem, can you please confirm if this is a bug:

In /classes/paper/AuthorDAO.inc.php, the email address is set as a blank string for the allAuthors filter selection.

Code: Select all

                $result =& $this->retrieveRange(
                        'SELECT        DISTINCT CAST(\'\' AS CHAR) AS url,
                                0 AS author_id,
                                0 AS paper_id,
                                CAST(\'\' AS CHAR) AS email,
                                CAST(\'\' AS CHAR) AS biography,
                                0 AS primary_contact,
                                0 AS seq,
                                aa.first_name AS first_name,
                                aa.middle_name AS middle_name,
                                aa.last_name AS last_name,
                                aa.affiliation AS affiliation,
                                aa.country FROM paper_authors aa,
                                papers a,
                                published_papers pa,
                                sched_confs e
                        WHERE        e.sched_conf_id = pa.sched_conf_id
                                AND aa.paper_id = a.paper_id
                                ' . (isset($schedConfId)?'AND a.sched_conf_id = ? ':'') . '
                                AND pa.paper_id = a.paper_id
                                AND a.status = ' . STATUS_PUBLISHED . '
                                AND (aa.last_name IS NOT NULL
                                AND aa.last_name <> \'\')' . $initialSql . ' ORDER BY aa.last_name, aa.first_name',

Thank you,
John Grobler

Posts: 952
Joined: Mon May 05, 2008 10:29 am
Location: Vancouver, BC

Re: OCS Notify Users email without recipient address

Postby mcrider » Mon Sep 27, 2010 5:32 pm

Hi John,

This looks to have been fixed by http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=5491. Could you apply the patch there and see if that fixes your issue?


Return to “OCS Technical Support”

Who is online

Users browsing this forum: No registered users and 1 guest