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.

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

  • gpeters
  • gpeters's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 17
  • Thanks: 5

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

8 years 11 months ago
#62262
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=>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']
</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.
  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Emeritus
  • Emeritus
  • Posts: 11492
  • Thanks: 3057

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

8 years 11 months ago - 8 years 11 months ago
#62263
All good now... I made a boo-boo. :blush:

NOPHISHPRASE should be NOPHISHPHRASE (typo gets me every time lol)
Last edit: 8 years 11 months ago by SteveTheTechie.
The following user(s) said Thank You: gpeters
The topic has been locked.
  • gpeters
  • gpeters's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 17
  • Thanks: 5

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

8 years 11 months ago
#62264
Awesome thanks for the quick fix Steve :) Best wishes, Geoff
The following user(s) said Thank You: SteveTheTechie
The topic has been locked.
Moderators: BrianHeniPamrhtaylor3marc33NotLiableNSBjgavinLcala305peterb323DebbieT
Time to create page: 0.145 seconds

Latest Forum Posts