I have posted bug https://mantis.phplist.org/view.php?id=18848 in the bug tracker for this issue, but I thought I should post about it here too.
I am setting up a new system, and I have configured processbounces to run as a cron job, using:
phplistusr /usr/bin/php /var/webs/campaign/www/admin/index.php -pprocessbounces -c/var/webs/campaign/www/config/config.php
I sent a test campaign to an experimental subscriber list with 6 members, one of which is fake, so as to test bounces.
When the cron job ran, I received the following cron job report:
phpList version 3.3.1 (c) 2000-2017 phpList Ltd, http://www.phplist.com [^] PHPlist - bounces to fetch from the mailbox PHPlist - Please do not interrupt this process PHPlist - UID0 MSGID0 PHPlist - Database error 1406 while doing query Data too long for column 'data' at row 1 PHPlist - Sql error insert into phplist_bounce (date,header,data) values("2017-09-06 15:24","Return-Path: Delivered-To: firstname.lastname@example.org Received: from vmail2.noa.gr by vmail2.noa.gr with LMTP id ODL2K+vor1n5BQAAcV+qjQ for ; Wed, 06 Sep 2017 15:24:11 +0300 Received: from campaign.noa.gr (vweb2.noa.gr [IPv6:2001:648:2011:15::164]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by vmail2.noa.gr (IC-XC-NI-KA) with ESMTPSA id 3049080004F2F for ; Wed, 6 Sep 2017 15:24:11 +0300 (EEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=noa.gr; s=default; t=1504700651; bh=ciq4wSn3COUw0dY4S7zz7BDnc6PbTD3uAQ3+lr06lBY=; h=Date:To:From:Subject:List-Unsubscribe; b=RdratLrhK51wzfrf16NU8/XxbBKRpPEo7AciMqMnA2zf4a/+V6GIphLpHaQyZWCFo 5TOD9gnRPJmNe+qLYaC6iBUO2AatyUZtYjc9A5M4VDk73KD/Qz1hiIyEGC029SRU2L TkCeWPdSNq4UjHymUUiXoinZlLf+Zs7p9VLWNqUc= Date: Wed, 6 Sep 2017 15:24:11 +0300 To: email@example.com From: PHPList Master Subject: PHPlist Message queue processing report Message-ID: X-Mailer: PHPMailer 5.2.22 (https://github.com/PHPMailer/PHPMailer [^]) X-phpList-version: 3.3.1 X-MessageID: systemmessage X-ListMember: firstname.lastname@example.org Precedence: bulk Bounces-To: email@example.com List-Unsubscribe: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=\"b1_4cba289a9bf61c9523cd9c91d4846634\" ","This is a multi-part message in MIME format. --b1_4cba289a9bf61c9523cd9c91d4846634 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable The following events occured while processing the message queue: [Wed 6 Sep 2017 15:24] [CL] Started [Wed 6 Sep 2017 15:24] [CL] Sending in batches of 200 emails [Wed 6 Sep 2017 15:24] [CL] select id from phplist_message where status not in (\"draft\", \"sent\", \"prepared\", \"suspended\") and embargo=20 --b1_4cba289a9bf61c9523cd9c91d4846634 Content-Type: multipart/related; boundary=\"b2_4cba289a9bf61c9523cd9c91d4846634\" --b2_4cba289a9bf61c9523cd9c91d4846634 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =20 The following events occured while processing the message queue:=0A=0A[Wed = 6 Sep 2017 15:24] [CL] Started=0A[Wed 6 Sep 2017 15:24] [CL] Sending in bat= ches of 200 emails=0A[Wed 6 Sep 2017 15:24] [CL] select id from phplist_me= ssage where status not in (\"draft\", \"sent\", \"prepared\", \"suspended\") and em= bargo PHPlist - Deleting message 1 PHPlist - UID0 MSGID0 PHPlist - Deleting message 2 PHPlist - UID0 MSGID0 PHPlist - Deleting message 3 PHPlist - UID0 MSGID0 PHPlist - Deleting message 4 PHPlist - Closing mailbox, and purging messages PHPlist - reprocessing PHPlist - 3 bounces to reprocess PHPlist - 3 out of 3 processed PHPlist - 0 bounces were re-processed and 0 bounces were re-identified PHPlist - Identifying consecutive bounces PHPlist - Nothing to do PHPlist - total of 0 subscribers processed
Can you please advise me on whether this is a bug (as I think) and what I can do about it?
What does the indicated error (“Database error 1406 while doing query Data too long for column ‘data’ at row 1”) mean?
Thanks a lot,