Bug 621224 – Can't send mail to [e-mail]

• Status: CONFIRMED
• Product: Websites

[Description Bodo Thiesen 2017-06-08 16:12:05 UTC]

From: [e-mail] (Mail Delivery System)
To: [e-mail]
Subject: Undelivered Mail Returned to Sender
Date: Thu,  8 Jun 2017 15:50:26 +0000 (UTC)

This is the mail system at host smtp.gentoo.org.

I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.

For further assistance, please send mail to postmaster.

If you do so, please include this problem report. You can
delete your own text from the attached returned message.

                   The mail system

<[e-mail]> (expanded from <[e-mail]>): host
    mx1.mthode.org[2001:470:e1cc:1:8888:efff:fe99:706d] said: 550 5.7.23
    <[e-mail]>: Recipient address rejected: Message rejected due to:
    SPF fail - not authorized. Please see
    http://www.openspf.net/Why?s=mfrom;id=[e-mail];ip=2001:470:ea4a:1:5054:ff:fec7:86e4;r=<UNKNOWN>
    (in reply to RCPT TO command)

From: Bodo Thiesen <[e-mail]>
To: [e-mail]
Subject: Error while searching for already existing bug:
Date: Thu, 8 Jun 2017 17:50:09 +0200
X-Mailer: Claws Mail 3.14.1 (GTK+ 2.24.28; x86_64-pc-linux-gnu)

Searching for already existing bug on page:

https://bugs.gentoo.org/enter_bug.cgi?product=Gentoo%20Linux&format=guided

time & date: Right now, reproducible.

Regards, Bodo

Software error:

DBD::mysql::db selectcol_arrayref failed: syntax error, unexpected $end [for Statement "SELECT bugs.bug_id AS bug_id, (MATCH(bugs_fulltext_1.comments_noprivate) AGAINST('rsync error: some files attrs were not transferred (see previous errors' IN BOOLEAN MODE) + MATCH(bugs_fulltext_1.short_desc) AGAINST('rsync error: some files attrs were not transferred (see previous errors' IN BOOLEAN MODE)) AS relevance
  FROM bugs
LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id AND NOT ( security_map.group_id IN (47) )
LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND security_cc.who = 29624
LEFT JOIN bugs_fulltext AS bugs_fulltext_1 ON bugs.bug_id = bugs_fulltext_1.bug_id
LEFT JOIN bugs AS bugs_g4 ON bugs.bug_id = bugs_g4.bug_id
 WHERE bugs.creation_ts IS NOT NULL
   AND (security_map.group_id IS NULL
        OR (bugs.reporter_accessible = 1 AND bugs.reporter = 29624)
        OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
        OR bugs.assigned_to = 29624
)
   AND (  bugs.product_id IN (1)  AND ( MATCH(bugs_fulltext_1.comments_noprivate) AGAINST('rsync error: some files attrs were not transferred (see previous errors' IN BOOLEAN MODE) OR MATCH(bugs_fulltext_1.short_desc) AGAINST('rsync error: some files attrs were not transferred (see previous errors' IN BOOLEAN MODE) ) ) AND bugs.delta_ts >= '2016-12-08 15:47:49' AND ( 1 = 1 AND bugs_g4.creation_ts >= '2016-12-08 15:47:49' )
GROUP BY bugs.bug_id
ORDER BY relevance DESC
LIMIT 500
"] at Bugzilla/Search.pm line 775.
	Bugzilla::Search::data(Bugzilla::Search=HASH(0x6dac623b8e0)) called at /var/www/bugs.gentoo.org/htdocs/buglist.cgi line 742
For help, please send mail to the webmaster ([e-mail]), giving this error message and the time and date of the error.


Reproducible: Always

[Comment 1 Bodo Thiesen 2017-06-08 16:14:14 UTC]

Note: I made a second ticket for the "I can't search in bugzilla" bug here:
https://bugs.gentoo.org/show_bug.cgi?id=621226

So, this one is only about the sending mail failure

[Comment 2 Jonas Stein 2017-11-12 19:38:56 UTC]

Tested now with 
[e-mail] -> worked
personal mail address -> no reply.