At first: Good job dude! I would lost without this script.
I've migrate a sqlite db with actual git version of kanboard but with interupt.
ERROR 1366 (22007) at line 1157: Incorrect string value: '\xF0\x9F\x91\x8D\x0A-...' for column 'comment' at row 1
Problem is this emoji: 👍
I've changed the charset of mysql database to utf8mb4_bin. That works until the migration is already done but not for the migration itselve.
Fortunately I had just two of that chars in my projects so I could change them before migration. When kanboard is running with mysql connection you can add emojis in your comments.
At first: Good job dude! I would lost without this script.
I've migrate a sqlite db with actual git version of kanboard but with interupt.
ERROR 1366 (22007) at line 1157: Incorrect string value: '\xF0\x9F\x91\x8D\x0A-...' for column 'comment' at row 1Problem is this emoji: 👍
I've changed the charset of mysql database to utf8mb4_bin. That works until the migration is already done but not for the migration itselve. Fortunately I had just two of that chars in my projects so I could change them before migration. When kanboard is running with mysql connection you can add emojis in your comments.
Cheers Tino