Hello all …
I’m facing this very problem with our OJS 3.3.0.5 Multilingual - multijournal installation…
I had reports about the search not working so I tried to rebuild the index as I have done in the past (Need help fixing keywords encoding or regenearting keywords table - OJS 3.2.1.1)
Sadly… now the process is not working
If I do
select table_name, table_schema, table_collation from information_schema.tables where table_schema='revistasuncu';
Most of the tables are reported with a table_collation of utf8_general_ci the rest of them have utf8mb4_general_ci
The rebuildSearchIndex.php result:
php tools/rebuildSearchIndex.php
Restablecer índice ... hecho
Indexando "Revista de Turismo e Identidad" ... PHP Warning: Invalid argument supplied for foreach() in /var/www/html/ojs3/lib/pkp/classes/submission/SubmissionKeywordDAO.inc.php on line 57
PHP Warning: Invalid argument supplied for foreach() in /var/www/html/ojs3/lib/pkp/classes/submission/SubmissionKeywordDAO.inc.php on line 57
PHP Warning: Invalid argument supplied for foreach() in /var/www/html/ojs3/lib/pkp/classes/submission/SubmissionLanguageDAO.inc.php on line 57
14 artículos indexados
Indexando "Experticia" ... 23 artículos indexados
Indexando "Revista de Médica Universitaria" ... 0 artículos indexados
Indexando "Revista EUROPA" ... 21 artículos indexados
Indexando "ENCUENTRO EDUCATIVO. Revista de investigación del Instituto de Ciencias de la Educación" ... 49 artículos indexados
Indexando "Revista de Historia Universal" ... PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' in /var/www/html/ojs3/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 /var/www/html/ojs3/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)
#1 /var/www/html/ojs3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(370): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/html/ojs3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 /var/www/html/ojs3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback(Object(Illuminate\Database\Query\Expression), Array, Object(Closure))
#4 /var/www/html/ojs3/l in /var/www/html/ojs3/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
Clearly something is wrong within the “Revista de Historia Universal” journal … but I haven’t been able to detect the problem… I have been working several days hunting down and fixing all kinds of mojibake without success, at least in the search index front…
Could someone guide me towards what tables are involved in the search index building process? Because maybe I’m focusing in the wrong ones 
What I mean is … which tables are parsed to fill i.e. the submission_search_keyword_list …
Thanks in advance!