Error during submission in step 3

Software Support
1

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

  1. Start a submission
  2. At step 3 fill in all the filed (copy & paste from a word document)
  3. Press next button
  4. The page odesn’t move to complete submission

What application are you using?
OJS 3.3.0.13

Additional information
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?

Thank you
Domenico

2

Hi @Domenico

It is recommended to use utf8_general_ci as table collations with utf8 as the default charset. You can learn from this URL how to fix mixed encoding: ojs-tools/fix-database-encoding.md at master · kaitlinnewson/ojs-tools · GitHub

It is related to latin1 to utf8, but you can adjust it to your case.

Best,
Israel

3

Thanks for you help Israel :slight_smile: