mysql_stmt_execute error: *Incorrect string value: '\xFD\xB4\xD7\x9D;\xD7...' for column 'name' at row 1* (errno: 1366)

[kent fan]

Error Message :

Jul 18 13:36:15 localhost piler[2909]: 4000000055a9e5d90cf6ee7c009627c4fc99: mysql_stmt_execute error: Incorrect string value: '\xFD\xB4\xD7\x9D;\xD7...' for column 'name' at row 1 (errno: 1366)

piler version is : 1.1.1

DB is : mariadb-server-5.5.41-2.el7_0.x86_64

mysql> show create database piler; +----------+----------------------------------------------------------------+ | Database | Create Database | +----------+----------------------------------------------------------------+ | piler | CREATE DATABASE piler /!40100 DEFAULT CHARACTER SET utf8 / | +----------+----------------------------------------------------------------+ 1 row in set (0.00 sec)

[Janos SUTO]

There was a similiar topic, see #471. In that case the sph_index.body column had problems. In your case it might be the attachment.name column. Can you show me the content-type, content-disposition, etc. headers for the attachments of this email as they appear in the eml file?

[kent fan]

After I downgrade mysql 5.6 to 5.5, everything works fine.

[Janos SUTO]

OK, however you wrote 5.5, and that's what confused me.

[kent fan]

mariadb-server-5.5.41-2.el7_0.x86_64 is obsoleted by mysql-community-server-5.6.23-3.el7.x86_64

[kent fan]

Is it possible to support mariadb 5.5(mysql 5.6) ?

[eXtremeSHOK]

There would be no reason to support mariadb 5.5 which is MariaDB 5.3 + MySQL 5.5.... its end of life and a dead product.

Upgrade to the MariaDB 10.0 Series which is built on the MariaDB 5.5 series with backported features from MySQL 5.6

The upgrade is seamless, just edit the repo information and run the package updater.