POP3 General Error 3988 Errors

Problem

Admins receive a POP3 Connection Error email with a Error: SQLSTATE[HY000]: General error: 3988 error:

Error: SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_unicode_ci into latin1_swedish_ci impossible for parameter (SQL: insert into tblticketmaillog...

Cause

MySQL® cannot convert the table in the error message into the indicated character set.

Solution

To resolve the error, run the following command in MySQL to ensure that the table has the recommended collation setting:

ALTER TABLE tblticketmaillog CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Before you make changes to the database, you must back it up.

Last modified: June 11, 2024