TOPIC:

After clicking on the response link in an emailed agenda to take a role and sending the email that appeared, I got the following reply from the server. Even though I received this, the role was successfully taken in the agenda.

Mail Delivery Subsystem <This email address is being protected from spambots. You need JavaScript enabled to view it.>
9:41 AM (3 minutes ago)

to me
The original message was received at Wed, 23 May 2018 16:41:08 GMT
from mail-ua0-f178.google.com [209.85.217.178]

---

The following addresses had permanent fatal errors

---

|/etc/tcmail.pl
(reason: 255)
(expanded from: <This email address is being protected from spambots. You need JavaScript enabled to view it.>)

---

Transcript of session follows

---

[Wed May 23 16:41:10 2018] tcmail.pl: Use of uninitialized value $p in substitution (s///) at /usr/local/lib64/perl5/DateTime.pm line 1343.
[Wed May 23 16:41:10 2018] tcmail.pl: Use of uninitialized value $p in substitution (s///) at /usr/local/lib64/perl5/DateTime.pm line 1364.
[Wed May 23 16:41:10 2018] tcmail.pl: DBD::mysql::db selectall_arrayref failed: Unknown column 'DATEACTIVATED' in 'where clause' at /var/www/cgi-bin/dbi_db.pl line 300.
Status: 500
Content-type: text/html

<h1>Software error:</h1>
<pre>GetRowsAsArrays_DBI[AGENDA](Callers=>main::GetRowsAsArrays_AgendaDB>main::Roles2MIDs_MembersDB): Unable to execute query: [SELECT MEMBERID FROM AGENDA WHERE MEETINGID='01015361' and DATEACTIVATED > 0 AND DATEDEACTIVATED = 0 and DATEDELETED=0 and MEMBERID>0 and (ROLE LIKE 'Toastmaster%' or ROLE LIKE '%*Toastmaster%' or ROLE LIKE '%Contestmaster%' or ROLE LIKE '%Chair%' ) order by ASEQUENCE,ENTRYID (Bind Values=)] Error=[Unknown column 'DATEACTIVATED' in 'where clause']
</pre>
<p>
For help, please send mail to this site's webmaster, giving this error message
and the time and date of the error.

</p>
<!-- warning: Use of uninitialized value $p in substitution (s///) at /usr/local/lib64/perl5/DateTime.pm line 1343. -->
<!-- warning: Use of uninitialized value $p in substitution (s///) at /usr/local/lib64/perl5/DateTime.pm line 1364. -->
<!-- warning: DBD::mysql::db selectall_arrayref failed: Unknown column 'DATEACTIVATED' in 'where clause' at /var/www/cgi­bin/dbi_db.pl line 300. -->
[Wed May 23 16:41:10 2018] tcmail.pl: GetRowsAsArrays_DBI[AGENDA](Callers=>main::GetRowsAsArrays_AgendaDB>main::Roles2MIDs_MembersDB): Unable to execute query: [SELECT MEMBERID FROM AGENDA WHERE MEETINGID='01015361' and DATEACTIVATED > 0 AND DATEDEACTIVATED = 0 and DATEDELETED=0 and MEMBERID>0 and (ROLE LIKE 'Toastmaster%' or ROLE LIKE '%*Toastmaster%' or ROLE LIKE '%Contestmaster%' or ROLE LIKE '%Chair%' ) order by ASEQUENCE,ENTRYID (Bind Values=)] Error=[Unknown column 'DATEACTIVATED' in 'where clause']
554 5.3.0 unknown mailer error 255

Final-Recipient: RFC822; This email address is being protected from spambots. You need JavaScript enabled to view it.
X-Actual-Recipient: X-Unix; |/etc/tcmail.pl
Action: failed
Status: 5.0.0
Diagnostic-Code: X-Unix; 255
Last-Attempt-Date: Wed, 23 May 2018 16:41:10 GMT

---

Forwarded message

---

From: Marc Richards <This email address is being protected from spambots. You need JavaScript enabled to view it.>
To: This email address is being protected from spambots. You need JavaScript enabled to view it.
Cc:
Bcc:
Date: Wed, 23 May 2018 09:40:37 -0700
Subject: Taking Speaker #1 role for May 29, 2018 Quest Toastmasters #4643 meeting.
Thank you for your communication!

This email is sent to the email list server to process your response.
It may take a few minutes to get properly processed.

PLEASE CLICK SEND--DO NOT CHANGE THIS EMAIL.

thx ... fixed... notifications were not sent.