Error running dap --loglevel info initdb --table courses

Question

I am getting an error running DAP (version dap 0.3.14) initdb for our MySQL courses table. The error message is "Incorrect string value: '\xE2\x80\xA8200...' for column 'syllabus_body' at row 96"). The course ID is 7751. The full command is:

dap --loglevel info initdb --table courses

A redacted log file is attached.

daniel_powers · Accepted Answer

The issue is related to the handling of utf8 data by our older, MySQL 5.7 database. The issue was resolved by altering the database to use the newer MySQL utf8 character set and collation. The resolution was described here:

https://dba.stackexchange.com/questions/8239/how-to-easily-convert-utf8-tables-to-utf8mb4-in-mysql-5-5/21684#21684