Cannot add question

[Jackychen187]

system Ubuntu 22.04
software php8.1 mysql-server-8.0 Apache2
The database I used is too new, it can not create questions, after clicking to add questions, it will appear the following screenshot:

I checked the log, found that the default character set used is utf8mb4, I changed it to utf8_bin, and then I can add questions and answers, I found that there are other errors in the log, but it can still be used normally.Could you please help to see how to repair, thank you
PHP Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 4 in /var/www/html/tcexam/shared/code/tce_db_dal_mysqli.php:89\nStack trace:\n#0 /var/www/html/tcexam/shared/code/tce_db_dal_mysqli.php(89): mysqli_query()\n#1 /var/www/html/tcexam/admin/code/tce_edit_question.php(533): F_db_query()\n#2 {main}\n thrown in /var/www/html/tcexam/shared/code/tce_db_dal_mysqli.php on line 89, referer: https://tcexam.com.cn/admin/code/tce_edit_question.php

[ausky9]

@Jackychen187 I have the same problem. May I know how to change character set from utf8mb4 to utf8_bin?

[Jackychen187]

@Jackychen187 I have the same problem. May I know how to change character set from utf8mb4 to utf8_bin?

ALTER DATABASE your_database_name CHARACTER SET utf8 COLLATE utf8_bin;