back to phpList.org

Error 1366 When Processing Bounces


#1

When processing bounces I am still getting errors that I’ve been getting for months now. I am running v3.4.0

Database error 1366 while doing query Incorrect string value: ‘\xEAtre l…’ for column LIST_phplist_new.phplist_bounce.header at row 1
Database error 1366 while doing query Incorrect string value: ‘\xEAtre l…’ for column LIST_phplist_new.phplist_bounce.header at row 1
Database error 1366 while doing query Incorrect string value: ‘\x92s e-m…’ for column LIST_phplist_new.phplist_bounce.header at row 1
Database error 1366 while doing query Incorrect string value: ‘\x92s e-m…’ for column LIST_phplist_new.phplist_bounce.header at row 1


#2

@keeenone It looks to be some badly-formed UTF8 characters, which mysql is complaining about. The simplest solution is to delete all bounces from within phplist, or using phpmyadmin find and delete those specific rows.


#3

So I tried to delete all processed bounces older than 2 months, but it says zero were deleted. There are bounces going back to Feb. 2019, but it won’t delete them. This tool doesn’t seem to be working.