When trying to publish a new issue only a fraction of the articles get published

Software Support
1

Hi,
we are running 3 journals on OJS 3.3.0.14 (separate installs, same server, same server configuration). Two of the journals recently run into the problem that when trying to publish a new issue only a fraction of the articles get published. In the preview all articles are shown as intended.

The only error appearing in the logs is: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8_general_ci into latin1_swedish_ci impossible for parameter in /“rootfolder”/apps/ojs-3.3.0-14/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119

These are both installations with a history of updates and moving between servers, originally the database was latin1_swedish_ci but was converted to utf8 (all tables). Which makes it strange that latin1_swedish_ci is still mentioned in the php error log.

I hope somebody can shine a light on this. Thx

2

Hi @hansc,

I would suggest running a mysqldump of your database and looking through it for instances of latin1 (case insensitive). Chances are there is still something in a latin1 encoding.

Regards,
Alec Smecher
Public Knowledge Project Team

4

Thank you, I will try that

1 Like
5

This topic was automatically closed after 12 days. New replies are no longer allowed.