Internal Error when Imported task

[githubIMC]

Checklist

• [x ] I verified that Kanboard is correctly installed
• [x ] I verified that the problem does not come from a plugin
• [x ] I verified that the problem is not already reported
• [x ] I understand that Kanboard is in maintenance mode. It doesn't mean it's abandoned, but there is no significant feature development

Actual behaviour

When I want to imported task ia have a error:
Internal Error: SQL Error[22007]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE9rer l...' for column kanboard.tasks.title at row 1

Expected behaviour

I want to imported task

Steps to reproduce

Screenshots

Logs

Configuration

• Kanboard version: 1.2.33
• Database type and version: 10.5.19-MariaDB-0+deb11u2
• PHP version: 8.0.30
• OS: Linux 5.10.0-24-amd64
• Browser: firefox

[fguillot]

Can you provide the CSV file used to import the tasks? It's hard to guess what is wrong without it.

[bo-wu]

@fguillot I got similar error, if the csv file contains Chinese character. And finally I figure out it is problem of Windows office Excel, even if I set the encode to utf-8.

But use other editor, no such problem