Help Center

Troubleshooting 'General Error: 3988 Conversion from Collation utf8mb3_unicode_ci into latin1_swedish_ci Impossible for Parameter

Troubleshooting error 3988 related to collation conversion, Resolving issues with character set conversions, Fixing 'Conversion impossible for parameter' errors in WHMCS 1
Print

Symptom

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

The full error detail reads:

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, edit the MySQL database structure to ensure that the table has the recommended collation setting.

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

ALTER TABLE tblticketmaillog CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

If, after you make these changes, the error persists, or if you are not  comfortable making these changes to your WHMCS database, create a technical support ticket.

 
 
The End! should you have any inquiries, we encourage you to reach out to the Vercaa Support Center without hesitation.

Was this answer helpful?

Still need a hand?

Our support team is on standby if this article didn't fully answer your question.

« Back