Hi,
Recently we have been unable to send emails to a group (officers) on our site.
We receive the following response (via email)
Code:
[Wed Apr 25 08:48:19 2018] tcmail.pl: DBD::mysql::db selectall_arrayref failed: Unknown column 'AGENDAEMAILNOTES' in 'field list' at /var/www/cgi-bin/dbi_db.pl line 278.
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,DATECREATED,DATEUPDATED,ALIAS,DOMAIN,CONTACTS,CONTACTADDR,MEMBERREPLIESTO,OFFICERREPLIESTO,GROUPREPLIESTO,ONEMBRGROUPSPUBLIC,FROMADDRFORMAT,SUBJECTPREFIX,CLUBEMAILADDR,EMAILWHITELIST,EMAILBLACKLIST,USESYSTEMBLACKLIST,ADDSPAMLINKS,NOSPOOFPHRASE,SPAMTHRESHOLD,AGENDAEMAILNOTES,AGENDAPRINTNOTES,AGENDAPRINTDATES FROM CLUBSITES WHERE DOMAIN IN (?,?) LIMIT 1 (Bind Values=ecbtoastmasters.org.nz www.ecbtoastmasters.org.nz)] Error=[Unknown column 'AGENDAEMAILNOTES' 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 'AGENDAEMAILNOTES' in 'field list' at /var/www/cgibin/dbi_db.pl line 278. -->
[Wed Apr 25 08:48:19 2018] tcmail.pl: GetRowsAsHashes_DBI[CLUBSITES](Callers=>main::GetFields_DBI>main::GetFields_ClubSitesDB): Unable to execute query: [SELECT CLUBNUMBER,CLUBTZ,ADMINEMAIL,ADMINNAME,DATECREATED,DATEUPDATED,ALIAS,DOMAIN,CONTACTS,CONTACTADDR,MEMBERREPLIESTO,OFFICERREPLIESTO,GROUPREPLIESTO,ONEMBRGROUPSPUBLIC,FROMADDRFORMAT,SUBJECTPREFIX,CLUBEMAILADDR,EMAILWHITELIST,EMAILBLACKLIST,USESYSTEMBLACKLIST,ADDSPAMLINKS,NOSPOOFPHRASE,SPAMTHRESHOLD,AGENDAEMAILNOTES,AGENDAPRINTNOTES,AGENDAPRINTDATES FROM CLUBSITES WHERE DOMAIN IN (?,?) LIMIT 1 (Bind Values=ecbtoastmasters.org.nz www.ecbtoastmasters.org.nz)] Error=[Unknown column 'AGENDAEMAILNOTES' in 'field list']
554 5.3.0 unknown mailer error 255
Thanks