Welcome, Guest

1. The "search..." box above searches the Docs & Forum Posts. The "Search" tab above just searches the Forum Posts.

Please use these to search for your issue *before* creating a new message topic, as your issue may have been previously solved.
2. Please put your Club # and Club Web Address in your Forum Signature (best) OR in each post to get faster support from us.
Click here to edit your signature at the bottom of the Profile Information tab.
3. Our user and admin docs are available at: support.toastmastersclubs.org/doc "There's a doc for that!"
4. There is an "Opt In" Feature for newly added members. The Opt In document explains the ~~strikethrough~~ member information. Click Here to View the Post
5. When posting a New Topic , please include all relevant details and be specific. When did your issue 1st occur? What operating system, browser, & browser version are you using? Did you refresh your browser cache? Are your cookies enabled? Lastly, a screen shot is often helpful.
6. Please abide by the Terms of Use . We are volunteers contributing our spare time. We are happy to assist you, so long as you are respectful and courteous.
7. We are always looking for new FreeToastHost Ambassadors to join our team and support fellow Toastmasters in their use of the FreeToastHost website system. If you are familiar with the system and have some interest, send a Send Us a Private Message.

Page:
1

TOPIC:

Unable to send group email 5 years 11 months ago #68474

mightymuke
Topic Author
Offline
New Member
Posts: 7
Thank you received: 1

Hi,

Recently we have been unable to send emails to a group (officers) on our site.
We receive the following response (via email)

[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=&gt;main::GetFields_DBI&gt;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

The topic has been locked.

Unable to send group email 5 years 11 months ago #68480

Brian Offline Administrator Posts: 11644 Thank you received: 3880	The programmer has been notified. Thank you, Brian McDonald DTM, PDD D61 FTH Lead Technical Support member Cataraqui Valley Toastmaster 9560
	The topic has been locked.

Unable to send group email 5 years 11 months ago #68484

shawnseaton Offline New Member Posts: 4 Thank you received: 2	We are having the same issue on our site. Thanks.
	The topic has been locked.

Unable to send group email 5 years 11 months ago #68487

Mark.Spillmann Offline New Member Posts: 2 Thank you received: 1	Same for us. We are getting Returned mail: see transcript for details when we try to send an email to our club members (This email address is being protected from spambots. You need JavaScript enabled to view it.) It was working yesterday, with no issues
	The topic has been locked.

Unable to send group email 5 years 11 months ago #68492

SteveTheTechie Offline FreeToastHost Developer Posts: 13529 Thank you received: 3831	fixed Regards, Steve James, DTM FreeToastHost System Developer Officer Emeritus, Mindful Communicators (Club 1966, District 52) A President's Distinguished Club for each of the last 10 years. >>> Please put your club number in your forum profile. CLICK here to edit your profile.
	The topic has been locked.

Unable to send group email 5 years 11 months ago #68496

mightymuke Topic Author Offline New Member Posts: 7 Thank you received: 1	Works for me now. Thanks The following user(s) said Thank You: SteveTheTechie
	The topic has been locked.