Important: when posting, please provide your Club Number at a minimum, and as many details as possible.
For further info, please read This page before posting.

SQL error when email officers

  • Larson
  • Larson's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 2
  • Thanks: 2

SQL error when email officers

9 years 2 months ago
#60065
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/
The topic has been locked.
  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Emeritus
  • Emeritus
  • Posts: 11492
  • Thanks: 3057

Re: SQL error when email officers

9 years 2 months ago - 9 years 2 months ago
#60066
:oops: fixed
Last edit: 9 years 2 months ago by SteveTheTechie.
The following user(s) said Thank You: Larson
The topic has been locked.
  • Larson
  • Larson's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 2
  • Thanks: 2

Re: SQL error when email officers

9 years 2 months ago
#60067
works now!
The following user(s) said Thank You: SteveTheTechie
The topic has been locked.
Moderators: BrianHeniPamrhtaylor3marc33NotLiableNSBjgavinLcala305peterb323DebbieT
Time to create page: 0.142 seconds