SQL error when email officers

The original message was received at Sun, 1 Jan 2017 23:35:21 GMT
from mail-qk0-f172.google.com [209.85.220.172]

---

The following addresses had permanent fatal errors

---

|/etc/tcmail.pl
(reason: 255)
(expanded from: <officers-3613@toastmastersclubs.org>)

---

Transcript of session follows

---

[Sun Jan 1 23:35:28 2017] tcmail.pl: DBD::mysql::db selectall_arrayref failed: Unknown column 'CONTACT1' in 'field list' at /var/www/cgi-bin/dbi_db.pl line 287, <> line 1201.
Status: 500
Content-type: text/html

<h1>Software error:</h1>
<pre>GetRowsAsHashes_DBI[CLUBSITES](Callers=>main::GetFields_DBI>main::GetFields_ClubSitesDB): Unable to execute query: [SELECT CLUBNUMBER,CLUBTZ,ADMINEMAIL,ADMINNAME,REGDATE,ALIAS,DOMAIN,CONTACT1,CONTACT2,CONTACT3,CONTACTS,CONTACTADDR,MEMBERREPLIESTO,OFFICERREPLIESTO,GROUPREPLIESTO,ONEMBRGROUPSPUBLIC,FROMADDRFORMAT,SUBJECTPREFIX,CLUBEMAILADDR,EMAILWHITELIST,EMAILBLACKLIST,USESYSTEMBLACKLIST,ADDSPAMLINKS,SPAMTHRESHOLD,AGENDAEMAILNOTES,AGENDAPRINTNOTES,AGENDAPRINTDATES FROM CLUBSITES WHERE CLUBNUMBER='3613' (Bind Values=)] Error=[Unknown column 'CONTACT1' in 'field list']
</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: DBD::mysql::db selectall_arrayref failed: Unknown column 'CONTACT1' in 'field list' at /var/www/cgi­bin/dbi_db.pl line 287, «» line 1201. -->
[Sun Jan 1 23:35:28 2017] tcmail.pl: GetRowsAsHashes_DBI[CLUBSITES](Callers=>main::GetFields_DBI>main::GetFields_ClubSitesDB): Unable to execute query: [SELECT CLUBNUMBER,CLUBTZ,ADMINEMAIL,ADMINNAME,REGDATE,ALIAS,DOMAIN,CONTACT1,CONTACT2,CONTACT3,CONTACTS,CONTACTADDR,MEMBERREPLIESTO,OFFICERREPLIESTO,GROUPREPLIESTO,ONEMBRGROUPSPUBLIC,FROMADDRFORMAT,SUBJECTPREFIX,CLUBEMAILADDR,EMAILWHITELIST,EMAILBLACKLIST,USESYSTEMBLACKLIST,ADDSPAMLINKS,SPAMTHRESHOLD,AGENDAEMAILNOTES,AGENDAPRINTNOTES,AGENDAPRINTDATES FROM CLUBSITES WHERE CLUBNUMBER='3613' (Bind Values=)] Error=[Unknown column 'CONTACT1' in 'field list']
554 5.3.0 unknown mailer error 255



Reporting-MTA: dns; toastmastersclubs.org
Received-From-MTA: DNS; mail-qk0-f172.google.com
Arrival-Date: Sun, 1 Jan 2017 23:35:21 GMT

Final-Recipient: RFC822; officers-3613@toastmastersclubs.org
X-Actual-Recipient: X-Unix; |/etc/tcmail.pl
Action: failed
Status: 5.0.0
Diagnostic-Code: X-Unix; 255
Last-Attempt-Date: Sun, 1 Jan 2017 23:35:28 GMT

Thanks, Ed Larson, club 3613
chagrinvalleytoastmasters.toastmastersclubs.org/

fixed

works now!