Hi @WSMH,
I saw this topic: DB Error in OJS 3.2.0.0 - illegal mix of collations - #2 by asmecher. But before I change it, I’ll investigate it.
In my case, this tables are in the searching:
- submissions
- publication_settings
- publications
- issues
- submission_search_objects
- submission_search_object_keywords
- submission_search_keyword_list
All the tables are in utf8_general_ci. I used this query to discover what type of charset are used in the columns os this tables:
SELECT column_name, character_set_name FROM information_schema.COLUMNS
WHERE table_name in (“submissions”, “publication_settings”, “publications”, “issues”, “submission_search_objects”, “submission_search_object_keywords”, “submission_search_keyword_list”)
Some columns are with utf8 and others with null.
I’ll recover my database before the update to understand if it always had this nulls fields or if the ocurr after the update.