~~~~~~~~~~~~ IMPORTANT INFORMATION -- Please read! ~~~~~~~~~~~~

1. The "search..." box above searches the Docs & Forum Posts. The "Search" tab above just searches the Forum Posts. :side:
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.

"Unable to execute query" error when sending email to custom group

  • gpeters
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 4 months ago #62262 by gpeters
"Unable to execute query" error when sending email to custom group was created by gpeters
Hi Steve,
When I am emailing a custom group on our FTH site, called vpmupdates, I get the following query error as a bounce back mail. Also, the email does not get sent to the members of the group.
Could you please assist with this issue?
Many thanks,
Geoff Peters

The original message was received at Sun, 2 Apr 2017 04:14:04 GMT
from mail-qk0-f181.google.com [209.85.220.181]
The following addresses had permanent fatal errors
|/etc/tcmail.pl
(reason: 255)
(expanded from: <vpmupdates@tmclub59.com>)
Transcript of session follows
[Sun Apr 2 04:14:10 2017] tcmail.pl: DBD::mysql::db selectall_arrayref failed: Unknown column 'NOPHISHPRASE' in 'field list' at /var/www/cgi-bin/dbi_db.pl line 287, <> line 77.
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,REGDATE,ALIAS,DOMAIN,CONTACTS,CONTACTADDR,MEMBERREPLIESTO,OFFICERREPLIESTO,GROUPREPLIESTO,ONEMBRGROUPSPUBLIC,FROMADDRFORMAT,SUBJECTPREFIX,CLUBEMAILADDR,EMAILWHITELIST,EMAILBLACKLIST,USESYSTEMBLACKLIST,ADDSPAMLINKS,NOPHISHPRASE,SPAMTHRESHOLD,AGENDAEMAILNOTES,AGENDAPRINTNOTES,AGENDAPRINTDATES FROM CLUBSITES WHERE DOMAIN IN ('tmclub59.com',' www.tmclub59.com ') (Bind Values=)] Error=[Unknown column 'NOPHISHPRASE' 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 'NOPHISHPRASE' in 'field list' at /var/www/cgi苑in/dbi_db.pl line 287, 姣 line 77. -->
[Sun Apr 2 04:14:10 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,CONTACTS,CONTACTADDR,MEMBERREPLIESTO,OFFICERREPLIESTO,GROUPREPLIESTO,ONEMBRGROUPSPUBLIC,FROMADDRFORMAT,SUBJECTPREFIX,CLUBEMAILADDR,EMAILWHITELIST,EMAILBLACKLIST,USESYSTEMBLACKLIST,ADDSPAMLINKS,NOPHISHPRASE,SPAMTHRESHOLD,AGENDAEMAILNOTES,AGENDAPRINTNOTES,AGENDAPRINTDATES FROM CLUBSITES WHERE DOMAIN IN ('tmclub59.com',' www.tmclub59.com ') (Bind Values=)] Error=[Unknown column 'NOPHISHPRASE' in 'field list']
554 5.3.0 unknown mailer error 255

Final-Recipient: RFC822; vpmupdates@tmclub59.com
X-Actual-Recipient: X-Unix; |/etc/tcmail.pl
Action: failed
Status: 5.0.0
Diagnostic-Code: X-Unix; 255
Last-Attempt-Date: Sun, 2 Apr 2017 04:14:10 GMT

Forwarded message
From: Geoff Peters
To: vpmupdates@tmclub59.com
Bcc:
Date: Sat, 1 Apr 2017 21:14:02 -0700
Subject: Update on club website security
The topic has been locked.
More
8 years 4 months ago - 8 years 4 months ago #62263 by SteveTheTechie
Replied by SteveTheTechie on topic "Unable to execute query" error when sending email to custom group
All good now... I made a boo-boo. :blush:

NOPHISHPRASE should be NOPHISHPHRASE (typo gets me every time lol)
Last edit: 8 years 4 months ago by SteveTheTechie.
The following user(s) said Thank You: gpeters
The topic has been locked.
  • gpeters
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 4 months ago #62264 by gpeters
Replied by gpeters on topic "Unable to execute query" error when sending email to custom group
Awesome thanks for the quick fix Steve :) Best wishes, Geoff
The following user(s) said Thank You: SteveTheTechie
The topic has been locked.
Moderators: Brian, Jane Atkinson, Pam, rhtaylor3, marc33, NotLiable, jgavin, Lcala305
Time to create page: 0.098 seconds

Copyright © 2025 FreeToastHost 3 Support. All Rights Reserved.