Describe the issue or problem
While sending a contribution, in step 3, after filling in the various fields, if I press forward the page remains pending, and an error is generated in the error.log file as you find in the “Additional information”
Steps I took leading up to the issue
- Start a submission
- At step 3 fill in all the filed (copy & paste from a word document)
- Press next button
- The page odesn’t move to complete submission
What application are you using?
This is the error in the error log
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9D\x9B\xBC =…’ for column ‘setting_value’ at row 1…etc.
Investigating the forum I saw that there may be errors in database collation in relation to utf8 and latin.
Checking in my database all tables are innoDB. The strange thing is that some tables collation are utf8mb3_general_ci and others utf8mb3_bin.
What is the best collation to convert tables to (if needed)? Or I have to investigate something else?