View Issue Details

IDProjectCategoryView StatusLast Update
0018848phplist applicationBounce Managementpublic06-09-17 15:26
ReporterAppletech 
PriorityhighSeveritymajorReproducibilityhave not tried
Status newResolutionopen 
Product Version3.3.1 
Target VersionFixed in Version 
Summary0018848: SQL error when Processing bounces
DescriptionI am setting up a new system, and have configured processbounces to run as a cron job. 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: noabounce2@noa.gr
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: noabounce2@noa.gr
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: noabounce2@noa.gr
Precedence: bulk
Bounces-To: listsender2@noa.gr
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

Additional InformationAlthough Bounces have not been processed correctly, the bounced messages have been deleted from the bounce mailbox.
TagsNo tags attached.

Activities

Appletech

06-09-17 15:26

reporter   ~0059359

When the above error occurred, the System Event Log recorded the following message: "Database error: Data too long for column 'data' at row 1". Page: "processbounces".